Question: this database please use first question information and data List the first name and last name of all supervisors who supervise the employees working for

List the first name and last name of all supervisors who supervise the employees working for the "Research" department. Order the list by supervisor first name in ascending order. EMPLOYEE DEPARTMENT DEPT LOCATIONS \begin{tabular}{|l|c|c|c|} \hline \multicolumn{1}{|c|}{ Dname } & Doumber & Mor asn & Moz_star date \\ \hline Rosoarch & 5 & 333445555 & 19880522 \\ \hline Administration & 4 & 987654321 & 19950101 \\ \hline Headquartors & 1 & 888665555 & 19810610 \\ \hline \end{tabular} \begin{tabular}{|c|l|} \hline Doumber. & Dlocation \\ \hline 1 & Houston \\ \hline 4 & Staftord \\ \hline 5 & Belaire \\ \hline 5 & Sugarland \\ \hline 5 & Houston \\ \hline \end{tabular} WORKS_ON PROJECT \begin{tabular}{|c|c|c|} \hline Esme & Pno & Hours \\ \hline 123456789 & 1 & 32.5 \\ \hline 123456789 & 2 & 75 \\ \hline 666861111 & 3 & 10.0 \\ \hline 453453453 & 1 & 20.0 \\ \hline 463463403 & 2 & 200 \\ \hline 333445666 & 2 & 10.0 \\ \hline 333445555 & 3 & 10.0 \\ \hline 333445555 & 10 & 10.0 \\ \hline 333445555 & 20 & 10.0 \\ \hline 999887777 & 30 & 30.0 \\ \hline 999887777 & 10 & 10.0 \\ \hline 967087987 & 10 & 35.0 \\ \hline 987987987 & 30 & 5.0 \\ \hline 987654321 & 30 & 20.0 \\ \hline 987654321 & 20 & 15.0 \\ \hline 888665655 & 20 & NULL \\ \hline & & \\ \hline \end{tabular} DEPENDENT database schema given above write the queries in Questions 2-5 using the SQL note ss. List the first name and last name of all supervisors who supervise the employees working for the "Research" department. Order the list by supervisor first name in ascending order. List the first name and last name of all supervisors who supervise the employees working for the "Research" department. Order the list by supervisor first name in ascending order. EMPLOYEE DEPARTMENT DEPT LOCATIONS \begin{tabular}{|l|c|c|c|} \hline \multicolumn{1}{|c|}{ Dname } & Doumber & Mor asn & Moz_star date \\ \hline Rosoarch & 5 & 333445555 & 19880522 \\ \hline Administration & 4 & 987654321 & 19950101 \\ \hline Headquartors & 1 & 888665555 & 19810610 \\ \hline \end{tabular} \begin{tabular}{|c|l|} \hline Doumber. & Dlocation \\ \hline 1 & Houston \\ \hline 4 & Staftord \\ \hline 5 & Belaire \\ \hline 5 & Sugarland \\ \hline 5 & Houston \\ \hline \end{tabular} WORKS_ON PROJECT \begin{tabular}{|c|c|c|} \hline Esme & Pno & Hours \\ \hline 123456789 & 1 & 32.5 \\ \hline 123456789 & 2 & 75 \\ \hline 666861111 & 3 & 10.0 \\ \hline 453453453 & 1 & 20.0 \\ \hline 463463403 & 2 & 200 \\ \hline 333445666 & 2 & 10.0 \\ \hline 333445555 & 3 & 10.0 \\ \hline 333445555 & 10 & 10.0 \\ \hline 333445555 & 20 & 10.0 \\ \hline 999887777 & 30 & 30.0 \\ \hline 999887777 & 10 & 10.0 \\ \hline 967087987 & 10 & 35.0 \\ \hline 987987987 & 30 & 5.0 \\ \hline 987654321 & 30 & 20.0 \\ \hline 987654321 & 20 & 15.0 \\ \hline 888665655 & 20 & NULL \\ \hline & & \\ \hline \end{tabular} DEPENDENT database schema given above write the queries in Questions 2-5 using the SQL note ss. List the first name and last name of all supervisors who supervise the employees working for the "Research" department. Order the list by supervisor first name in ascending order
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
