CCDS$-222$ Database II

$3-$ Apply the following queries and display the result of each query on the tables that you created above:

Select all the attributes for all employees whose last name is 'Jones' or 'James'.

Select the names and Ssn of employees who work on more than one project and count the total hours that the employees work on$.$

For each PROJECT, retrieve the project name, number, and location plus the number of employees who works on the project.

Retrieve the last name and first name of all employees who work more than $40$ hours per week total $($on all their projects$).$

Select the first and last name of each employee who is a supervisor, plus count the total number of employees supervised by each supervisor.

For each project determine the total hours that employees work on that project per week.

Find which employee has more than $2$ dependents.

Find all the employee who works in the department that is located in Atlanta. Select their first name and last name.

Find all the departments located in Houston and list how many projects are their under those departments.

Note: Save all command and works because you will use it in lab $2.$

Submit vour answers in Blackboard.