Hello! how are you? check the attachment and Let me know if you need anything. Thank you

 

 

1. [100 pts] Using the companydb database you generated in the last quiz (Quiz 5), write SQL
scripts in the MySQL environment for the following use cases (no screenshots needed):
a) [10 pts] Using the IN clause, retrieve only the social security numbers of all employees who
work on project numbers 61, 62, 63. b) [10 pts] Using the IN clause, retrieve the first name, last name and the social security
numbers of all employees who work on project numbers 61, 62, 63. c) [10 pts] Without using the IN clause, retrieve the first name, last name and the social
security numbers of all employees who work on project numbers 61, 62, 63. d) [10 pts] Using a join clause, retrieve all project names and their department names. e) [10 pts] Without using a join clause, retrieve all project names and their department names. f) [10 pts] Using a join clause, retrieve employees who have dependents. g) [10 pts] Retrieve all employees (first name, last name) and their dependent names. You
should also get those who do not have any dependents. Hint: Use left join or right join. h) [10 pts] Get the total number of projects in the company. i) [10 pts] For each employee, get the total number of hours worked in the company. j) [10 pts] For each employee, get the total number of hours worked more than 40 hours in
the company. Bonus Question [10 pts]
The CEO wants to get a report in which he can see employees with a column "Status" which should
include either low-paid, normal-paid or over-paid values. Low-paid is for employees who work under 40
hours. Normal-paid is for employees who worked only 40 regular hours. Over-paid is for employees who
worked more than 40 hours. Retrieve employee ssn, first name, last name and status (lower-paid,
normal-paid or over-paid) of all employees.

Attachments:

• 1493694564-Q6.docx