For the weekend sale every product is 20% off. The print shop needs one price tag for
each different sale price, so a price shared by several products is printed only once. Show
the sale price as tag_price.
Cheapest tag first: end your query with ORDER BY tag_price.
| products |
|---|
| product_id (PK) |
| product_name |
| category_id (FK) |
| price |
| stock |
| rating |
| is_available |
For the weekend sale every product is 20% off. The print shop needs one price tag for
each different sale price, so a price shared by several products is printed only once. Show
the sale price as tag_price.
Cheapest tag first: end your query with ORDER BY tag_price.
| products |
|---|
| product_id (PK) |
| product_name |
| category_id (FK) |
| price |
| stock |
| rating |
| is_available |
| tag_price |
|---|
| 263.200 |
| 280.000 |
| 399.200 |
| 519.200 |
| 599.200 |
| 639.200 |
| 719.200 |
| 799.200 |
| 879.200 |
| 959.200 |
| 1039.200 |
| 1199.200 |
| 1439.200 |
| 1519.200 |
| 1599.200 |
| 1759.200 |
| 1999.200 |
| 2239.200 |
| 2399.200 |
| 2799.200 |
| 7199.200 |
| 19999.200 |
| 26399.200 |
| 55192.000 |
Run query to see output