Reference no: EM13693153

Formulate the following queries

1. List the name of employee whose initial is "s"
2. List the total project budget for each division, including division ID.
3. List the total number of employee and total salary for each division, including division name (use Join, read the text for join operation)
4. List the name of division that sponsors project "Web development", List the project budget too.
5. List the total number of employee whose salary is above $40000 for each division, list division name.
6. List the total number of project and total budget for each division, show division name
7. List the name of employee that worked on more than one projects. Sort name of employee in descending order.
8. List the name of division that has more than 2 projects whose budget is over 3000.
9. List the total number of project each employee works on, including employee's name (note : there are some employees who have same names).
10. List the total number of employees who work on project "Web development". Also list the total working hours for this project.
11. List names that are shared by more than one employee and list the number of employees who share that name.
Bonus question: Use subquery to list the name and division ID of the employee(s) who make more than company's average salary. (For each bonus question 1 point will be rewarded if your answer is 100% correct)
For all your SQL assignments, save the SQL statement and its execution result for each query in a notepad file.
Important note: For each query, you show show your work in this order:
.a. copy the query question
.b. SQL statement
. c. Execution results
(you can copy the SQL statements/results and paste them into notepad document),
Note, you get bonus credits only if you provide 100% correct answer to bonus questions