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

this database please use first question information and data
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 the "Research" department. Order the list by supervisor first name in

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!