2054. Consecutive Days : StrataScratch

SELECT  e1.user_id
FROM    sf_events e1 INNER JOIN sf_events e2
        ON e1.record_date + 1 = e2.record_date AND e1.user_id = e2.user_id
        INNER JOIN sf_events e3
        ON e3.record_date = e1.record_date + 2 AND e3.user_id = e2.user_id