Write a SELECT statement that returns these column names and data from the Order_Items table: item_id The item_id column
Posted: Mon Jul 11, 2022 9:54 am
Write a SELECT statement that returns these column names anddata from the Order_Items table:
item_id The item_id column
item_price The item_price column
discount_amount The discount_amount column
quantity The quantity column
price_total A column that’s calculated by multiplying the itemprice by the quantity
discount_total A column that’s calculated by multiplying thediscount amount by the quantity
item_total A column that’s calculated by subtracting thediscount amount from the item price and then multiplying by thequantity
Only return rows where the item_total is greater than 500. Sortthe result set by the item_total column in descending sequence.Submit a screenshot.
item_id The item_id column
item_price The item_price column
discount_amount The discount_amount column
quantity The quantity column
price_total A column that’s calculated by multiplying the itemprice by the quantity
discount_total A column that’s calculated by multiplying thediscount amount by the quantity
item_total A column that’s calculated by subtracting thediscount amount from the item price and then multiplying by thequantity
Only return rows where the item_total is greater than 500. Sortthe result set by the item_total column in descending sequence.Submit a screenshot.