Question 4 SQL (16 points) Write SQL queries based on the following two tables. For your understanding, the partial contents of the tables are shown, but assumes that there are many more rows (e.g., tens of thousands of rows) in the tables. EMPLOYEE PK FK: Emp ID FK: PROJECT Proj_ID EmpID Name Address Salary Supervisor Project ID Johnson LR 70000 2 100 2 Lee 80000 8 100 3 Park NLR 90000 8 200 Hopson NLR 50000 300 5 Kant CWY 60000 8 300 8 Park CWY 120000 300 1 IR 4 5 PROJECT PK ProID PName Start Date EndDate Budget 100 200 300 400 B11 B12 B13 C14 11/21/02 9/1/01 3/28/03 8/1/03 11/20/03 10/30/02 4/27/04 12/30/03 1000000 900000 950000 800000 (Data Retrieval) 1) Write SQL statements to list the Project ID and the highest salary in each project only if the highest salary is greater than 100000. (2 points) 2) Write SQL statements to list in each group the project name, the total number (.e.. how many employees) of employees who make less than 70000. (2 points) 3) Write SQL statements to list the name of the employee who is working in project B13 and whose address information is unknown. (2 points) 4) I am looking for someone. I know that the second letter of his name was "e". Write SQL statements to list his name and the name of the project where he works. (2 points) 5) For each project that started after the year 2017, list the project name and the total salary for the employees who worked for the project. Include in the outcome table only if the total salary is greater than 500000. Arrange the outcome by the total salary so that the largest number comes first. (2 points) 6) Write SQL statements to list the name of Lee's subordinate emplovee. (2 points) (Data Update) 7) Write SQL statements to increase by 100000 the budget of the project whose name is starting with 'B'. 8) Write SQL statements to delete the rows for the LR (Little Rock) employees who are under the supervision of supervisor 8