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
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Query the sum of film durations
___