CREATE TABLE temperature (city_id NUMBER, jan NUMBER, feb NUMBER, mar NUMBER, apr NUMBER, jun NUMBER, jul NUMBER, aug NUMBER, sep NUMBER, oct NUMBER, nov NUMBER, dec NUMBER)
CREATE TABLE city (city_id NUMBER, city CLOB, hanzi CLOB, hanyu_pinyin CLOB, regional_population NUMBER, gdp NUMBER)
CREATE TABLE hosting_city (year NUMBER, match_id NUMBER, host_city CLOB)
CREATE TABLE match (match_id NUMBER, date CLOB, venue CLOB, score CLOB, result CLOB, competition CLOB)

What is the match id of the competition called '1994 FIFA World Cup qualification'?
SELECT match_id FROM match WHERE competition = "1994 FIFA World Cup qualification"
SELECT "match_id" FROM "match" WHERE "1994 FIFA World Cup qualification" = "competition"