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.
Deze oefening maakt deel uit van de cursus
Analyzing Business Data in SQL
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
SELECT
-- Get the earliest (minimum) order date by user ID
___,
___ AS reg_date
FROM orders
GROUP BY ___
-- Order by user ID
ORDER BY ___ ASC;