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_75 (name VARCHAR, rank VARCHAR, year VARCHAR)
  ### Question:
  I want the name for rank less than 6 and year more than 1974
  ### Answer:
  SELECT name FROM table_name_75 WHERE rank < 6 AND year > 1974