Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

use that data hurry up EMPLOYEE DEPARTMENT DEPT LOCATIONS begin{tabular}{|l|c|c|c|} hline multicolumn{1}{|c|}{ Dname } & Doumber & Mor asn & Moz_star date hline Rosoarch

use that data hurry up image text in transcribed
image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Graph Databases

Authors: Ian Robinson, Jim Webber, Emil Eifrem

1st Edition

1449356265, 978-1449356262

More Books

Students also viewed these Databases questions

Question

1. Explain what is meant by ethical behavior.

Answered: 1 week ago

Question

Determine the roles of spatial layout and functionality.

Answered: 1 week ago