Exercise

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.

Instructions 1/2

undefined XP
    1
    2
  • Return a table of user IDs and their registration dates.
  • Order by user_id in ascending order.