TikTok interview question

SQL: leetcode medium to hard. Schema/data sample is provided. Queries will require revisions based on interviewer follow ups. Python: leetcode easy to medium. It is important to clarify all the details before attempting to write any code. Additionally, space and time complexity analysis is required. Big Data: basic knowledge and project experience.