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

This preview shows page 1 - 8 out of 8 pages.

The preview shows page 8 - 8 out of 8 pages.
Final TestChapters 7 – 151.Write a query to display the name, department number, and department name forall employees.
2.Create a unique listing of all jobs that are in department 30. Include the location ofdepartment 30 in the output.
3.Write a query to display the employee name, department name, and location of allemployees who earn a commission, which are all Sales positions
4.Display the employee name and department name for all employees who have anAin their name. Save your SQL statement in a file called p4q4.sql.
End of preview. Want to read all 8 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Spring
Professor
Bailey
Tags
emp, select e ename

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture