TABLES: Division (DID, dname, managerID)

Employee (EmpID, name, salary, DID)

Project (PID, pname, budget, DID)

Workon (PID, EmpID, hours)

List the total number of employees who work on project 'Web development'. Also list the total working hours for this project.

List the name of the project that 'chen' works on. (Hint: join 3 tables)

List the name of the employee who works on one or more projects with a budget over $5000. (Note: don't duplicate an employee in the list)

List the names that are shared among employees. (Note, This question was in assignment 3 but you must use a different approach than the one used in assignment 3.Hint: Use different aliases for the same table.)

List the name of the employee if he/she works on a project with a budget that is less than 10% of his/her salary. (Hint: join 3 tables)