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_30 (years VARCHAR, losses VARCHAR, ties VARCHAR, wins VARCHAR)
  ### Question:
  What years did the person coach who had more than 1 tie, mess than 311 wins and 174 losses?
  ### Answer:
  SELECT years FROM table_name_30 WHERE ties > 1 AND wins < 311 AND losses = 174