List the minimum precipitation of each station.
select min(t1.precipitation) from weekly_weather as t1 join station as t2 on t1.station_id = t2.id group by t1.station_id;
How about the max precipitation? Show station id as well.
select t2.id, max(t1.precipitation) from weekly_weather as t1 join station as t2 on t1.station_id = t2.id group by t1.station_id;
Find the id and local authority of the station whose maximum precipitation is higher than 50.
select t2.id, 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;