←TrainerTask 5 / 217
Ticket #5
A price tag without cents
Task
For the printed price tag the amounts have to be whole dollars — fractions are not needed right now. Output name, price, and also the price with a 15% discount rounded up (price_up) and down (price_down).
Row order does not matter.
Hint: CEIL rounds up, FLOOR rounds down.
You'll need:Numbers and rounding(opens in a new tab)
SQL query
Query results will appear here
Preparing the lesson database…