* before you begin: Login to APEX using your workspace/ username/ password

1. The HR department needs a report that displays the lastname and salary of all people who earn more than $12,000.

2. Create a report that shows the last anme and department of employee number 176

3. The HR department needs a report that displays the lastname and salary of all people who earn more than $5000 but less than $12,000.

4. Create a report including the lastname, job id, and start date of matos and taylor. order the query in ascending order by start date.

5. show the lat name and department number of all employees in dept 20 or 50 in alphabetical order by name.

6. The HR department needs a report that displays the lastname and salary of all people who earn more than $5000 but less than $12,000 and are in department 20 or 50

7. Show the lastname and hire date of everyone hired in 1994

8. Write a report to show the last name and job title of everyone who does not have a manager

9. show the lastname, salary and commission of everyone woh earns a commission. Sort the report in descending order of salary and commissions

10. Show all the employee last names with the third letter being "a"

11. Show the last names of employees who have both an a and an e in their last name.

12. Show the lastname job and salary for all employees who are a sales rep or a stock clerk and whose salaries are not equal to 2500, 3500 or 7000

13. Show the employee last name, salary and commission who have a commission amount greater than 20%