Use SQL Developer to execute SQL commands to do the following. Assume there are over 100 employees in the table so you must create the query to return all employees that meet the criteria specified.

Please separate the steps and take screenshots for the following:

List the Customer ID, Last Name, Ship Date, and Order ID for all Orders that have been delivered. Sort the output by Customer ID. (Note: You must JOIN Customer and Order.)

List the Order ID, Order Date, Product ID, and Product Name for all Orders shipped between any two dates you choose. (Note: You must use a Join and you must select dates that include at least two, but not all orders in your database).

Use a Subquery to list the Last Name and Start Date for all employees hired after Marilyn Hayes. (Note you must use Marilyn Haynes' name in the subquery, you cannot use her start date).

Use a Subquery to list the Last Name, Job Code, and Pay Rate for all Employees with the same Job Code as yours (Note: You must use your name in the subquery, you cannot use your job code).