What is the maximum weight being transported to New York during a single shipment?
"New York" is the city_name; maximum weight refers to Max(weight)
SELECT MAX(T1.weight) FROM shipment AS T1 INNER JOIN city AS T2 ON T1.city_id = T2.city_id WHERE T2.city_name = 'New York'