repos / pico

commit

6a7c21b

parent

adb2bd3

author

Eric Bower

date

2024-12-23 20:34:29 -0500 EST

chore(script): change col names

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