Which flight had the aircraft avro rj-100?
CREATE TABLE table_name_28 (flight VARCHAR, aircraft VARCHAR)
SELECT flight FROM table_name_28 WHERE aircraft = "avro rj-100"
### Context: CREATE TABLE table_name_28 (flight VARCHAR, aircraft VARCHAR) ### Question: Which flight had the aircraft avro rj-100? ### Answer: SELECT flight FROM table_name_28 WHERE aircraft = "avro rj-100"