Module 07 Activity

Scenario

Two questions that summarising alone cannot answer: "how did revenue accumulate through the month?" and "what share of revenue does each country represent?" Both need per-row detail kept alongside the totals.

Task

1. Produce daily completed revenue, one row per day.
2. Add a running total that accumulates across days in date order.
3. Confirm the final running-total value equals the overall completed revenue. If it does not, your

ordering or your frame is wrong.

1. Separately, produce revenue by country with a share of total column, computed inside the query

rather than by dividing by a number you pasted in.

1. Confirm the shares sum to 100%.

Deliverable

Two small tables: a daily accumulation table (date | daily | running total) and a country share table (country | revenue | % of total), each with the check that proves it closes.

Check your work

The first three days:

Each running-total value is the sum of every daily value up to and including that row. The final row, on 30 June, must reach ₹26,85,905 - the completed revenue total. That single check confirms your window covered every row exactly once.

Country shares:

Those sum to 100.0%. Computing the denominator with a window function rather than typing 2685905 into the query is what keeps this correct when the data changes tomorrow.

The trap

If you compute the share by dividing by a hardcoded total, the query silently becomes wrong the moment a new order arrives - and it will keep producing plausible percentages that no longer sum to 100. Let the query find its own denominator, then assert that the shares close.

Mark complete