Show the first name and last name for all faculty.
select fname, lname from faculty
What about those with rank as Instructor?
select fname, lname from faculty where rank = "Instructor"