CREATE TABLE table_name_28 (flight VARCHAR, aircraft VARCHAR)

Which flight had the aircraft avro rj-100?
SELECT flight FROM table_name_28 WHERE aircraft = "avro rj-100"
SELECT "flight" FROM "table_name_28" WHERE "aircraft" = "avro rj-100"