Meta·Software Engineer·Technical Phone Screen
- You're given a PostgreSQL environment with a schema and a supposedly AI-generated SQL query. Identify at least four critical issues with it (join types, fan-out, aggregation grain, etc.), fix it so it runs correctly, then inspect the output for data quality problems and update the query to address them.
“This one took me a while to wrap my head around because it's not just 'find the bug.' The query had a many-to-many join that was silently inflating row counts, and I almost missed it because the query actually ran fine.”