Skip to content

Instantly share code, notes, and snippets.

@jdwyah

jdwyah/1.sql

Created February 22, 2015 15:37
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jdwyah/8c37839a87ac57be313f to your computer and use it in GitHub Desktop.
Save jdwyah/8c37839a87ac57be313f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
1.sql
with monthly_usage as (
select
who_identifier,
datediff(month, '1970-01-01', when_timestamp) as time_period
from events
where event = 'login' group by 1,2 order by 1,2),
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment