Re: count case when - PG 9.2

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Wednesday, March 8, 2017, Patrick B <patrickbakerbr@xxxxxxxxx> wrote:

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

Turn that into a subquery and group by...

David J.