Find Top Creators and Login Streaks
Company: ByteDance
Role: Data Engineer
Category: Coding & Algorithms
Difficulty: medium
Interview Round: Onsite
Overview: This question evaluates proficiency in data aggregation, algorithmic optimization for top-k retrieval, and SQL time-series analysis using window functions and date deduplication to compute consecutive-day login streaks.