Show the data in all your tables in your project document (a clear and readable screen shot)

• Customer
• Order
• Order_line
• Product
• ProductLine

The SQL command, The output, The number of rows affected.

1. List the customers who live in Plano or Seattle. Order them by zip code, from high to low.
2. What is the average standard price for all products in inventory?
3. Which orders have been placed since 10/05/2015?
4. List product name, finish, and standard price for all desks and all tables that cost more than $300 in the Product table.
5. Find only states with more than one customer.
6. For each customer who has placed an order, what is the customer's ID, name and order number?
7. What are the customer IDs and names of all customers, along with order IDs for all the orders they have placed?
8. Assemble all information necessary to make an invoice for order number 546.
9. What are the employee ID and name of each employee and the name of his or her supervisor (label the supervisor's name Manager)?
10. Display the customer names of all customers who have ordered (on the same or different orders) both products with IDs 3 and 4.
11. For each customer, list the CustomerID and total number of orders placed.
12. For each customer, list the CustomerID and the total number of orders placed in 2015.
13. List the customers who purchased the largest quantity of any NewFurniture product in a given line item and the customer(s) who purchased the smallest quantity and returns the result in one table.

    

Product Table ProductID 1 2 3 4 5 6 7 8 ProductLineld Product Description End Table Coffee Table 1 2 3 Computer Desk Entertainment Centre Product Line Table Writers Desk 8-Drawer Desk Dining Table Computer Desk ProductLineName Product Line 1 Product Line 2 Product Line 3 ProductFinnish Cherry Natural Ash Natural Ash Natural Maple Cherry White Ash Natural Ash Walnut Product StandardPrice $175 $170 $435 $735 $540 $800 $500 $250 ProductLine 1 2 2 3 1 2 2 3