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
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What year has the ride flight deck and a rating of less than 5? ### Input: CREATE TABLE table_name_47 (
    year_opened VARCHAR,
    ride VARCHAR,
    rating VARCHAR
) ### Response: SELECT COUNT(year_opened) FROM table_name_47 WHERE ride = "flight deck" AND rating < 5