What is the total value of orders placed for each item? Report under these column headings: ITEM_NUM,
Fantastic news! We've Found the answer you've been seeking!
Question:
What is the total value of orders placed for each item? Report under these column headings: ITEM_NUM, DESCRIPTION, TOTAL_VALUE
(NOTE: Value will be based on a total of ( price x quantity) for each order line for the item.)
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)
Related Book For
Corporate Finance A Focused Approach
ISBN: 978-1439078082
4th Edition
Authors: Michael C. Ehrhardt , Eugene F. Brigham
Posted Date: