5. Daily Active Users 2

[arcsolver34323]

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;

[eigentensor]

SELECT date, platform, dau_count FROM gameplays;

[7aylor]

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!