repos / pico

mau.sql

 1select
 2  count(distinct user_id) as mau_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 mau_pgs,
10  date_trunc('month', updated_at) as month
11from projects
12group by month
13order by month DESC;