First account for each country.
Conduct an analysis to see when the first customer accounts were created for each country.
Latihan ini adalah bagian dari kursus
Data-Driven Decision Making in SQL
Petunjuk latihan
- 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.
Latihan interaktif praktis
Cobalah latihan ini dengan menyelesaikan kode contoh berikut.
SELECT ___, -- For each country report the earliest date when an account was created
___ AS first_account
FROM customers
GROUP BY ___
ORDER BY ___;