chore: scripts - pico@7c27c34

Commit `7c27c34`

Eric Bower · 2026-04-17 22:18:24 -0400 EDT

parent 9165d1d

chore: scripts

1 files changed, +13, -0

M scripts/mau.sql

+13, -0

......@@ -18,3 +18,16 @@ select
from app_users
group by month
order by month DESC;

select
  count(id) as subs,
  date_trunc('month', created_at) as month
from feature_flags
where name = 'plus' and expires_at > now()
group by month
order by month DESC;

select
	count(*) as total_subs
from feature_flags
where name = 'plus' and expires_at > now();

...	...		@@ -18,3 +18,16 @@ select
18	18		from app_users
19	19		group by month
20	20		order by month DESC;
	21	+
	22	+	select
	23	+	count(id) as subs,
	24	+	date_trunc('month', created_at) as month
	25	+	from feature_flags
	26	+	where name = 'plus' and expires_at > now()
	27	+	group by month
	28	+	order by month DESC;
	29	+
	30	+	select
	31	+	count(*) as total_subs
	32	+	from feature_flags
	33	+	where name = 'plus' and expires_at > now();

Commit 7c27c34

Commit `7c27c34`