What are the different faculty ranks?
select rank from faculty group by rank
Order them by the number of faculty in each rank.
select rank from faculty group by rank order by count(*) asc
Which has the fewest?
select rank from faculty group by rank order by count(*) asc limit 1