Show the rank for each member of faculty.
select rank from faculty
What different ranks are there?
select distinct rank from faculty