First account for each country.
Conduct an analysis to see when the first customer accounts were created for each country.
Deze oefening maakt deel uit van de cursus
Data-Driven Decision Making in SQL
Oefeninstructies
- 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.
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
SELECT ___, -- For each country report the earliest date when an account was created
___ AS first_account
FROM customers
GROUP BY ___
ORDER BY ___;