1. Learn
    2. /
  2. Courses
    3. /
  3. Analyzing Business Data in SQL

Exercise

MAU monitor (I)

Carol from the Product team noticed that you're working with a lot of user-centric KPIs for Bob's pitch deck. While you're at it, she says, you can help build an idea of hers involving a user-centric KPI. She wants to build a monitor that compares the MAUs of the previous and current month, raising a red flag to the Product team if the current month's active users are less than those of the previous month.

To start, write a query that returns a table of MAUs and the previous month's MAU for every month.

Instructions

100 XP
  • Select the month and the MAU.
  • Fetch the previous month's MAU.
  • Order by month in ascending order.