Question: Write a SELECT statement that returns these column names and data from the Order _ Items table: item _ id The item _ id column
Write a SELECT statement that returns these column names and data from the OrderItems table:
itemid The itemid column
itemprice The itemprice column
discountamount The discountamount column
quantity The quantity column
pricetotal A column thats calculated by multiplying the item price by the quantity
discounttotal A column thats calculated by multiplying the discount amount by the quantity
itemtotal A column thats calculated by subtracting the discount amount from the item price and then multiplying by the quantity
Only return rows where the itemtotal is greater than Sort the result set by the itemtotal column in descending sequence. Submit a screenshot.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
