ORACLE ASSGN-4

1. Create a query to display the last name and salary of employees earning more than $12,000.
Place your SQL statement in a text file named lab4_1.sql. Run your query.
2. Create a query to display the employee last name and department number for employee number
176.
3. Modify lab4_1.sql to display the last name and salary for all employees whose salary is
not in the range of $5,000 and $12,000. Place your SQL statement in a text file named lab4_3.sql

4. Display the employee last name, job ID, and start date of employees hired between February
20, 1998, and May 1, 1998. Order the query in ascending order by start date.
5. Display the last name and department number of all employees in departments 20 and 50 in
alphabetical order by name.
6. Modify lab4_3.sql to list the last name and salary of employees who earn between $5,000
and $12,000, and are in department 20 or 50. Label the columns Employee and Monthly
Salary, respectively. Resave lab4_3.sql as lab4_6.sql. Run the statement in
lab4_6.sql.
7. Display the last name and hire date of every employee who was hired in 1994.
8. Display the last name and job title of all employees who do not have a manager.
9. Display the last name, salary, and commission for all employees who earn commissions. Sort
data in descending order of salary and commissions.
10. Display the last names of all employees where the third letter of the name is an a.
11. Display the last name of all employees who have an a and an e in their last name.
12. Display the last name, job, and salary for all employees whose job is sales representative or
stock clerk and whose salary is not equal to $2,500, $3,500, or $7,000.
13. Modify lab4_6.sql to display the last name, salary, and commission for all employees
whose commission amount is 20%. Resave lab4_6.sql as lab4_13.sql. Rerun the
statement in lab4_13.sql.