How many gold medals were awarded to teams ranked higher than 19?
CREATE TABLE table_name_8 (gold VARCHAR, rank INTEGER)
SELECT COUNT(gold) FROM table_name_8 WHERE rank > 19
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_8 (gold VARCHAR, rank INTEGER) Question: How many gold medals were awarded to teams ranked higher than 19? [/INST] SELECT COUNT(gold) FROM table_name_8 WHERE rank > 19 </s>