candidates during an interview for Tech position was given to Customer Table Cus

Question

candidates during an interview for Tech position was given to Customer Table Customer ID Name City State Acme Inc San Francisco CA 002 Systems Phoenix Spacey Sprockets Los Angeles CA ABC Gear Co. New York NY Order Table ItemuD Quantity Date Customer ID 01 1/1/1999 002 10 1/1/1999 1/1/1999 I003 B101 21/1999 I001 B.101 3 21/1999 1/1999 B101. 3/1/1999 Delivery coverage State Serviced Name ABOTrucking C ABOTrucking EY Trucking N Trucking NL SELECT Customer Table State, order Table.Item ID, Sum(Quantity) FROM Customer Table, Order Table WHERE Customer Table Customer ID Order Table.Customer ID AND Order Table Date 2-28-1999 AND Customer Table State IN (SELECT State Serviced from Delivery Coverage WHEREName ABC GROUP BY State, Item ID ORDER BY State, Item ID INTO TABLE Ship Table What resulting table will the above SQL statement(one query)yield? Ship Table State Item ID Sum Quantity

Explanation / Answer

CA A101 5

CA B101 3

AZ A101 10

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

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