Proposal
`course/03_week03_normalization/queries_v1.sql` contains 10 example queries (daily schedule, patient history, doctor workload, etc.) but provides no expected output.
Add comments showing the expected result set for each query given the seed data. For example:
```sql
-- Q1: Daily schedule for a given doctor on a given date
-- Expected: 2 rows (appointments for doctor_id=1 on 2025-01-15)
SELECT ...
```
Why
Students running queries for the first time need to verify their environment is set up correctly. Without expected output, they can't tell if missing rows indicate a problem.
Scope / files impacted
- `course/03_week03_normalization/queries_v1.sql`
Proposal
`course/03_week03_normalization/queries_v1.sql` contains 10 example queries (daily schedule, patient history, doctor workload, etc.) but provides no expected output.
Add comments showing the expected result set for each query given the seed data. For example:
```sql
-- Q1: Daily schedule for a given doctor on a given date
-- Expected: 2 rows (appointments for doctor_id=1 on 2025-01-15)
SELECT ...
```
Why
Students running queries for the first time need to verify their environment is set up correctly. Without expected output, they can't tell if missing rows indicate a problem.
Scope / files impacted