SELECT Rank FROM FACULTY GROUP BY Rank ORDER BY count(*) ASC LIMIT 1
Find the rank of the faculty that the fewest faculties belong to.
create table Student (
        StuID        INTEGER PRIMARY KEY,
        LName        VARCHAR(12),
        Fname        VARCHAR(12),
        Age      INTEGER,
        Sex      VARCHAR(1),
        Major        INTEGER,
        Advisor      INTEGER,
        city_code    VARCHAR(3)
 );
create table Faculty (
       FacID 	       INTEGER PRIMARY KEY,
       Lname		VARCHAR(15),
       Fname		VARCHAR(15),
       Rank		VARCHAR(15),
       Sex		VARCHAR(1),
       Phone		INTEGER,
       Room		VARCHAR(5),
       Building		VARCHAR(13)
);
create table Department (
       DNO   		INTEGER PRIMARY KEY,
       Division		VARCHAR(2),
       DName		VARCHAR(25),
       Room		VARCHAR(5),
       Building		VARCHAR(13),
       DPhone		INTEGER
);
create table Member_of (
       FacID 	       INTEGER,
       DNO	       INTEGER,
       Appt_Type       VARCHAR(15),
       FOREIGN KEY(FacID) REFERENCES Faculty(FacID),
       FOREIGN KEY(DNO) REFERENCES Department(DNO)
);
create table Course (
       CID   	    	VARCHAR(7) PRIMARY KEY,
       CName		VARCHAR(40),
       Credits		INTEGER,
       Instructor	INTEGER,
       Days		VARCHAR(5),
       Hours		VARCHAR(11),
       DNO		INTEGER,
       FOREIGN KEY(Instructor) REFERENCES Faculty(FacID),
       FOREIGN KEY(DNO) REFERENCES Department(DNO)
);
create table Minor_in (
       StuID 	      INTEGER,
       DNO		INTEGER,
       FOREIGN KEY(StuID) REFERENCES Student(StuID),
       FOREIGN KEY(DNO) REFERENCES Department(DNO)
);
create table Enrolled_in (
       StuID 		 INTEGER,
       CID		VARCHAR(7),
       Grade		VARCHAR(2),
       FOREIGN KEY(StuID) REFERENCES Student(StuID),
       FOREIGN KEY(CID) REFERENCES Course(CID),
       FOREIGN KEY(Grade) REFERENCES Gradeconversion(lettergrade)
);
create table Gradeconversion (
       lettergrade	     VARCHAR(2) PRIMARY KEY,
       gradepoint	     FLOAT
);
INSERT into Minor_in values ( 1004, 520);
INSERT into Enrolled_in values ( 1001, '550.681', 'A-');
INSERT into Gradeconversion values ('A+', 4.0);
INSERT into Faculty  values ( 1082, 'Giuliano', 'Mark', 'Instructor', 'M', 2424, '224', 'NEB');
INSERT into Department  values ( 010, 'AS', 'History of Art', '268', 'Mergenthaler', 7117);
INSERT into Member_of values (7792,  600, 'Primary');
INSERT into Course values ( '600.101', 'COMPUTER LITERACY', 3, 6112, 'MTW', '3',600);
INSERT into Student values ( 1001, 'Smith', 'Linda', 18, 'F', 600, 1121,'BAL');
INSERT INTO Student VALUES [(1001, 'Smith', 'Linda', 18, 'F', 600, 1121, 'BAL'), (1002, 'Kim', 'Tracy', 19, 'F', 600, 7712, 'HKG')]
INSERT INTO Faculty VALUES [(1082, 'Giuliano', 'Mark', 'Instructor', 'M', 2424, '224', 'NEB'), (1121, 'Goodrich', 'Michael', 'Professor', 'M', 3593, '219', 'NEB')]
INSERT INTO Department VALUES [(10, 'AS', 'History of Art', '268', 'Mergenthaler', 7117), (20, 'AS', 'Biology', '144', 'Mudd', 7330)]
INSERT INTO Member_of VALUES [(7792, 600, 'Primary'), (9210, 520, 'Primary')]
INSERT INTO Course VALUES [('600.101', 'COMPUTER LITERACY', 3, 6112, 'MTW', '3', 600), ('600.103', 'INTRODUCTION TO COMPUTER SCIENCE', 1, 4230, 'Th', '4', 600)]
INSERT INTO Minor_in VALUES [(1004, 520), (1005, 550)]
INSERT INTO Enrolled_in VALUES [(1001, '550.681', 'A-'), (1001, '600.303', 'B')]
INSERT INTO Gradeconversion VALUES [('A+', 4.0), ('A', 4.0)]