Forums
This topic is locked
how to use a GROUP BY clause in two tables?
Posted 14 Sep 2012 21:21:08
1
has voted
14 Sep 2012 21:21:08 becky super posted:
question:For each customer having an order, list the customer, the number of orders that customer has, the total quantity of items on those orders, and the total price for the items. Order the output by customer number.(Hint:You must use a GROUP BY clause in this query).
The tables:
stores.orders(ORDER_NUM| ORDER_DATE| CUSTOMER_NUM|SHIP_INSTRUCT|BACKLOG|PO_NUM|SHIP_DATE|SHIP_WEIGHT|SHIP_CHARGE|PAID_DATE)
stores.items(ITEM_NUM|ORDER_NUM|STOCK_NUM|MANU_CODE|QUANTITY|TOTAL_PRICE)
how to do this question? Thank you.
Replies
Replied 26 Apr 2013 10:23:03
26 Apr 2013 10:23:03 Johnson miller replied:
Nice topic shared....