Final Test With Screen Shots - Final Test 1. Chapters 7 15...

Final Test Chapters 7 – 15
1. Write a query to display the name, department number, and department name for
all employees.
2. Create a unique listing of all jobs that are in department 30. Include the location of
department 30 in the output.
3. Write a query to display the employee name, department name, and location of all
employees who earn a commission, which are all Sales positions
4. Display the employee name and department name for all employees who have an
A in their name. Save your SQL statement in a file called p4q4.sql.