1)What was the hottest day in our data set? Where was that?
select
	zip,
	max(maxtemperatureF)
from
	weather


2) How many trips started at each station?
select
	start_station,
	count(*) number_trips
from
	trips
GROUP BY 1

3)What's the shortest trip that happened?
select
	min(duration)Shortest_trip
from
	trips

4) What is the average trip duration, by end station?
select
	end_station,
	AVG(duration) Average_Duration
from
	trips
Group BY 1