Show the first name and last name for all the instructors.
CREATE TABLE Faculty (fname VARCHAR, lname VARCHAR, Rank VARCHAR)
SELECT fname, lname FROM Faculty WHERE Rank = "Instructor"
### Context: CREATE TABLE Faculty (fname VARCHAR, lname VARCHAR, Rank VARCHAR) ### Question: Show the first name and last name for all the instructors. ### Answer: SELECT fname, lname FROM Faculty WHERE Rank = "Instructor"