Advanced · SQL · Data quality

Orders whose items don't add up

Commonly asked: E-commerce data-integrity checks · ~12 min

Return order_id, total and items_total (sum of quantity × unit_price, rounded to 2) where they differ by more than 0.01. Sort by order_id.