Learn

Great! Since Mineblocks is on multiple platforms, we can calculate DAU per-platform.

Instructions

1.

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;

Sign up to start coding

Mini Info Outline Icon
By signing up for Codecademy, you agree to Codecademy's Terms of Service & Privacy Policy.
Already have an account?