Answer to Question #57499 in Databases | SQL | Oracle | MS Access for John

Question

1: Produce an unduplicated list of all product IDs for all Products that have been sold. Sort the List.
2: Show the basket ID, Product ID, Product name, and description for all items. (Do it two ways-one with an ANSI join and one with a traditional Join.)
3: Modify all queries in step 2 to include the customer's last name.
4: Display all orders (basket ID, Shopper ID, and date ordered) placed in February 2012. The date should be displayed in this format: February 12, 2012.
5: Display the total quantity sold by the product ID.
6: Modify the query in step 5 to show only products that have sold less than a quantity of 3.
7: List all active coffee products (product ID, name, and price) for all coffee items priced above the overall average of coffee items.
8: Create a table named CONTACTS that includes the following columns.