CREATE TABLE FACULTY (Rank VARCHAR)

Find the rank of the faculty that the fewest faculties belong to.
SELECT Rank FROM FACULTY GROUP BY Rank ORDER BY COUNT(*) LIMIT 1
SELECT "Rank" FROM "FACULTY" GROUP BY "Rank" ORDER BY COUNT(*) NULLS FIRST LIMIT 1