1. Find all dates on which projects either started or ended. Eliminate any duplicate or NULL dates. Sort your results in descending order.

2. Use INTERSECT to find the first and last name of all employees who both work on the Robotic Spouse and for the Hardware department.

3. Use EXCEPT to find the first and last name of all employees who work on the Robotic Spouse but not for the Hardware department.

4. Find the first and last name of all employees who work on the Download Client project but not the Robotic Spouse project.

5. Find the first and last name of all employees who work on the Download Client project and the Robotic Spouse project.

6. Find the first and last name of all employees who work on either the Download Client project or the Robotic Spouse project.

7. Find the first and last name of all employees who work on either the Download Client project or the Robotic Spouse project but not both.

8. Using EXCEPT, find all of the departments without any projects.

24 Chapter T.Datduasics projects projectid deptcodename descriptionmanagerid x startdate enddate departments code? subdeptof workson projectidrevenue employeeid assignedtime employees employeeid firstname lastname deptcode salary Figure 1.5: Schema for the Employees Database