Get startedGet started for free

GROUP BY single fields

GROUP BY is a SQL keyword that allows you to group and summarize results with the additional use of aggregate functions. For example, films can be grouped by the certification and language before counting the film titles in each group. This allows you to see how many films had a particular certification and language grouping.

In the following steps, you'll summarize other groups of films to learn more about the films in your database.

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.

-- Find the release_year and film_count of each year
___
Edit and Run Code