What is earliest year that had a 50km event with a 2nd place result played in London, United Kingdom?
CREATE TABLE table_name_8 (year INTEGER, venue VARCHAR, event VARCHAR, result VARCHAR)
SELECT MIN(year) FROM table_name_8 WHERE event = "50km" AND result = "2nd" AND venue = "london, united kingdom"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_8 (year INTEGER, venue VARCHAR, event VARCHAR, result VARCHAR) Question: What is earliest year that had a 50km event with a 2nd place result played in London, United Kingdom? [/INST] SELECT MIN(year) FROM table_name_8 WHERE event = "50km" AND result = "2nd" AND venue = "london, united kingdom" </s>