Skip to content

Instantly share code, notes, and snippets.

@kiyoto

kiyoto/retention_1.sql Secret

Created July 19, 2016 21:33
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 kiyoto/863d4bea5d4fe239ece12d23e71c4e43 to your computer and use it in GitHub Desktop.
Save kiyoto/863d4bea5d4fe239ece12d23e71c4e43 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
retention_1.sql
SELECT
user_id,
TD_DATE_TRUNC('week', login_time) AS login_week
FROM logins
GROUP BY 1, 2
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment