DBS311 Assignment 1 CUSTOMERS and ORDERS

1. Provide two statements.
2. Looking at CUSTOMERS and ORDERS, supply the names of customers who have never made an order according to the current tables. (10 marks)
3. Supply the count of customers who have never made an order in our current tables.
4. Display the total number of orders per month from the ORDERS table. Show this in month order.

(5 marks)

3. Show how many customers have made an order. (5 marks)

4. Produce the following output based on CUSTOMERS, ORDERS and ORDERDETAILS. (10 marks)

If your average is off, remember we changed PRICEEACH from 195.33 to 214.30 for ORDERNUMBER 10185 and PRODUCTNUMBER S12_1108 in lab 3.

5. Show all the customer names and their order total for everyone who had an order total more than $58,000 based on CUSTOMERS, ORDERS and ORDERDETAILS. (10 marks)
6. Show me something interesting based on two or three of the ORDERS, ORDERDETAIL and CUSTOMER tables.

(5 marks)

You should have comments on what you are showing me

The statement should  illustrate something covered in the first half and not be a simple one, for example –

SELECT * FROM TABLE

Your statement should not be an exact copy of something done in the lab

Your statement should be unique – no collaberation with any other students and if you put effort into it, probably no one else in the class came up with the same idea as you