user: ### NOW ANSWER:
Question: What date was the competition of the Emerging Nations Tournament and a result of Scotland 34-9 Russia?
Columns: ['Date', 'Result', 'Competition', 'Venue', 'Attendance']
Types: ['text', 'text', 'text', 'text', 'real']
Sample row: ['13 August 1995', 'Ireland 26-22 Scotland', 'Friendly', 'Dublin', 6000.0]
SQL:

assistant: SELECT "Date" FROM "Table" WHERE "Competition" = 'Emerging Nations Tournament' AND "Result" = 'Scotland 34-9 Russia';