Show the first name of faculty.
select fname from faculty
Also show the last name for them.
select fname, lname from faculty
Also show the rank for them.
select rank, fname, lname from faculty