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
names refers to network_name; local authorities refers to local_authority; condition on precipitation greater than 50 refers to HAVING max(t1.precipitation) > 50;