SELECT rank FROM Faculty GROUP BY rank ORDER BY count(*) ASC LIMIT 1
Which rank has the smallest number of faculty members?
SELECT rank FROM Faculty GROUP BY rank ORDER BY count ( * ) ASC LIMIT 1
select rank from faculty group by rank order by count ( * ) asc limit value
Which rank has the smallest number of faculty members ?