18. Write an SQL that will list the employees first name, and dependents first name and dependents birth date of all dependents who are less than 10 years old based on the date the query was run.

19. Write an SQL statement that will list the Employees first name, SSN, relationship, and dependents first name. If the employee does not have a dependent, then null (or blank) should appear as the dependents first name and relationship.

20. Write an SQL statement that will list the department number, department location, and employees first name for departments which have an office in Bellaire. Only list employees who are either older than 65, or whose salary is greater than 30000.

21. How many rows will be selected from the following SQL Statement:

SELECT D.Dnumber, DL.Dnumber

FROM DEPARTMENT D CROSS JOIN DEPT_LOCATIONS DL

ORDER BY D.Dnumber, DL.Dnumber

22. Write an SQL statement that will list the employees first name, last name, and department number who are either in department 1 or whose last name is in the range of PA through ZZ

23. Write an SQL to select the birthdate of the youngest employee.

24. Write an SQL statement to count the number of times an employee on a project has worked more than 20 hours on a project.

25. Make up an awesome query that involves at least one JOIN clause using the Company Relations database. Supply the query and the question that the query answers.