1. Learn
    2. /
  2. Courses
    3. /
  3. Intermediate SQL

Exercise

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!

Instructions 1/4

undefined XP
  • 1
    • Use the SUM() function to calculate the total duration of all films and alias with total_duration.
  • 2
    • Calculate the average duration of all films and alias with average_duration.
  • 3
    • Find the most recent release_year in the films table, aliasing as latest_year.
  • 4
    • Find the duration of the shortest film and use the alias shortest_film.