- commit
- adb2bd3
- parent
- 21bf786
- author
- Eric Bower
- date
- 2024-12-23 20:24:12 -0500 EST
chore(script): new users by month
1 files changed,
+7,
-0
+7,
-0
1@@ -11,3 +11,10 @@ select
2 from projects
3 group by month
4 order by month DESC;
5+
6+select
7+ count(id) as users,
8+ date_trunc('month', created_at) as month
9+from app_users
10+group by month
11+order by month DESC;