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

Exercise

MAU monitor (III)

Carol is very pleased with your last query, but she's requested one change: She prefers to have the month-on-month (MoM) MAU growth rate over a raw delta of MAUs. That way, the MAU monitor can have more complex triggers, like raising a yellow flag if the growth rate is -2% and a red flag if the growth rate is -5%.

Write a query that returns a table of months and each month's MoM MAU growth rate to finalize the MAU monitor.

Instructions

100 XP
  • Select the month and its MoM MAU growth rate.
  • Order by month in ascending order.