Find the orders whose totals do not add up
A hands-on DEA-C01 lab. You produce the real artefact and 8 automated checks verify it behaves the way the exam expects.
Try this labAll DEA-C01 practice
- Certification
- DEA-C01
- Format
- SQL query
- Difficulty
- medium
- Estimated time
- 14 min
- Automated checks
- 8
The brief
Write one read-only query in order-total-audit.sql against orders and order_lines. Return exactly order_id, expected_cents, calculated_cents, and difference_cents for every mismatch. Sum all line_cents for each order, treat no line rows as zero, calculate difference_cents as expected_cents minus calculated_cents, and exclude orders whose totals match.
Part of DEA-C01 preparation
Labs are written by ExamNova to teach the decisions the exam tests. They are not reproductions of vendor lab content.