Great! Since Mineblocks is on multiple platforms, we can calculate DAU per-platform.
Previously we calculated DAU only per day, so the output we wanted was
[date, dau_count]. Now we want DAU per platform, making the desired output
[date, platform, dau_count].
Calculate DAU for Mineblocks per-platform. Complete the query below. You will need to select the
platform column and add a
count function by passing in the
distinct keyword and the
user_id column name.
select date(created_at), /**/, count(/**/) as dau from gameplays group by 1, 2 order by 1, 2;