What is the total number of medals won by nations that had 7 bronze medals and more than 18 gold medals?
CREATE TABLE table_name_26 (total INTEGER, bronze VARCHAR, gold VARCHAR)
SELECT SUM(total) FROM table_name_26 WHERE bronze = 7 AND gold > 18
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_26 (total INTEGER, bronze VARCHAR, gold VARCHAR) Question: What is the total number of medals won by nations that had 7 bronze medals and more than 18 gold medals? [/INST] SELECT SUM(total) FROM table_name_26 WHERE bronze = 7 AND gold > 18 </s>