user: ### NOW ANSWER:
Question: What is the total number of rank with losses less than 992, north carolina state College and a season greater than 101?
Columns: ['Rank', 'College', 'First Season', 'Seasons', 'Wins', 'Losses']
Types: ['real', 'text', 'real', 'real', 'real', 'real']
Sample row: [1.0, 'Kentucky', 1903.0, 110.0, 2111.0, 661.0]
SQL:

assistant: SELECT COUNT("Rank") FROM "Table" WHERE "Losses" < 992.0 AND "College" = 'north carolina state' AND "Seasons" > 101.0;