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

From Patrick B
Subject [GENERAL] count case when - PG 9.2
Date
Msg-id CAJNY3itT_+nJHrqE-1m01UAeN9u48wQbVycb=aWhRmTnLRQk2Q@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] count case when - PG 9.2
Re: [GENERAL] count case when - PG 9.2
List pgsql-general
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

pgsql-general by date:

Previous
From: John Iliffe
Date:
Subject: Re: [GENERAL] Unable to start postgresql
Next
From: Günce Kaya
Date:
Subject: Re: [GENERAL] import CSV file to a table