Task: Text to Code
Input (English): Step 1: For each row in hosting_city table, find corresponding rows in city table and in match table.
Step 2: find City of the results of step 1 whose Competition equals 1994 FIFA World Cup qualification and Competition equals Friendly match
Output (English): SELECT T1.City FROM city AS T1 JOIN match AS T2 JOIN hosting_city AS T3 ON T1.City_ID = T3.Host_City AND T3.Match_ID = T2.Match_ID WHERE T2.Competition = "Friendly match" AND T2.Competition = "1994 FIFA World Cup qualification"