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_45 (type VARCHAR, year_s_ VARCHAR, bie_recognised VARCHAR, festival_name VARCHAR)
  ### Question:
  what is the type when the bie recognised is yes, festival name is floriade and the year(s) is 2002?
  ### Answer:
  SELECT type FROM table_name_45 WHERE bie_recognised = "yes" AND festival_name = "floriade" AND year_s_ = "2002"