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"