Question: 4. Write a SQL statement that selects these columns from the Order_Items table: item_id The item_id column item_price The item_price column discount_amount The discount_amount column

 4. Write a SQL statement that selects these columns from the

4. Write a SQL statement that selects these columns 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 item price by the quantity discount_total A column that's calculated by multiplying the discount amount by the quantity item_total A column that's calculated by subtracting the discount amount from the item price and then multiplying by the quantity Only return rows where the item_total is greater than 455. Sort the result set by item total in descending sequence. 5. Write a SQL statement that selects these columns from the Orders table: order_id The order_id column order_date The order_date column ship_amount The ship amount column ship_date The ship_date column Round the ship_amount to 1 decimal place. Only return data where ship_date doesn't contain null. Limit results to 5 rows. 688 words

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!