Code reviewHardcr-g646

Subject Sql group byLevel Mid–Senior~24 minCommon in Databases & SQL interviewsIndustries Software development

Question

Review this SQL meant to show each product's latest price and total units sold.

This runs on MySQL with `ONLY_FULL_GROUP_BY` disabled.

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 p.category,2       p.name,3       p.price,4       SUM(s.units) AS units_sold5FROM products p6JOIN sales s ON s.product_id = p.id7GROUP BY p.category;

Run or narrate your approach, then ask the coach.