Back to questions
Assume you're the financial analyst of an online shopping company and you're given the table.
Write a query to output a list of product ID where the total price for the sale is more than $400. Sort the results in ascending order of the product ID.
| Column Name | Type |
|---|---|
| sales_id | integer |
| order_id | integer |
| product_id | integer |
| unit_price | decimal (5,2) |
| quantity | integer |
| total_price | decimal (5,2) |
| sales_id | delivery_order_id | product_id | unit_price | quantity | total_price |
|---|---|---|---|---|---|
| 1 | 1 | 218 | 127.00 | 2 | 254.00 |
| 2 | 1 | 481 | 140.00 | 1 | 140.00 |
| 3 | 1 | 2 | 141.60 | 3 | 424.80 |