First account for each country.
Conduct an analysis to see when the first customer accounts were created for each country.
Questo esercizio fa parte del corso
Data-Driven Decision Making in SQL
Istruzioni dell'esercizio
- Create a table with a row for each country and columns for the country name and the date when the first customer account was created.
- Use the alias
first_accountfor the column with the dates. - Order by date in ascending order.
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
SELECT ___, -- For each country report the earliest date when an account was created
___ AS first_account
FROM customers
GROUP BY ___
ORDER BY ___;