5. Daily Active Users 2

#1


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.



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

#2 

SELECT date, platform, dau_count FROM gameplays;
#3

I had this same problem, but I didn't copy the skeleton code down properly, looks like you did the same thing. Try this:

SELECT
DATE(created_at),
platform,
COUNT(DISTINCT user_id) as dau
FROM gameplays
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!

#4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.