Question

Q3. (30 points) Work on the Company database and perform the following queries. Please submit both the query statements and the results of the query. You should use the 'CISC3500Fall2018' database for this assignment. Q1: Retrieve names of all projects which locate in 'Chicago'; Q2: Retrieve names of departments who have projects located in 'New York'; Q3: Retrieve managers' names of departments who have projects located in 'Houston', and also list the name of projects; Q4: Retrieve the work hours of every employee on each project; Q5: Make a list of all projects that involve an employee whose last name ends with 'r', either as a worker or a manager of the department that controls the project. Q6. Find employees who have worked on all projects.

          Q3. (30 points) Work on the Company database and perform the following queries. Please
submit both the query statements and the results of the query. You should use the
'CISC3500Fall2018' database for this assignment.
Q1: Retrieve names of all projects which locate in 'Chicago';
Q2: Retrieve names of departments who have projects located in 'New York';
Q3: Retrieve managers' names of departments who have projects located in 'Houston', and also
list the name of projects;
Q4: Retrieve the work hours of every employee on each project;
Q5: Make a list of all projects that involve an employee whose last name ends with 'r', either as
a worker or a manager of the department that controls the project.
Q6. Find employees who have worked on all projects.

Q3. (30 points) Work on the Company database and perform the following queries. Please
submit both the query statements and the results of the query. You should use the
'CISC3500Fall2018' database for this assignment.
Q1: Retrieve names of all projects which locate in 'Chicago';
Q2: Retrieve names of departments who have projects located in 'New York';
Q3: Retrieve managers' names of departments who have projects located in 'Houston', and also
list the name of projects;
Q4: Retrieve the work hours of every employee on each project;
Q5: Make a list of all projects that involve an employee whose last name ends with 'r', either as
a worker or a manager of the department that controls the project.
Q6. Find employees who have worked on all projects.

Added by Amanda G.

Question

Please give Ace some feedback