CIS 336 STUDY It's Your Life/cis336study.com CIS 336 STUDY It's Your Life/cis336study.com | Page 91

11. USE A SUBQUERY to display names of customers that have unshipped orders.
12. Display the total amount of sales made to customers in NY
13. USE A SUBQUERY to list the items( title and artist) of items that have never been ordered
14. Show the order history for Samuel Jacobsen. Display the order id, order date, ship date, and total.
15. Show the total amount of sales per sales rep. Display the employee name as a single field along with the total sales, sorted by highest to lowest sales.
This is the end of Lab 6.
=====================================================================================