/* cohort analysis */ SELECT users.id AS user_id, orders.created_at AS conversion_time, users.created_at AS cohort_time FROM users LEFT JOIN orders ON orders.user_id = users.id