CREATE TABLE table_name_59 (iata VARCHAR, country VARCHAR, icao VARCHAR)

Which IATA is associated with China and an ICAO of ZSPD?
SELECT iata FROM table_name_59 WHERE country = "china" AND icao = "zspd"
SELECT "iata" FROM "table_name_59" WHERE "china" = "country" AND "icao" = "zspd"