Get startedGet started for free

Monthly active users (MAU)

Bob predicts that the investors won't be satisfied with only registrations by month. They will want to know how many users actually used Delivr as well. He's decided to include another line chart of Delivr's monthly active users (MAU); he's asked you to send him a table of monthly active users.

This exercise is part of the course

Analyzing Business Data in SQL

View Course

Exercise instructions

  • Select the month by truncating the order dates.
  • Calculate MAU by counting the users for every month.
  • Order by month in ascending order.

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

SELECT
  -- Truncate the order date to the nearest month
  ___ :: DATE AS delivr_month,
  -- Count the unique user IDs
  ___ AS mau
FROM orders
GROUP BY ___
-- Order by month
ORDER BY ___ ASC;
Edit and Run Code