Exercises

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.

คำแนะนำ

100 XP

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

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}Exercises

คำแนะนำ

Exercises