IniziaInizia gratis

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.

Questo esercizio fa parte del corso

Intermediate SQL with AI

Visualizza il corso

Esercizio pratico interattivo

Prova a risolvere questo esercizio completando il codice di esempio.

SELECT country
FROM films;
Modifica ed esegui il codice