Which Score-Final has a Rank-Final of 2, and a Year smaller than 2008?
CREATE TABLE table_name_42 (score_final INTEGER, rank_final VARCHAR, year VARCHAR)
SELECT SUM(score_final) FROM table_name_42 WHERE rank_final = 2 AND year < 2008
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_42 (score_final INTEGER, rank_final VARCHAR, year VARCHAR) Question: Which Score-Final has a Rank-Final of 2, and a Year smaller than 2008? [/INST] SELECT SUM(score_final) FROM table_name_42 WHERE rank_final = 2 AND year < 2008 </s>