TikTok interview question

SQL Technical Interview, Three Questions, each increasing in difficulty