For Mineblocks, we’ll use the gameplays table to calculate DAU. Each time a user plays the game, their session is recorded in gameplays. Thus, a distinct count of users per day from gameplays will give us DAU.

Calculate Daily Active Users for Mineblocks. Complete the query’s count function by passing in the distinct keyword and the user_id column name.

select date(created_at),
count(distinct(user_id)) as players
from gameplays
group by 1
order by 1;

Likewise, Weekly Active Users (WAU) and Monthly Active Users (MAU) are in the same family.

Can somebody help me with the query to find Weekly Active Users and Monthly Active Users?