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

Exercise

Order growth rate

Bob needs one more chart to wrap up his pitch deck. He's covered Delivr's gain of new users, its growing MAUs, and its high retention rates. Something is missing, though. Throughout the pitch deck, there's not a single mention of the best indicator of user activity: the users' orders! The more orders users make, the more active they are on Delivr, and the more money Delivr generates.

Send Bob a table of MoM order growth rates.

(Recap: MoM means month-on-month.)

Instructions

100 XP
  • Count the unique orders per month.
  • Fetch each month's previous and current orders.
  • Return a table of MoM order growth rates.