Customer Table Customer_ID 001 002 Name Acme, Inc. Widget Systems Spacely Sprockets ABC Gear Co. City San Francisco Phoenix Los Angeles New York State CA AZ CA NY 003 004 Order Table Customer_ID 001 002 004 003 Item_ID A101 A101 A101 B101 B101 A101 B101 Quantity 5 10 6 4 3 Date 1/1/1999 1/1/1999 1/1/1999 2/1/1999 2/1/1999 3/1/1999 3/1/1999 001 4 003 004 5 Delivery_Coverage Name ABC Trucking ABC Trucking XYZ Trucking XYZ Trucking State_Serviced CA AZ NY NJ 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