Compute User Login Streaks

Company: Pinduoduo

Role: Data Engineer

Category: Coding & Algorithms

Difficulty: easy

Interview Round: Technical Screen

Quick Answer: This question evaluates SQL proficiency in processing event logs for time-series analysis, encompassing date arithmetic, deduplication of same-day events, consecutive-date streak detection, and result-schema design within the Data Engineering and Coding & Algorithms domain.