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.
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.
Step by Step Solution
3.34 Rating (169 Votes )
There are 3 Steps involved in it
Create and Manage Sign Into Order Management Sign into Order Management so you can create and manage sales orders Get the details you need URL that provides access to Order Management User account and ... View full answer
Get step-by-step solutions from verified subject matter experts
Study Help