4. Display the customer number, customer name, order number, and order date for each order. Sort the
Fantastic news! We've Found the answer you've been seeking!
Question:
4. Display the customer number, customer name, order number, and order date for each order. Sort the results by order date by descending sequence.
5. For each order line, what is the amount of discount, and percent discount is 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
6. For each order report order number, order date, and discount percent.
Related Book For
Applied Physics
ISBN: 978-0132109277
10th Edition
Authors: Dale ewen, Neill schurter, P. erik gundersen
Posted Date: