Find the Cancelled Orders

Meridian Retail Co. · SQL · beginner

The brief

Nura here. I need to understand exactly where the ₦18.4M gap is coming from. Can you show me the revenue broken down by order status — both the gross total (all statuses) and net total (excluding cancelled, returned and refunded)? I want to see the difference clearly.

Independent grading

92/100

Achieved 3 Nov 2026

Graded automatically against a fixed rubric for this task. Feedback and submitted work remain private to the analyst.

What is DataSimHQ?

A practice platform where analysts complete graded business tasks for simulated companies in SQL, Power BI, and Excel, and build a portfolio of proven work. Learn more