#What was the hottest day? Where was that?

SElECT
	zip,
	max(MaxTemperatureF)
FROM
	weather

#How many trips started at each station?

SELECT
	start_station,
	Count(*)  trip_count
FROM
	trips
Group by 1

#What's the shortest trip that happened?

SELECT
	*
FROM
	trips
WHERE
	duration = 100
LIMIT 1

#What is the average trip duration, by end station?

SELECT
	end_station,
	AVG(duration)  average_duration
FROM
	trips
GROUP by 1