What are the full names of all faculty?
select fname, lname from faculty
Of those, which has a course named COMPUTER LITERACY?
select t2.fname, t2.lname from course as t1 join faculty as t2 on t1.instructor = t2.facid where t1.cname = "COMPUTER LITERACY"