Grouping fields
You're preparing for an international film festival.
First, you want to see how many films come from each country to get a sense of overall representation. Then, it also helps to check specific years to see which countries have been most active recently. This way you can spot both the most active film regions and those growing today.
Deze oefening maakt deel uit van de cursus
Intermediate SQL with AI
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
SELECT country
FROM films;