Practice 2

Practice 2 - p2q6.sql . Rerun your query. 7. Display the...

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

View Full Document Right Arrow Icon
ASSIGNMENT FOR JUNE 2004 AST AND ANT SUBMISSION DATE 22 nd July 2004 Practice 2 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 named 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 in departments 10 and 30 in alphabetical order by name. 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 statement to a file named
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

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.

Ask a homework question - tutors are online