Code reviewMediumcr-g526

Subject Boundary conditionsLevel Entry–Mid~13 minCommon in Databases & SQL interviewsIndustries Software development

Question

Review this SQL meant to find orders that have NOT been cancelled.

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.

Learn the concepts

Talk through your review

Code to reviewsql

1SELECT order_id, total2FROM orders3WHERE status != 'cancelled';

Run or narrate your approach, then ask the coach.