Your question is SQL for Large Datasets. Take a moment with it on the right.
Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).
Write efficient SQL queries to extract, filter, and aggregate large-scale datasets under strict time constraints.
Explain how you would structure the queries, choose indexes or partitions, avoid unnecessary data processing, and validate performance with query-plan tools. Include representative SQL and discuss how your approach changes for joins, filtering, and aggregation at scale.