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

Reply via email to