repos / pico

mau.sql

 1select
 2  count(distinct user_id) as active_posts,
 3  date_trunc('month', updated_at) as month
 4from posts
 5group by month
 6order by month DESC;
 7
 8select
 9  count(distinct user_id) as active_sites,
10  date_trunc('month', updated_at) as month
11from projects
12group by month
13order by month DESC;
14
15select
16  count(id) as new_users,
17  date_trunc('month', created_at) as month
18from app_users
19group by month
20order by month DESC;