What is the total number of years wehre anna thompson had a 3rd place result at edinburgh, scotland?
CREATE TABLE table_name_28 (year VARCHAR, result VARCHAR, venue VARCHAR)
SELECT COUNT(year) FROM table_name_28 WHERE result = "3rd" AND venue = "edinburgh, scotland"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_28 (year VARCHAR, result VARCHAR, venue VARCHAR) Question: What is the total number of years wehre anna thompson had a 3rd place result at edinburgh, scotland? [/INST] SELECT COUNT(year) FROM table_name_28 WHERE result = "3rd" AND venue = "edinburgh, scotland" </s>