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,
2017-03-10 10:17 GMT+13:00 Yasin Sari :
> 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 d
On Thu, Mar 9, 2017 at 2:01 PM, Patrick B wrote:
>
> Could you please guys give me a query as an example?
>
>
​Maybe if you describe exactly how you want the output to appear. And
maybe tee things up by writing a query that gets close and with some
example data. Something that can be copy-paste
2017-03-09 23:15 GMT+13:00 vinny :
> On 2017-03-09 05:27, Patrick B 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'
>>>
>>> WH
On 2017-03-09 05:27, Patrick B 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 accoun
On Wednesday, March 8, 2017, Patrick B 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
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,
