SELECT fname ,  lname FROM Faculty WHERE Rank  =  "Instructor"
Show the first name and last name for all the instructors.
SELECT fname , lname FROM Faculty WHERE Rank = `` Instructor ''
select fname , lname from faculty where rank = value
Show the first name and last name for all the instructors .