Ensure all your column names in your SELECT clause are spelled correctly

Make sure you put commas after each column$/$attribute name in the SELECT clause and don$$t put a comma after the last column name in the SELECT clause.

Put a semicolon ; at the end of your SQL statement $3.$ Create a report to display the employee ids, last names, and salaries for all the employees whose last names are either Doran, Hall, Matos, Urman, Cambrault, or Cabrio.

For your display$/$output$,$ make sure it is sorted$/$in ascending order by salary $($In our SQL #$3$ lecture, we discussed how to sort the output$/$display of our data in the last $6$ slides$).$

Also: Write down the last name of the employee that appears first$/$at the top of your output.

$4.$ Write the SQL statement to create a report from our hr$.$employees database table that displays all the employees$$ first name, last name, email, and job id that have the job id of AD$\_$VP or IT$\_$PROG, or SH$\_$CLERK.

Order$/$sort your output$/$display by job$\_$id in descending order.

ALSO, WRITE DOWN THE FIRST AND LAST NAME OF THE PERSON AT THE BOTTOM OF THE LIST

$5.$ Write the SQL statement to create a report that displays employee first names, last names, employee ids, phone numbers, and salaries of all employees that have an employee id of $106,107,108,112$ or $114.$

Make sure your output is sorted by last name in descending order.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