Question

Using pgSQL:

1) how many trips total were taken between the hours of 4:00 am and 6:00 am, and what was the average temperature of that day? I want a single overall query containing all the information. You should have a single row returned.

Sample Data

Temperature:

reading_id	STATION_NAME	DATE	TMAX	TMIN
1076	SEATTLE BOEING FIELD WA US	20161230	57	31
1077	SEATTLE BOEING FIELD WA US	20161231	40	31
1078	New York City Central Park	20160101	42	34
1079	New York City Central Park	20160102	40	32
1080	New York City Central Park	20160103	45	35
1081	New York City Central Park	20160104	36	14
1082	New York City Central Park	20160105	29	11

Taxi:

trip_id	vendor_id	tpep_pickup_datetime	tpep_dropoff_datetime	passenger_count	trip_distance
1	1	6/1/2016 0:00	6/1/2016 0:07	1	1.3
2	1	6/1/2016 0:00	6/1/2016 0:15	1	5.9
3	1	6/1/2016 0:00	6/1/2016 0:14	4	2.3
4	2	6/1/2016 0:00	6/1/2016 0:00	1	2.59
5	1	6/1/2016 0:00	6/1/2016 0:03	3	0.9
6	1	6/1/2016 0:00	6/1/2016 0:06	1	1.3
7	2	6/1/2016 0:00	6/1/2016 0:03	1	0.76

Answer 1