MySQL Question

I’m working on a mysql exercise and need an explanation and answer to help me learn.

The purpose of this assignment is to master the design of SQL retrieval queries using Company database (Links to an external site.) in XAMPP.

For each of the following four queries, create one SQL query and test it on Company database:

• List the location(s) of the department where the employee with ‘Michael’ as a dependent, works for. — [q1.sql]
• List the last name of the manager for the project ‘Computerization’ along with the number of work assignments for this project. — [q2.sql]
• List the name of project(s) managed by the ‘Research’ department with the total number of work hours assigned to each of these projects. — [q3.sql]
• List the last name of employees supervised by the manager of ‘Headquarters’ department. and the number of subordinates for each of these employees. — [q4.sql]

Upload all four query files through Canvas.

UPDATE:

1. In order to assist you in the understanding of this assignment, please watch the following video

  
https://users.cs.fiu.edu/~prabakar/cop4710/2021-01/video/GMT20210217-202348_COP4710-U0_1920x1080.mp4 (Links to an external site.)

2. The below example shows what the answer for the first query should look like. Your task is to construct the query.

/* Company database

List the location(s) of the department where the employee with ‘Michael’ as a dependent, works for.

Result: (3 rows)
DLocation
———
Bellaire
Houston
Sugarland

Remember to submit the query along with the output.

*/