Which Competition has an Event of 50km, a Year earlier than 2010 and a Position of 3rd?
CREATE TABLE table_name_46 (competition VARCHAR, position VARCHAR, event VARCHAR, year VARCHAR)
SELECT competition FROM table_name_46 WHERE event = "50km" AND year < 2010 AND position = "3rd"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_46 (competition VARCHAR, position VARCHAR, event VARCHAR, year VARCHAR) Question: Which Competition has an Event of 50km, a Year earlier than 2010 and a Position of 3rd? [/INST] SELECT competition FROM table_name_46 WHERE event = "50km" AND year < 2010 AND position = "3rd" </s>