CREATE TABLE table_40823 ("AIRLINE" CLOB, "ICAO" CLOB, "IATA" CLOB, "CALLSIGN" CLOB, "COMMENCED OPERATIONS" CLOB)

What airline has a IATA of BX?
SELECT "AIRLINE" FROM table_40823 WHERE "IATA" = 'bx'
SELECT "AIRLINE" FROM "table_40823" WHERE "IATA" = 'bx'