1. सीखें
  2. /
  3. पाठ्यक्रम
  4. /
  5. Analyzing Business Data in SQL

Connected

अभ्यास

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.

निर्देश

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