text: Below is an context that describes a sql query, paired with an question that provides further information. Write an answer that appropriately completes the request.  # noqa: E501
  ### Context:
  CREATE TABLE table_name_87 (rank VARCHAR, seasons VARCHAR, losses VARCHAR, college VARCHAR)
  ### Question:
  What is the total number of rank with losses less than 992, North Carolina State College and a season greater than 101?
  ### Answer:
  SELECT COUNT(rank) FROM table_name_87 WHERE losses < 992 AND college = "north carolina state" AND seasons > 101