CREATE TABLE table_name_47 (year_opened VARCHAR(255), ride VARCHAR(255), rating VARCHAR(255))
What year has the ride flight deck and a rating of less than 5?
    
SQL: SELECT COUNT(year_opened) FROM table_name_47 WHERE ride = "flight deck" AND rating < 5