Get startedGet started for free

Practice with aggregate functions

Now let's try extracting summary information from a table using these new aggregate functions. Summarizing is helpful in real life when extracting top-line details from your dataset. Perhaps you'd like to know how old the oldest film in the films table is, what the most expensive film is, or how many films you have listed.

Now it's your turn to get more insights about the films table!

This exercise is part of the course

Intermediate SQL

View Course

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

-- Query the sum of film durations
___
Edit and Run Code