Rounding numbers
All the prices of songs end with .99. There are some countries that have phased out pennies, like Canada. In order to comply with this, you have been asked to convert UnitPrice
in the Track
table to the nearest whole number (e.g., $1.99 to $2).
In the video, we covered ROUND()
and TRUNC()
, which do you need to accomplish this task?
This exercise is part of the course
Introduction to Oracle SQL
Exercise instructions
- Select the
TrackId
andUnitPrice
column fromTrack
. - Use a function on
UnitPrice
to round up to the nearest whole number.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Select TrackId and rounded unit price
SELECT ___, ___
FROM ___