Customers Sales Orders PK TID PK Sonum Name CustType FK1 Cut CrediLimit HO---0 Order Date Balance ShipDate Address Ship Via City Order Total State SalesAgent Zip Code Area Code Phone SOdetail Inventory PK.FK2 SOnum PK Parte PK Line Num >O---OH Description FK1 Part No Cost Qty Price Cost On Hand Price OnOrder Allocated Module: HW: Basic - ABC Mode: Tutor Mode (Past Due, Interface Locked) Query: 06 (0000 attempts Return to Module Page Query (06) Enter SQL: Submi A list of states and a count of the customers for those states that have more than 50 customers. Label the second column NumCustomers. SOdetail PK,FKZ SO PK Line Num # Customers PKR Sales Orders PK SOum Name CustType FK CustID Credi Limit to---08 Order Date Balance ShipDate Address Ship Via City Order Total State Zip Code SalesAgent Area Code Phone Inventory PK Parte O---OH Description Cost Price On Hand OnOrder Allocated FK1 Part No Qty Cost Price Module: HW: Basic - ABC Mode: Tutor Mode (Past Due, Interface Locked) Query: 07 (0000 attempts/ev. Return to Module Page Query (07) Enter SQL: Submit A list of states that have more than 20 wholesale customers. Only include the single column for state, no count is requested SOdetail Inventory PK Part No Customers Sales Orders PKD PK Sonum Name CustType FK1 CustID CreditLimit HO---0 Orderwe Balance ShipDate Address Ship Via City Order Total State SalesAgent Zip Code AreaCode Phone PK FK2 SOnum PK LineNum O DO---OH FKI Part. No Qty Cost Price Description Cost Price OnHand OnOrder Allocated Query: 08 (0000 attempt Subm Module: HW: Basic - ABC Mode: Tutor Mode (Past Due, Interface Locked) Return to Module Page Query (08) Enter SQL: The customer type (W.R) and the average balance due for each type. Name the second column AvgBalDue. Customers Sales Orders PKD PK SOnum + Name CustType Credit Limit HO--- Balance Address City State Zip Code AreaCode Phone Price SOdetal Inventory PK.FK2 SOnun PK Parte PK LineNum O---OH Description FK1 Part.No Cost Oly Cost On Hand Price OnOrder Allocated FK1 Curt Orderate ShipDate ShipVia Order Total Sales Agent Module: HW: Basic - ABC Mode: Tutor Mode (Past Due, Interface Locked) Query: 09 (0003 attempu Return to Module Page Query (09) Enter SQL: Sub A list of customer name, phone numbers, custtype, and balances for all wholesale (W) customers with a balance over $75.000 and all retails customers (R) with a balance over $20.000 ordered by custtype and within custtype by balance. SOdetail Inventory PK Parto PK.FK2 SOnum PK Line Num + DO---OH Customers Sales Orders PKR PK SOum Name CustType FK1 CustID Crede Limit O--- Order Date Balance ShipData Address Ship Via City Order Total Stale Sales Agent Zip Code Area Code Phone FK1 Part No Oly Cost Price Description Cost Price OnHand OnOrder Alocated Query: 10 (0000 attem Sub Module: HW: Basic - ABC Mode: Tutor Mode (Past Due, Interface Locked) Return to Module Page Query (10) Enter SQL: A list of customer name, phone, city, and balances for all customers that live in either New York or Los Angeles and that also have a balance due greater than $10.000
