Shop the Sales
We're back to working on our e-commerce website, "Wamazon."
Remember the merchandise table with our things for sale.
merchandise
| column_name | type |
|---|---|
id | INTEGER |
name | VARCHAR |
price_usd | NUMERIC |
discount_perc | NUMERIC |
We already learned how to apply a discount to apply a sale price.
Now that we know how to use ORDER BY, let's try ordering on a computed column.
Just put the computation after the ORDER BY instead of just the column name.
For this challenge, select the cheapest 10 items based on their sale price after applying the discount.
