Table schema:
CREATE TABLE table_name_37 (date VARCHAR, tie_no VARCHAR)

Question: What is the date of tie no. 34?
SQL: SELECT date FROM table_name_37 WHERE tie_no = "34"