SQL Query for Teacher Criteria | Dataford Interview Questions

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.

Requirements

Join the teacher, course assignment, and course tables.
Keep only teachers whose age is greater than 60 and courses categorized as Programming.
Count distinct programming courses per teacher.
Return the teacher name and course count, ordered alphabetically by teacher name.

Schema

teachers

Column	Type	Description
teacher_idPK	INT	Unique teacher identifier
teacher_name	VARCHAR(100)	Teacher's full name
age	INT	Teacher's age in years

teacher_courses

Column	Type	Description
assignment_idPK	INT	Unique teaching assignment identifier
teacher_id	INT	References teachers.teacher_id
course_id	INT	References courses.course_id

courses

Column	Type	Description
course_idPK	INT	Unique course identifier
course_name	VARCHAR(150)	Course title
course_category	VARCHAR(50)	Course classification

Your question is SQL Query for Teacher Criteria. Start with the requirements and the three tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem