cohort SQL

01.sql

SELECT count(1) as signed_up_users
FROM users
WHERE users.created_at >= now() - interval 2 day
AND users.created_at < now() - interval 1 day;

02.sql

SELECT count(distinct lessons.user_id) as logged_in_users
FROM lessons
WHERE lessons.start_date > now() - interval 1 day
AND lessons.start_date < now();

03.sql

SELECT
count(distinct users.id) as signed_up_users,
count(distinct lessons.user_id) as logged_in_users
FROM users
LEFT JOIN lessons
ON users.id = lessons.user_id