Write a sub-query that returns employees


#1: SUB-QUERY - Write a sub-query that returns all orders placed on the last day of activity that can be found in the Orders table. Include the orderid, orderdate, customerid, and the employeeid.

#2: SUB-QUERY - Write a sub-query that returns the total number of orders placed by the customer with the highest number of orders. Include the customerid and the number of orders placed.

#3: SUB-QUERY - Write a sub-query that returns employees who did not place orders on or after May 1st, 1998. Include the employeeid, last and first names.

Request for Solution File

Ask an Expert for Answer!!
PL-SQL Programming: Write a sub-query that returns employees
Reference No:- TGS084900

Expected delivery within 24 Hours