Hi, can you please tell me what is the ID of the station whose maximum precipitation is higher than 50?
select t2.id from weekly_weather as t1 join station as t2 on t1.station_id = t2.id group by t1.station_id having max ( t1.precipitation ) > 50
thank you, could you please also let me know their names and local authorities?
select t2.id, t2.network_name, t2.local_authority from weekly_weather as t1 join station as t2 on t1.station_id = t2.id group by t1.station_id having max ( t1.precipitation ) > 50
that was quick, thank you again. then could you please let me know if there is any station which has less than 10 maximum precipitation?
select t2.id from weekly_weather as t1 join station as t2 on t1.station_id = t2.id group by t1.station_id having max ( t1.precipitation ) < 10
seems like everybody will have some rain here.. then could you please let me know what is the lowest precipitation we have on the table?
select min ( precipitation ) from weekly_weather
could you please let me know the ID of the stations with 10 precipitation?
select t2.id from weekly_weather as t1 join station as t2 on t1.station_id = t2.id where t1.precipitation = 10
what would be the name of the station?
select t2.id,t2.network_name from weekly_weather as t1 join station as t2 on t1.station_id = t2.id where t1.precipitation = 10
Then my last inquiry, could you please let me know Amersham's high temperature and wind speed on Friday?
select t1.high_temperature,t1.wind_speed_mph from weekly_weather as t1 join station as t2 on t1.station_id = t2.id where t1.day_of_week = 'Friday' and t2.network_name = 'Amersham'