Where was shipment no. 1002 headed?
shipment no. 1002 refers to ship_id = 1002; where shipment was headed refers to city_name
SELECT T2.city_name FROM shipment AS T1 INNER JOIN city AS T2 ON T1.city_id = T2.city_id WHERE T1.ship_id = '1002'