-- #1
SELECT
	zip,
	MAX(maxtemperaturef) AS temperature
FROM
	weather
GROUP BY zip;

-- #2
SELECT
	start_terminal,
	COUNT(*) AS trip_count
FROM
	trips
GROUP BY start_terminal;

--#3
SELECT
	duration
FROM
	trips
ORDER BY duration;

-- #4
SELECT
	end_station,
	AVG(duration) AS duration
FROM
	trips
GROUP BY end_station;