TikTok interview question

SQL, Coding. Testing scenarios, BQ