SQL · ByteDance · Medium
TikTok records every Live room launch in the live_room table, and stores per-room figures such as view counts and gifts in live_room_activity. Treat "yesterday" as 2025-05-31 for this question. Looking only at rows dated 2025-05-31, count the creators who satisfy both conditions below at the same time: The creator opened two or more Live rooms that day — that is, they went live more than once. All of the rooms that creator launched that day reached at least 500 views, i.e.…
Checking your access…