Skip to content

Instantly share code, notes, and snippets.

View danielgranat's full-sized avatar

Daniel Granatshtein danielgranat

View GitHub Profile
@danielgranat
danielgranat / cohort.sql
Last active March 6, 2017 20:54 — forked from arikfr/cohort.sql
Cohort Query Example
with
time_frame as (
select current_date - 14
),
population as (
select created_at::date as cohort_date, id as unique_id
from organizations
where created_at > (select * from time_frame)