Question: List TOY category items and orders placed for them.  Report:  Item_Num, Description, Order_Num, and Order_Date

REP (REP_NUM, LAST_NAME, FIRST_NAME, STREET, CITY, STATE, POSTAL_CODE, COMISSION, RATE)

CUSTOMER (CUSTOMER_NUM, CUSTOMER_NAME, STREET, CITY, STATE, POSTAL_CODE, BALANCE, CREDIT_LIMIT, REP_NUM)

ORDERS (ORDER_NUM, ORDER_DATE, CUSTOMER_NUM)

ORDER_LINE (ORDER_NUM, ITEM_NUM, NUM_ORDERED, QUOTED_PRICE)

ITEM (ITEM_NUM, DESCRIPTION, ON_HAND, CATEGORY, STOREHOUSE, PRICE)

 

Answer rating: 100% (QA)

Select ITEMITEMNUM DESCRIPTION SUMPRICE NUMORDERED as TOTALVALUE from ... View the full answer