Question: From the following image construct the following queries stated below: EXAMPLE QUERY: /*Query 0. Retrieve name and address of all employees who work for the
From the following image construct the following queries stated below:

EXAMPLE QUERY:
/*Query 0. Retrieve name and address of all employees who work for the Research department.*/
SELECT e.fname, e.lname, e.address FROM employee AS e, department AS d WHERE d.dname = 'Research' AND d.dnumber = e.dno;

CONSTRUCT THE FOLLOWING 5 QUERIES
1) Retrieve first name, last name, and date of birth of all male employees with salary less than 35000.
2) Retrieve project numbers and project locations of all projects that belong to the Administration department.
3) Retrieve first name, last name, and SSN of all employees who work more than 10 hours on project 10.
4) Retrieve name, date of birth, and relationship of all male dependents of employees who work for department 5.
5) Retrieve first name, last name, date of birth, and salary of employees who manage departments with projects located in Houston.
Devartment Dependent Deptlocations Employee Works on \begin{tabular}{|l|l|l|} \hline fname & Iname & address \\ \hline John & Smith & 731 Fondren, Houston, TX \\ \hline Franklin & Wong & 638 Voss, Houston, TX \\ \hline Joyce & English & 5631 Rice, Houston, TX \\ \hline Ramesh & Narayan & 971 Fire Oak, Humble, TX \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
