Intermediate · SQL · Data quality

Duplicate product lines in an order

Commonly asked: QA data-validation rounds · ~7 min

Find orders where the same product appears on more than one line. Return order_id, product_id and lines, sorted by order_id then product_id.