Get startedGet started for free

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

View Course

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;
Edit and Run Code