Count completed orders and reconcile sales

Your task

Report the count and EUR sales for completed orders only. Cancelled orders remain in the source but do not enter this KPI. Write the query before opening the solution. Record the expected output grain.

Hint

Apply the status filter before aggregation. State whether the result represents orders, channels or periods. Keep currency units explicit.

Worked solution

6 completed orders; EUR 700. The two cancelled orders contribute EUR 90 to an unfiltered sum and must be excluded.

SELECT COUNT(*) completed_orders, SUM(net_cents)/100.0 sales_eur FROM orders WHERE status='completed';

Check your reasoning

Reconcile the result to the source and describe one limitation. This tiny fictional dataset cannot establish customer behavior or predict future sales.

Make the reasoning yours.

Try the activity before reading its reference. Keep your sources, commands and assumptions with your work. Companion activities are unsaved self-practice and do not award a certificate or change lesson progress.