Compare two complete months

Your task

Produce April and May sales in chronological order. Use the same status filter in both periods. 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

April EUR 300; May EUR 400. Both months are complete within this fictional extract; there is no evidence of seasonality.

SELECT period,SUM(net_cents)/100.0 sales_eur FROM orders WHERE status='completed' GROUP BY period ORDER BY period;

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.