SQLTeam.com | Weblogs | Forums

Average Levels Reached by users per Day (Game SQL)

Hello!
I am having a hard time writing an SQL code that I need to calculate Average Levels Reached by users per Day (Game SQL)

Would love it if someone can help me with an example
Thanks in advance

Welcome

Could you please post what you have tried for starters?

This is attached image of what i want to get,
WhatsApp Image 2022-10-12 at 4.08.07 PM

here is some code

SELECT
COUNT(*) AS event_count,
COUNT(DISTINCT user_pseudo_id) AS user_count,
COUNT(DISTINCT event_date) AS day_count
FROM t