SELECT fname ,  lname FROM Faculty WHERE Rank  =  "Instructor"
What are the first name and last name of all the instructors?
SELECT fname , lname FROM Faculty WHERE Rank = `` Instructor ''
select fname , lname from faculty where rank = value
What are the first name and last name of all the instructors ?