Which IATA is associated with China and an ICAO of ZSPD?
CREATE TABLE table_name_59 (iata VARCHAR, country VARCHAR, icao VARCHAR)
SELECT iata FROM table_name_59 WHERE country = "china" AND icao = "zspd"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_59 (iata VARCHAR, country VARCHAR, icao VARCHAR) Question: Which IATA is associated with China and an ICAO of ZSPD? [/INST] SELECT iata FROM table_name_59 WHERE country = "china" AND icao = "zspd" </s>