Reconcile and explain window choices
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.
Want more background?
The idea in everyday life
Run windows.py on Python’s bundled SQLite with window-function support. Query retains 5 rows, A final 32 and B final 15.
A window analysis is credible when row counts, partitions, frames and tie definitions are visible. Present query and expected rows, not only an unexplained chart.
Reconcile and explain window choices — original worked practice
A window analysis is credible when row counts, partitions, frames and tie definitions are visible. Present query and expected rows, not only an unexplained chart.
Run windows.py on Python’s bundled SQLite with window-function support. Query retains 5 rows, A final 32 and B final 15.
1. Step 1
Execute the five assertions and record SQLite version if requested.
You should see: Five window checks pass.
This keeps the rule and its observable result together.
2. Step 2
Compare original and output row counts.
You should see: Both are 5.
This keeps the rule and its observable result together.
3. Step 3
Reconcile final running values with 32 and 15.
You should see: Both match grouped totals.
This keeps the rule and its observable result together.
4. Step 4
Package SQL, fixture, expected rows and tie/missing notes.
You should see: A reproducible window-analysis packet.
This keeps the rule and its observable result together.
What to finish
A reproducible window-analysis packet.
Watch for this
Comparing results produced by different window orders as if they used the same sequence.
How can I tell I understand it?
Explain and demonstrate the required distinction: A window analysis is credible when row counts, partitions, frames and tie definitions are visible. Present query and expected rows, not only an unexplained chart. Show a changed input and the expected result without weakening this contract.
Quick knowledge check
Answer all 3 questions. Get at least 2 right and the lesson completes automatically.
You’ll get an explanation for each answer. Signed in? Your results save to your account.
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 checkTools, 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.
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.
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.
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.