what is the sum of the year in rhode island
CREATE TABLE table_name_99 (year INTEGER, state VARCHAR)
SELECT SUM(year) FROM table_name_99 WHERE state = "rhode island"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_99 (year INTEGER, state VARCHAR) Question: what is the sum of the year in rhode island [/INST] SELECT SUM(year) FROM table_name_99 WHERE state = "rhode island" </s>