How many games are associated with over 0 golds and a first year before 2008?
CREATE TABLE table_name_61 (games INTEGER, gold VARCHAR, first VARCHAR)
SELECT SUM(games) FROM table_name_61 WHERE gold > 0 AND first < 2008
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_61 (games INTEGER, gold VARCHAR, first VARCHAR) Question: How many games are associated with over 0 golds and a first year before 2008? [/INST] SELECT SUM(games) FROM table_name_61 WHERE gold > 0 AND first < 2008 </s>