Table schema:
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?
SQL: SELECT years FROM table_name_30 WHERE ties > 1 AND wins < 311 AND losses = 174