First account for each country.
Conduct an analysis to see when the first customer accounts were created for each country.
Bu egzersiz
Data-Driven Decision Making in SQL
kursunun bir parçasıdırEgzersiz talimatları
- 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.
Uygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
SELECT ___, -- For each country report the earliest date when an account was created
___ AS first_account
FROM customers
GROUP BY ___
ORDER BY ___;