SELECT
	zip,
	MAX(maxtemperaturef) as highest_temperature
FROM
	weather
GROUP BY
	zip
ORDER BY
	highest_temperature desc
LIMIT 1;