velyn_prod
Postgres 16.2 · iad-1
SELECT u.email, COUNT(l.id) AS licenses FROM users u LEFT JOIN licenses l ON l.user_id = u.id WHERE u.created_at > now() - interval '30 days' GROUP BY u.email ORDER BY licenses DESC;
emaillicenses
maya@studio.io12
sam@studio.io8
elena@velyn.dev6
tomas@studio.io4
4 rows · 18 msplan: index scan (users_created_at_idx)