1. Display the last name and salary for all employees whose salary is not in the range of $5,000 and $12,000. 2. Display the employee last name, job ID, and start date of employees hired between...


1. Display the last name and salary for all employees whose salary is not in the range of $5,000 and $12,000.


2. Display the employee last name, job ID, and start date of employees hired between February 20, 1998, and May 1, 1998.


3. Display the last name and salary of employees who earn between $5,000 and $12,000, and are in department 20 or 50.


4. 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.


5. Display the last name, salary, and commission for all employees whose commission amount is 20%.


Note: this question is related from database subject.



Jun 09, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here