I need solved by a expert

4 SQL HOMEWORK ASSIGNMENT (Due 6/18/2024 by 9 pm) You may deposit in the Digital Dropbox on Bladcboard. This homework may be done in teams of Give an expression in SQL for the following relational database schema. Note that you will have to supply arbitrary data that will enable you to obtain results for the commande Question is required then you can choose to answer any 4 for thru Be sure to show the resulting table. Extra credit for showing the iNSRT INTO command to populate data in the tables(+4). Employee (emplouidpersonntne, street, city) Work (person name, company_namej salary) Company (company name, city) Manages(person name, manager_name) 20 points each: 1) Show the DDL command(s) that could be used to create each of the 4 tables. 11 2) find the names of all employees whose salary is higher than 80000 and live on Broad St. 3) find the names of all employees that start with 'Hi' and end with zn' and also live on Peachtree Street in Atlanta. 4) find the names, street address, and cities of residence of all employees who work for Truist and earn less than -100,000 but more than 70,000 per year. 5) find the name of the employee who has the highest salary. 6) Delete the records of all employees living in Greensboro from the Employee table. [No need to show this table] 7) Determine the average salary of the employees who do not live in CNote; use J 8) find the names of all the managers who manage more than 20 employees LHjnt; Can use Nested Select OR Group