hi, what is the maximum low temperature at Amersham station?
select max ( t1.low_temperature ) from weekly_weather as t1 join station as t2 on t1.station_id = t2.id where t2.network_name = "Amersham"
Yes, in what say was the maximum low temperature in Amersham station.
select t1.day_of_week from weekly_weather as t1 join station as t2 on t1.station_id = t2.id where t2.network_name = "Amersham" order by low_temperature desc limit 1
Can you tell me what is the average precipitation at the Amersham station?
select avg ( t1.precipitation ) from weekly_weather as t1 join station as t2 on t1.station_id = t2.id where t2.network_name = "Amersham"