Re: [GENERAL] count case when - PG 9.2 - Mailing list pgsql-general

if you want see account_status and the count()- try this:

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,

        count(*)

    FROM public.clients c

        WHERE (

               (last_pay > EXTRACT('epoch' FROM now() - '12 Months'::INTERVAL))

              ) 

               group by 1 

    ORDER BY 1