Level 3 - IntermediateCommunication Prompt Questions
Communication: Explain a Query Trade-off
Prompt: You rewrote a slow query from LEFT JOIN + WHERE filter to EXISTS. Give a 60-second interview explanation covering: 1) why old query was slow/risky, 2) why new query is better, 3) one validation step.