Code RoomJoin missing condition
MediumPrep Room Coding #2328

Join missing condition

Code reviewCode quality & reviewMid–Senior~18 min

Review this query meant to list orders with their customer name.

What a strong answer looks like

Separate real bugs from style. Rank issues by severity, point at the root cause rather than the symptom, and suggest a concrete fix, specific and kind.

0:00 of about 18 min
Mark a line and say what kind of problem it is.0 findings
1SELECT o.id, c.name
2FROM orders o, customers c
3WHERE o.total > 100;
Which questions mattered is sealed until you submit. Telling you now would just be handing over the edge cases.