What are the names of all instructors?
select name from instructor
Of those, which have taught a C Programming course?
select t1.name from instructor as t1 join teaches as t2 on t1.id = t2.id join course as t3 on t2.course_id = t3.course_id where t3.title = 'C Programming'