Skip to main content
Solving LeetCode Problems with Trilogy

Monthly Active Users Calculation

Given a table with the definition below:

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 minTrilogySQL