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