Skip to content

Instantly share code, notes, and snippets.

@adityawarmanfw

adityawarmanfw/media_analytics_milestone.sql

Created September 30, 2020 12:38
Show Gist options
  • Save adityawarmanfw/e3fa295dc819d847774c3e1584e1798c to your computer and use it in GitHub Desktop.
Save adityawarmanfw/e3fa295dc819d847774c3e1584e1798c to your computer and use it in GitHub Desktop.
Download ZIP
media analytics
Raw
media_analytics_milestone.sql
SELECT episode,
event_name,
COUNT(user_id) AS events,
COUNT(DISTINCT user_id) AS users
FROM audio_event
GROUP BY episode
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment