Problem 20 Done CS305 Ch03 HWprobs.pdf Problems 1 of,3 The problems use the Cust

Question

Problem 20 Done CS305 Ch03 HWprobs.pdf Problems 1 of,3 The problems use the Customer, OrderTbl, and Employee tables of the simplified Order Entry database. Chapters 4 and 10 extend the database to increase its usefulness. The Customer table contains clients who have placed orders. The Order Tbl contains basic facts about customer orders. The Employee table contains facts about employees who take orders. The primary keys of the tables are CustNo for Customer, EmpNo for Employee, and OrdNo for OrderTbl. Customer stzip 80129-5543 80111-0033 98103-1121 98178-3311 98013-1095 CustNo CustFirstName CustLastName CustCityCustState Gordon C1010398 C2388597 C3340959 C3499503 Denver Seattle Seattle Co Co WA WA WA $230.00 $200.00 $500.00 $200.00 $0.00 Taylor Bob Mann

Explanation / Answer

SELECT CustState, MIN(CustBal) AS Min, MAX(CustBal) AS Max FROM Customer GROUP BY CustState;

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.