Skip to content

Instantly share code, notes, and snippets.

@morsapaes

morsapaes/twitch_queries.sql

Created October 7, 2021 09:43
Show Gist options
  • Save morsapaes/6e083c19e9e48530228c9cba7a4ec07c to your computer and use it in GitHub Desktop.
Save morsapaes/6e083c19e9e48530228c9cba7a4ec07c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
twitch_queries.sql
--What are the top10 games being played?
SELECT game_name,
cnt_streams,
agg_viewer_cnt
FROM mv_agg_stream_game
ORDER BY agg_viewer_cnt
DESC LIMIT 10;
--Is anyone playing DOOM?
SELECT game_name,
cnt_streams,
agg_viewer_cnt
FROM mv_agg_stream_game
WHERE upper(game_name) LIKE 'DOOM%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment