Skip to content

Instantly share code, notes, and snippets.

@ittus

ittus/cohort.sql

Created May 11, 2021 05:59
Show Gist options
  • Save ittus/d1b5ecd0b16d62696f66acebd54118af to your computer and use it in GitHub Desktop.
Save ittus/d1b5ecd0b16d62696f66acebd54118af to your computer and use it in GitHub Desktop.
Download ZIP
[Medium] Cohort - 6
Raw
cohort.sql
SELECT B.start_time, S.num_users AS total_users, B.period_number, B.num_users AS total_repeators
FROM retention_table B
LEFT JOIN cohort_size S ON B.start_time = S.start_time
WHERE B.start_time IS NOT NULL
ORDER BY 1, 3
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment