Find the orders replayed overnight
A hands-on DEA-C01 lab. You produce the real artefact and 6 automated checks verify it behaves the way the exam expects.
Try this labAll DEA-C01 practice
- Certification
- DEA-C01
- Format
- SQL query
- Difficulty
- easy
- Estimated time
- 10 min
- Automated checks
- 6
The brief
Write one read-only query against raw_orders that returns exactly order_id and the complete occurrence count as duplicate_count for every order_id appearing more than once. Orders appearing once must not be returned.
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.