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.
This exercise is part of the course
Analyzing Business Data in SQL
Hands-on interactive exercise
Have a go at this exercise by completing this sample 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;