Using Cape Cod Database DISPLAY RECORD COUNT (2 pt each):

1. What orders over $400 were made in Dec of 2014?

2. What $ amount is our largest order?

3. What is the Average Square Footage for Warehouses in CA, WA, and IL?

4. What are the names of the Managers that have products that we are out of?  Also, what are those products?

5. What Products, by Name, do we have more than 2 in our Warehouses?

6. I need a list of total and average revenue for each department.

7. What were the total sales for October?

8. How many orders did each store have in 2013?

Answer rating: 100% (QA)

1 Orders over 400 in Dec 2014 sql SELECT FROM Orders WHERE OrderDate 20141201 AND OrderDate 400 2 La... View the full answer