1-- auto-materialised by Query Director2WITH cohort AS (3 SELECT date_trunc('week', u.created_at) AS week,4 count(*) FILTER (WHERE s.status='active') AS retained5 FROM users u6 LEFT JOIN subscriptions s ON s.user_id = u.id7 GROUP BY 18)9SELECT * FROM cohort ORDER BY week DESC LIMIT 26;