Tell me title name for all course ids....
select course_id, title from course
Higher than 80000.....
select name from instructor where salary > 80000
Find the name of the instructors who taught C programming course before..
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'