Ch. 4 — The One-to-Many Relationship
Ch. 4 Exercises
Exercise 1
Report the account representative for each customer.
Exercise 2
Report total payments for Atelier graphique.
Exercise 3
Report the total payments by date.
Exercise 4
Report the products that have not been sold.
Exercise 5
List the amount paid by each customer, highest first.
Exercise 6
How many orders has Herkku Gifts placed?
Exercise 7
Who are the employees in the Boston office?
Exercise 8
Report customers who have made payments greater than $100,000.
Exercise 9
List the products and order numbers for all orders currently On Hold.
Exercise 10
How many orders on hold does each customer have?
ClassicModels Schema
customers
customerNumbercustomerNamecontactLastNamecontactFirstNamephoneaddressLine1addressLine2citystatepostalCodecountrysalesRepEmployeeNumbercreditLimitcustomerLocation 122 rows
employees
employeeNumberlastNamefirstNameextensionemailreportsTojobTitleofficeCode 23 rows
offices
officeCodecityphoneaddressLine1addressLine2statecountrypostalCodeterritoryofficeLocation 7 rows
orderdetails
orderNumberproductCodequantityOrderedpriceEachorderLineNumber 2996 rows
orders
orderNumberorderDaterequiredDateshippedDatestatuscommentscustomerNumber 326 rows
payments
checkNumberpaymentDateamountcustomerNumber 273 rows
productlines
productLinetextDescriptionhtmlDescriptionimage 7 rows
products
productCodeproductNameproductScaleproductVendorproductDescriptionquantityInStockbuyPriceMSRPproductLine 110 rows
Exercise 4
Report the products that have not been sold.
Write your SQL above and click Run Query.