Final Assessmentexamadvanced
Final Work Session 3
Third independent work session: SELECT queries section of the final assignment.
Overview
Students focus on the SELECT queries section: writing queries with JOINs, aggregates, subqueries, and CTEs against their schema and data. The instructor is available for questions.
Lesson Plan
| Time | Activity |
|---|---|
| 0–5 min | Progress check and open questions |
| 5–70 min | Independent work: SELECT queries section |
| 70–80 min | Checkpoint: instructor reviews query results |
Key Concepts
- Writing multi-table JOIN queries on the student's own schema
- Aggregate queries with GROUP BY and HAVING
- Using subqueries or CTEs for multi-step analysis
- Verifying query results match the expected output in the spec
- Formatting queries clearly for readability at defence time
✏️Practice
Students complete tasks independently.