Which location had a race that took place on 22 July 2011 and has a rank greater than 8?
CREATE TABLE table_name_45 (location VARCHAR, rank VARCHAR, date VARCHAR)
SELECT location FROM table_name_45 WHERE rank > 8 AND date = "22 july 2011"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_45 (location VARCHAR, rank VARCHAR, date VARCHAR) Question: Which location had a race that took place on 22 July 2011 and has a rank greater than 8? [/INST] SELECT location FROM table_name_45 WHERE rank > 8 AND date = "22 july 2011" </s>