What type of ship is a Kobben class vessel that has been in service longer than 2?
CREATE TABLE table_name_18 (type VARCHAR, in_service VARCHAR, vessel VARCHAR)
SELECT type FROM table_name_18 WHERE in_service > 2 AND vessel = "kobben class"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_18 (type VARCHAR, in_service VARCHAR, vessel VARCHAR) Question: What type of ship is a Kobben class vessel that has been in service longer than 2? [/INST] SELECT type FROM table_name_18 WHERE in_service > 2 AND vessel = "kobben class" </s>