Find Top Creators and Login Streaks

Q: How do I approach Coding & Algorithms interview questions?

Coding & Algorithms questions require understanding of core concepts and practice. PracHub provides solutions with explanations to help you master coding & algorithms interviews.

Q: What difficulty level is this interview question?

This is a medium difficulty Coding & Algorithms question, commonly asked during Onsite rounds at Bytedance.

Q: What role is this question designed for?

This question is commonly asked for Data Engineer candidates at Bytedance during technical interviews.

Question

Find Top Creators and Login Streaks

PracHub · Accepted Answer

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.

Find Top Creators and Login Streaks

Quick Overview

Find Top Creators and Login Streaks

Submit Your Answer to Earn 20XP