What year has the ride flight deck and a rating of less than 5?
CREATE TABLE table_name_47 (year_opened VARCHAR, ride VARCHAR, rating VARCHAR)
SELECT COUNT(year_opened) FROM table_name_47 WHERE ride = "flight deck" AND rating < 5
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_47 (year_opened VARCHAR, ride VARCHAR, rating VARCHAR) Question: What year has the ride flight deck and a rating of less than 5? [/INST] SELECT COUNT(year_opened) FROM table_name_47 WHERE ride = "flight deck" AND rating < 5 </s>