Answer Happy

for the database
i need the queries for these questions:
2. Select the names and Ssn of employees who work on more than
one project and count the total hours that the employees work
on.
3. For each PROJECT, retrieve the project name, number, and
location plus the number of employees who works on the project.
4. Retrieve the last name and first name of all employees who
work more than 40 hours per week total (on all their projects).
5. Select the first and last name of each employee who is a
supervisor, plus count the total number of employees
supervised by each supervisor.
6. For each project determine the total hours that employees
work on that project per week.
7. Find which employee has more than 2 dependents.
8. Find all the employee who works in the department that is
located in Atlanta. Select their first name and last name.
9. Find all the departments located in Houston and list how many
projects are their under those departments
EMME PORCE DEPENDENT