Lab 3: The Monthly KPI Report
Build a monthly KPI report from the fictional Grandma’s Marathon registration and race data.
BEFORE THE LAB
1. Prepare for Lab 3
DURING THE LAB
2. Use the official questions and data
The handout contains the complete questions, required column names, findings, and report instructions. Keep its question numbers in your report.
- Lab 3 Take-Home Handout: The Monthly KPI Report (PDF, with walkthrough) ↗
- Week 3 database (grandmas_marathon.db) ↗
Grandma’s Marathon
The assigned teaching database is ready in the browser. Quick schema shows its tables and columns; signed-in, approved students can save SQL drafts to their account. Wait for the saved indicator before leaving; guests keep drafts on this device.
Keep your SQL as text, your result evidence, and your explanation together. Complete the handout’s client task and personal reflections where assigned.
AFTER THE LAB
3. Submit your own lab report
You may work with others as the handout permits, but each person submits their own report. Use the official report template and check the assignment for the current deadline and requirements.
Submit Lab 3 in Canvas ↗Running SQL or downloading a draft here does not submit anything to Canvas.