SQL · ByteDance · Medium
You are given two tables describing TikTok Live sessions and their measured engagement, and you must answer each question below with SQL only. live_room holds one row per Live session (called a room) started by a creator, keyed by (date, room_id), with these columns: date — the calendar day (treated as UTC) on which the session ran. creator_id — the creator who went live. room_id — unique identifier for the room. country — the country the room is attributed to, such as US,…
Checking your access…