SQL

Create a file to record SQL queries, results and explanations on following questions.  Upon the completion of lab works, convert the file to Assignment3.sql and submit to blackboard.

1. List all project names and manager names in charge projects.
2. Calculate total hours worked to all projects based on each employee.
3. Suppose there are 408 work hours per year, create a view to display employee hourly rate.
4. Find out the total labor cost per employee, per project. The labor cost is hoursWorked per employee/project * employee hourly rate.
5. Alter the table employees and add column to store date of birth and hire date. Update the table with the provided data.
6. Create a new table named emp_proj_overtime which have three columns of