Skip to main content
Solving LeetCode Problems with PreQL

Monthly Active Users Calculation

Given a table with the below definition.

user_actions Table: Column Name Type user_id integer event_id integer event_type string ("sign-in, "like", "comment") event_date datetime

Write a query that will return "Monthly Active Users" (MAU) for each month in the table.


efromvtAbout 2 minPreQLSQL