CREATE TABLE table_name_87 (rank VARCHAR2, seasons VARCHAR2, losses VARCHAR2, college VARCHAR2)

What is the total number of rank with losses less than 992, North Carolina State College and a season greater than 101?
SELECT COUNT(rank) FROM table_name_87 WHERE losses < 992 AND college = "north carolina state" AND seasons > 101
SELECT COUNT("rank") FROM "table_name_87" WHERE "college" = "north carolina state" AND "losses" < 992 AND "seasons" > 101