Rounding results
You found some valuable insights in the previous exercise, but many of the results were inconveniently long. We forgot to round! We won't make you redo them all; however, you'll update the worst offender in this exercise.
This exercise is part of the course
Intermediate SQL
Exercise instructions
- Update the query by adding
ROUND()around the calculation and round to two decimal places.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Round duration_hours to two decimal places
SELECT title, duration / 60.0 AS duration_hours
FROM films;