Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please hurry up EMPLOYEE DEPARTMENT DEPT_LOCATIONS begin{tabular}{|l|c|c|c|} hline multicolumn{1}{|c|}{ Drame } & Dnumber & Mozisa & Mor_start_date hline Reseach & 5 & 333445555 &
please hurry up
EMPLOYEE DEPARTMENT DEPT_LOCATIONS \begin{tabular}{|l|c|c|c|} \hline \multicolumn{1}{|c|}{ Drame } & Dnumber & Mozisa & Mor_start_date \\ \hline Reseach & 5 & 333445555 & 19060522 \\ \hline Administration & 4 & 987654321 & 19950101 \\ \hline Headquatiors & 1 & 888665555 & 19810619 \\ \hline \end{tabular} \begin{tabular}{|c|l|} \hline Deumber & Dlocation \\ \hline 1 & Houston \\ \hline 4 & Staftord \\ \hline 5 & Belaine \\ \hline 5 & Sugarland \\ \hline 5 & Houstion \\ \hline \end{tabular} WORKS ON PROJECT \begin{tabular}{|c|c|c|} \hline Essn & Pro & Houn \\ \hline 123456780 & 1 & 32.5 \\ \hline 123456789 & 2 & 7. \\ \hline 666881411 & 2 & 10.0 \\ \hline 453453453 & 1 & 20.0 \\ \hline 403453463 & 2 & 200 \\ \hline 333446656 & 2 & 10.0 \\ \hline 333445555 & 3 & 10.0 \\ \hline 333445555 & 10 & 10.0 \\ \hline 333445555 & 20 & 100 \\ \hline 999087777 & 30 & 30.0 \\ \hline 999697777 & 10 & 10.0 \\ \hline 967987967 & 10 & 25.0 \\ \hline 987987987 & 30 & 5.0 \\ \hline 987654321 & 30 & 20.0 \\ \hline 967654321 & 20 & 15.0 \\ \hline 888665556 & 20 & NULL \\ \hline \end{tabular} DEPENDENT database schema given above write the queries in Questions 25 using the SQL nota How many supervisees does each of the supervisors working for "Research" department have? Question 5 (20 points) Which employee has the maximum number of dependents. List SSN, first name and last name of the emloyee. Hint: Use inner query with IN or NOT IN operator whichever is appropriate Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started