Rank completed orders reproducibly

Your task

Rank orders by value and break ties by order_id. Return only the top three. 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

R05 18000; R02 15000; R06 12000. ROW_NUMBER gives distinct positions; use DENSE_RANK only when ties should share a rank.

SELECT order_id,net_cents,ROW_NUMBER() OVER(ORDER BY net_cents DESC,order_id) value_rank FROM orders WHERE status='completed' ORDER BY value_rank LIMIT 3;

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.