Schema: CREATE TABLE table_name_99 (date VARCHAR, major VARCHAR, country VARCHAR)
Question: On what Date was The Open Championship in Japan?
SQL: SELECT date FROM table_name_99 WHERE major = "the open championship" AND country = "japan"