On Wednesday, March 8, 2017, Patrick B <
patrickbakerbr@gmail.com> wrote:
Hi guys. How can I count using 'CASE WHEN'?
Example:
WHEN AND c.regdate > EXTRACT(epoch FROM (now() - INTERVAL '14 day'))
WHEN last_pay > EXTRACT(epoch FROM (now() - INTERVAL '37 day'))
(last_pay > EXTRACT('epoch' FROM now() - '12 Months'::INTERVAL))
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.