What is the current status of the order with the highest shipping cost?
shipping cost and Freight are synonyms; highest shipping cost refers to MAX(Freight);
SELECT Status FROM SalesOrderHeader ORDER BY Freight DESC LIMIT 1