CREATE TABLE participates_in (stuid NUMBER, actid NUMBER)
CREATE TABLE activity (actid NUMBER, activity_name CLOB)
CREATE TABLE faculty (facid NUMBER, lname CLOB, fname CLOB, rank CLOB, sex CLOB, phone NUMBER, room CLOB, building CLOB)
CREATE TABLE student (stuid NUMBER, lname CLOB, fname CLOB, age NUMBER, sex CLOB, major NUMBER, advisor NUMBER, city_code CLOB)
CREATE TABLE faculty_participates_in (facid NUMBER, actid NUMBER)

Which rank has the smallest number of faculty members?
SELECT rank FROM faculty GROUP BY rank ORDER BY COUNT(*) LIMIT 1
SELECT "rank" FROM "faculty" GROUP BY "rank" ORDER BY COUNT(*) FETCH FIRST 1 ROWS ONLY