This preview shows page 1. Sign up to view the full content.
Unformatted text preview: p2q6.sql . Rerun your query. 7. Display the name and hire date of every employee who was hired in 1982. 8. Display the name and title of all employees who do not have a manager. 9. Display the name, salary, and commission for all employees who earn commissions. Sort data in descending order of salary and commissions. 10. Display the names of all employees where the third letter of their name is an A . 11. Display the name of all employees that have two L s in their name and are in department 30 or their manager is 7782. 12. Display the name, job, and salary for all employees whose job is Clerk or Analyst and their salary is not equal to $1000, $3000, or $5000. 13. Modify p2q6.sql to display the name, salary, and commission for all employees whose commission amount is greater than their salary increased by 10%. Rerun your query. Resave your query as p2q13.sql....
View Full Document
This note was uploaded on 07/15/2011 for the course ECO 2023 taught by Professor Mr.raza during the Summer '10 term at FAU.
- Summer '10