SQL for Returning Users

SELECT "userId", count() FROM (SELECT DISTINCT "userId", "createdAt"::date from "ActionLogs" WHERE "apiClientId" like 'ahh%' AND "createdAt" >= '2016-03-24') AS "SAME_DAYS" GROUP BY "userId" HAVING count() >1;

Seah Ying Cong

Old soul in an older body.

Subscribe to Ying Cong

Get the latest posts delivered right to your inbox.

or subscribe via RSS with Feedly!