SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, 4th Edition

BSchema for the Sample Databases

Sales Orders Example Database

The table titled “customers” consists of CustomerID (PK), CustFirstName, CustLastName, CustStreetAddress, CustCity, CustState, CustZipCode, CustAreaCode, and CustPhoneNumber. The table titled “employees” consists of EmployeeID (PK), EmpFirstName, EmpLastName, EmpStreetAddress, EmpCity, EmpState, EmpZipCode, EmpAreaCode, EmpPhoneNumber. The table titled “orders” consists of OrderNumber (PK), OrderDate, ShipDate, CustomerID (FK), and EmployeeID (FK). The table titled “order_details” consists of OrderNurnber (CPK), ProductNumber (CPK), QuotedPrice, and QuantityOrdered. The table titled ...