Practice 2 - 6. Modify p2q3.sql to list the name and salary...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Practice 2 - SQL 1. Create a query to display the name and salary of employees earning more than $2850. Save your SQL statement to a file named p2q1.sql. Run your query. 2. Create a query to display the employee name and department number for employee number 7566. 3. Modify p2q1.sql to display the name and salary for all employees whose salary is not in the range of $1500 and $2850. Resave your SQL statement to a file name p2q3.sql. rerun your query 4. Display the employee name, job and start date of employees hired between February 20, 1981, and May 1, 1981. Order the query in ascending order of start date. 5. Display the employee name and department number of all employees 10 and 30 in alphabetical order by name
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

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.

Ask a homework question - tutors are online