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_15 (loss VARCHAR, long VARCHAR, gain VARCHAR)
  ### Question:
  WHAT IS THE NUMBER OF LOSSES WITH A LONG SMALLER THAN 24, AND GAIN BIGGER THAN 116?
  ### Answer:
  SELECT COUNT(loss) FROM table_name_15 WHERE long < 24 AND gain > 116