Tell me the sum of cap/hor for double chair and vertical less than 479
CREATE TABLE table_name_8 (cap_hour INTEGER, type VARCHAR, vertical VARCHAR)
SELECT SUM(cap_hour) FROM table_name_8 WHERE type = "double chair" AND vertical < 479
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_8 (cap_hour INTEGER, type VARCHAR, vertical VARCHAR) Question: Tell me the sum of cap/hor for double chair and vertical less than 479 [/INST] SELECT SUM(cap_hour) FROM table_name_8 WHERE type = "double chair" AND vertical < 479 </s>