CREATE TABLE COURSE (Instructor VARCHAR, CName VARCHAR)
CREATE TABLE FACULTY (Fname VARCHAR, Lname VARCHAR, FacID VARCHAR)

Find the first name and last name of the instructor of course that has course name
SELECT T2.Fname, T2.Lname FROM COURSE AS T1 JOIN FACULTY AS T2 ON T1.Instructor = T2.FacID WHERE T1.CName = "COMPUTER LITERACY"
SELECT "T2"."Fname", "T2"."Lname" FROM "COURSE" AS "T1" JOIN "FACULTY" AS "T2" ON "T1"."Instructor" = "T2"."FacID" WHERE "COMPUTER LITERACY" = "T1"."CName"