SQL (Using attached relations if applicable) leach 3 marks, total 39: Translate all of the following queries into SQL statements. To get full marks, your answer must run with oracle 8 or above on the server. 1. Get IDEmployee names who have letter m in their surnames 2. Get a list of all different locations in the Location column of Project table 3. Add a new employee to the Employee table 4. Give details of projects worked by Townsend 5. Get all the project locations joined by Cage 6. Delete project "Cape Point" from the table Project" (you do not need to take care of table Job for this question ) 7. Add a constraint to the column surname in table employee that when a new employee is addedthere is information for the last name of the new employee. 8. How many employees join the company between 1998, January and 2000 December 9. Get the projects both Cage and Goreessem joined 10. Get project name whose budget is less than Project "Broederstroom" 11. Find the project which all employees join 12. Change the length of project name column in Project table from 25 to 40 13. Write a left-outer join sql statement and a right-outer join statement to join the information based on Employee and Job tables sorted by ID. (3 marks)