$6.$ Write the SQL statement to create a report with employee employee ids, last names, job id$,$ phone numbers, and salary for all employees who make at least $$8,000$ AND their job id is IT$\_$PROG.

ALSO WRITE DOWN HOW MANY ROWS ARE DISPLAYED$/$OUTPUT AS A RESULT OF YOUR SQL STATEMENT $8.$ Perform an SQL query that displays the first names, last names, job ids, and salaries of all employees that have the job$\_$id of SA$\_$REP and also have a salary that is greater than $$10000.$ Make sure your display is sorted by $($ordered by$)$ first$\_$name in ascending order.

$9.$ Create a report that displays the first names, last names, e$-$mails, department ids, and salaries of all employees that work in Department $50($e$.$g$.$ they have department$\_$id of $50).$

Sort your display$/$output by salary in descending order. $10.$ Write the SQL statement that will output$/$display last names, job ids, and salaries for all employees that make at least $$3500$ and have a job id of SH$\_$CLERK $($Showroom Clerks$)$ or ST$\_$CLERK $($Store Clerks$).$

Your output will be eight $(8)$ different employees. Initially we will work just with the HR$.$EMPLOYEES table.

HR$.$EMPLOYEES

employee$\_$id

first$\_$name

last$\_$name

email

phone$\_$number

hire$\_$date

job$\_$id

salary

commission$\_$pct

manager$\_$id

department$\_$id