← Practice challengesFree companion · 15 minute suggested activity

Find average order value at order grain

SQL practice · Retail case · 15–20 minutes. Start with retail-setup.sql in a disposable local SQLite database.

Learn → Try → ExplainReviewed 2026-10-15

Your task

Compute average completed order value; explain why averaging line values would answer a different question. 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

EUR 116.67, from EUR 700 divided by 6 completed orders. There are no line items in this source.

SELECT ROUND(AVG(net_cents)/100.0,2) aov_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.

Resume guidance and examples are for learning and preparation only. They do not guarantee interviews, a job offer or employment.

Public registration, payments and new paid enrolment remain disabled. These free resources do not grant access to protected course modules.

Learner dashboard ↗ · Ask a question ↗