I'm unsure what my error is, I am not receiving an error when running the code, but it also will not mark the part as complete. Any help? I am being asked to print [date, platform, and dau_count] to the screen.
count(distinct user_id) as dau
group by 1
order by 1;
SELECT date, platform, dau_count FROM gameplays;
I had this same problem, but I didn’t copy the skeleton code down properly, looks like you did the same thing. Try this:
COUNT(DISTINCT user_id) as dau
GROUP BY 1, 2
ORDER BY 1, 2;
You just forgot the GROUP BY 1, 2 and the ORDER BY 1, 2;
hope that helps!
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.