Use basic queries in SQL to retrieve the following information $($report the

SQL query as text and output$/$results of the query as screenshot in the PDF

report$)$:

$1.$ Find the names of all employees who are working on the two project

$$Middleware$$ and $$DatabaseSystems$$

$2.$ Find the names of all employees who are working on the project

DatabaseSystems and have worked more than $40$ hours.

$3.$ For every project located in Houston, list the project number, the

controlling department number, and the department manager$$s last

name, address, and birth date.

$4.$ For each employee, retrieve the employee$$s first and last name and the

first and last name of his or her supervisor.

$5.$ Retrieve female employees whose address is in Houston, TX $($use

Pattern Matching LIKE operator$)$

$6.$ Find all employees who were born in June month $($use MONTH

operator$)$

$7.$ For each department, retrieve the department name and the average

salary of all employees working in that department.

$8.$ Retrieve the names of employees who are not assigned any project.

$9.$ Retrieve the names of all employees in department $7$ who earn more

than $30000$ and work on LaserPrinters project.

$10.$List the names of all employees who are from $$Houston$,$TX$,$ and work

under the manager$$s personal number $333445555$

$11.$ Retrieve the names of employees who work in the department that has

the employees with the highest salary among all departments $($Use

nested queries and AVG$($salary$)$ in the department$)$

$12.$For each department whose average employee salary is more than $35$

$000,$ retrieve the department number, name, and the number of

employees working for that department.

$13.$Retrieve the names $($ordered alphabetically$),$ and the relationship of

dependents whose employee$$s supervisor has $333445555$ for Snn$.$

$14.$For every project, list the project name, and the total amount of hours

worked on each project, and the total amount of employees worked on

each project.

$15.$For every department, list the department name, number of projects,

and number of employees.