any order, then determine the item number associated with it, then display the artist.
9. Display the total sales by artist: show artist name, total. Sort highest to lowest.
10. USE A SUBQUERY to Increase price of all items by „ No Rest for the Weary ‟ by 10 %. If working in MySQl you will need to disable safe mode. Show prices before and after. Rollback after.
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.---------------------------------------------------------------------------------------