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.
Latihan ini adalah bagian dari kursus
Intermediate SQL
Petunjuk latihan
- Update the query by adding
ROUND()around the calculation and round to two decimal places.
Latihan interaktif praktis
Cobalah latihan ini dengan menyelesaikan kode contoh berikut.
-- Round duration_hours to two decimal places
SELECT title, duration / 60.0 AS duration_hours
FROM films;