Abaixo está uma instrução que descreve uma tarefa de geração de SQL, combinada com uma entrada que fornece mais contexto sobre os esquemas de tabela disponíveis. Escreva o código SQL que responda adequadamente à solicitação
 ###Instrução: Qual voo teve a aeronave avro rj-100?
 ###Tabelas: CREATE TABLE head_to_head (head_to_head_id AUTO_INCREMENT PRIMARY KEY, Tournament VARCHAR, Matches INT, Wins Olimpia INT, Empates INT, Wins Cerro INT, Goals Olimpia INT, Goals Cerro INT) CREATE TABLE players_in (players_in_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Country VARCHAR, Type VARCHAR, Moving from VARCHAR, Transfer window VARCHAR, Transfer fee VARCHAR) CREATE TABLE incidents_and_accidents (incidents_and_accidents_id AUTO_INCREMENT PRIMARY KEY, Date VARCHAR, Flight VARCHAR, Aircraft VARCHAR, Registration VARCHAR, Location VARCHAR, Fatalities INT) CREATE TABLE season_3:_2004 (season_3:_2004_id AUTO_INCREMENT PRIMARY KEY, No. in Series INT, No. in Season INT, Title VARCHAR, Directed by VARCHAR, Written by VARCHAR, U.S. viewers (millions) VARCHAR, Original air date VARCHAR) CREATE TABLE club_and_player_records (club_and_player_records_id AUTO_INCREMENT PRIMARY KEY, Team VARCHAR, Opponent VARCHAR, Score VARCHAR, Venue VARCHAR, Round VARCHAR)  
SELECT Flight FROM incidents_and_accidents WHERE Aircraft = avro rj-100