Hi guys. How can I count using 'CASE WHEN'? Example:
SELECT CASE WHEN AND c.regdate > EXTRACT(epoch FROM (now() - INTERVAL '14 day')) THEN 'trial' WHEN last_pay > EXTRACT(epoch FROM (now() - INTERVAL '37 day')) THEN 'paying' END as account_status, c.id FROM public.clients c WHERE ( (last_pay > EXTRACT('epoch' FROM now() - '12 Months'::INTERVAL)) ) ORDER BY 1 I wanna know how many of 'trial' and 'paying' customers the query returns. can you guys please advice how to do it? Thanks Patrick