Sollicitatievraag bij OpenTable

Coding Round (Python + SQL) Read logs line-by-line and count distinct error messages efficiently. Parsing logic Data structures (dict vs set) Handling large files Memory efficiency Clarity under pressure Follow-up: What if file is 10GB? How would you process at scale? Streaming vs batch? Avoid reprocessing same message? SQL Questions Q1: Report total party size booked per restaurant. Tested: JOIN GROUP BY SUM vs COUNT Alias usage Q2: For each restaurant, report quantity and revenue in its first booking year. Tested: MIN(year) per group Subqueries GROUP BY correctness Aggregation logic Joining back to bookings