Registrations by month
Usually, registration dates are stored in a table containing users' metadata. However, Delivr only considers a user registered if that user has ordered at least once. A Delivr user's registration date is the date of that user's first order.
Bob, the Investment Relations Manager at Delivr, is preparing a pitch deck for a meeting with potential investors. He wants to add a line chart of registrations by month to highlight Delivr's success in gaining new users.
Send Bob a table of registrations by month.
Cet exercice fait partie du cours
Analyzing Business Data in SQL
Exercice interactif pratique
Essayez cet exercice en complétant cet exemple de code.
SELECT
-- Get the earliest (minimum) order date by user ID
___,
___ AS reg_date
FROM orders
GROUP BY ___
-- Order by user ID
ORDER BY ___ ASC;