Show the rank for all Faculty.
select rank from faculty
For each of them, show the number of faculty members.
select rank, count(*) from faculty group by rank
Order them by the number.
select rank from faculty group by rank order by count(*)
Which rank has the smallest number?
select rank from faculty group by rank order by count(*) asc limit 1