Project

Complete the following queries using HR Schema. Submit your answer in the form of a SQL text file to the Final Project Dropbox.

1. Show first name, last name, start date and end date for all employees. The dates come from the job_history table. Note a correct answer should return 10 records.

2. Show first name, last name, department of all of the employees with no job history.

3. Show first name, last name, department of the employees in the department with the most people. Note - this query will likely involve nested subqueries.

4. Delete the Recruiting department from the departments table.

5. Add yourself as a new employee to the data employees table.