text: Below is an context that describes a sql query, paired with an question that provides further information. Write an answer that appropriately completes the request.  # noqa: E501
  ### Context:
  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?
  ### Answer:
  SELECT COUNT(year_opened) FROM table_name_47 WHERE ride = "flight deck" AND rating < 5