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
maximum precipitation higher than 50 refers to HAVING MAX(precipitation) > 50; need id and local authority of the station refers to SELECT t2.id, t2.local_authority; station is linked to weather data by station_id refers to JOIN station ON weekly_weather.station_id = station.id;