The Life Starter
0 of 6 complete0%
Course Library · Lesson 4 of 6
Digital · Guided lesson

Calculate a running total

About 16 minutes · 4 reading + 12 practice and checks
Time includes reading, practice, and questions. Extra videos or further study are optional.
See this course’s project requirements

A reproducible SQLite attendance analysis with per-session rank, running totals and prior-period changes that retains every original row.

Keep your working files in your own notebook or software. Save a private description, checklist, and work link in My Proof.

What to include

  • A grouped-versus-windowed result choice.
  • An independent session sequence with deterministic ordering.
  • A week rank record 3,1,1 with declared tie behavior.
  • Running-total rows A 8,20,32 and B 6,15.
  • A row-comparison record with honest missing-baseline handling.
  • A reproducible window-analysis packet.

Review and revise

Use these criteria to check your work and choose what to improve.

  • The implementation or declared simulation follows the supplied contract and retains inspectable original inputs.
  • Normal, boundary and rejected cases are recorded with expected versus observed results.
  • The changed case has a correct explanation and does not rely on hidden state.
  • The project includes source, outputs, instructions and honest tool, privacy and verification limits.
Open the full course project
Want more background?
Before you begin

The idea in everyday life

A attendees 8,12,12 creates running 8,20,32. B 6,9 creates 6,15.

The idea

The frame ROWS from UNBOUNDED PRECEDING through CURRENT ROW includes all preceding ordered rows and the current one in that partition. Spell out the frame instead of assuming default peer group behavior.

Follow along

Calculate a running total — original worked practice

The frame ROWS from UNBOUNDED PRECEDING through CURRENT ROW includes all preceding ordered rows and the current one in that partition. Spell out the frame instead of assuming default peer group behavior.

A attendees 8,12,12 creates running 8,20,32. B 6,9 creates 6,15.

  1. 1. Step 1

    Read the specified ROWS frame.

    You should see: The current row and all prior ordered rows are included.

    This keeps the rule and its observable result together.

  2. 2. Step 2

    Accumulate A week 1 and 2.

    You should see: 8 then 8+12=20.

    This keeps the rule and its observable result together.

  3. 3. Step 3

    Add A week 3 and check grouped total.

    You should see: 32 matches the session total.

    This keeps the rule and its observable result together.

  4. 4. Step 4

    Trace B separately and record both series.

    You should see: Running-total rows A 8,20,32 and B 6,15.

    This keeps the rule and its observable result together.

Now change one thing

A week 3 changes from 12 to 15. Enter final A running total.

Your work

What to finish

Running-total rows A 8,20,32 and B 6,15.

Common mistake

Watch for this

Relying on an implicit peer frame instead of the explicit row-by-row frame required by this report.

How can I tell I understand it?

Explain and demonstrate the required distinction: The frame ROWS from UNBOUNDED PRECEDING through CURRENT ROW includes all preceding ordered rows and the current one in that partition. Spell out the frame instead of assuming default peer group behavior. Show a changed input and the expected result without weakening this contract.

Try 3 questions

Quick knowledge check

Answer all 3 questions. Get at least 2 right and the lesson completes automatically.

Not yet passed

You’ll get an explanation for each answer. Signed in? Your results save to your account.

1What is the A week 2 running total?
2Why state ROWS explicitly?
3What should final running total match for each partition?
0 of 3 answeredApply the lesson to a short question, then review the explanation.
4
Finish this lesson

Pass the check. We’ll save the progress.

Answer all 3 questions above and get at least 2 right. You can review the explanations and try again.

Go to the knowledge check
Tools, templates, and lesson sources

Tools and templates

Tools open in a new tab so you can keep your place here.

Sources and further reading

Explore the references behind this lesson.

www.sqlite.org — window functions.html
Source & access notes · checked 2026-10-01

Relevant documented module/API behavior inspected during expansion authoring; actual execution evidence is recorded separately. No grant eligibility is established.

Access: Official page retrieved with the web reader on 2026-10-01. Documentation reading does not certify execution in every native tool or browser.

Reuse: Original local practice files, fictional data, worked examples and questions. Concepts paraphrased and linked; source exercises are not copied.

Report a problem with this lesson

Tell us what went wrong. Please leave out personal information and private project contents.

No sign-in needed.