For each order line, what is the amount of discount, and percent discount given. Discount is based on difference between price and quoted_price.  Report order number, order date, discount amount, and discount percent. Percentage of discount is based on difference_ in_ price/price*100
 

Connections ED IS3845 Database +, O ORDER_NUM O ITEM_NUM I NUM_ORDERED I QUOTED_PRICE Worksheet Query ORDERS I ORDER_NUM ORDER_DATE O CUSTOMER_NUM PC TAGNUM COMPID EMPNUM LOCATION | QUOTATIONS SUPPNO PARTNO PRICE I DELIVERY_TIME O QONORDER REP REP_NUM I LAST_NAME FIRST_NAME STREET CITY STATE O POSTAL_CODE COMMISSION RATE SUPPLIERS SUPPNO I NAME I ADDRESS SUPPLIES PARTNO SUPPNO I QTY_DISP I DATE_DISP m.ta viewe