Re: [GENERAL] count case when - PG 9.2

[Patrick B]

2017-03-10 10:17 GMT+13:00 Yasin Sari <yasinsar...@googlemail.com>:

> 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,
>
>         c <http://c.id/>ount(*)
>
>     FROM public.clients c
>
>         WHERE (
>
>                (last_pay > EXTRACT('epoch' FROM now() - '12
> Months'::INTERVAL))
>
>               )
>
>                group by 1
>
>     ORDER BY 1
>
>
>

Thanks Yasin! That worked.

P.