This preview shows page 1. Sign up to view the full content.
Unformatted text preview: 6. Modify p2q3.sql to list the name and salary of employees who earn more than $1500 and are in department 10 or 30. label the columns employee and Monthly Salary, respectively. Resave your sql 7. Display the name and hire date of every employee who has 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 A 11. Display the name of all employees that have two Ls in their name and are in department 30 or their manager is 7782...
View Full Document
This note was uploaded on 01/29/2012 for the course INTERNATIO 101 taught by Professor Mr.johnnash during the Spring '11 term at Symbiosis International University.
- Spring '11