Your question is SQL Query for Teacher Criteria. Start with the requirements and the three tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
i2c Academy wants to identify experienced instructors who teach a broad programming curriculum. Write a PostgreSQL query to display teachers older than 60 who teach more than three distinct programming courses.
Programming.| Column | Type | Description |
|---|---|---|
| teacher_idPK | INT | Unique teacher identifier |
| teacher_name | VARCHAR(100) | Teacher's full name |
| age | INT | Teacher's age in years |
| Column | Type | Description |
|---|---|---|
| assignment_idPK | INT | Unique teaching assignment identifier |
| teacher_id | INT | References teachers.teacher_id |
| course_id | INT | References courses.course_id |
| Column | Type | Description |
|---|---|---|
| course_idPK | INT | Unique course identifier |
| course_name | VARCHAR(150) | Course title |
| course_category | VARCHAR(50) | Course classification |