What date was the competition of the Emerging Nations Tournament and a result of Scotland 34-9 Russia?
CREATE TABLE table_name_51 (date VARCHAR, competition VARCHAR, result VARCHAR)
SELECT date FROM table_name_51 WHERE competition = "emerging nations tournament" AND result = "scotland 34-9 russia"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_51 (date VARCHAR, competition VARCHAR, result VARCHAR) Question: What date was the competition of the Emerging Nations Tournament and a result of Scotland 34-9 Russia? [/INST] SELECT date FROM table_name_51 WHERE competition = "emerging nations tournament" AND result = "scotland 34-9 russia" </s>