Average Levels Reached by users per Day (Game SQL)

[maximus]

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

[yosiasz]

Welcome

Could you please post what you have tried for starters?

[maximus]

This is attached image of what i want to get,

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