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
ID of the stations = t2.id; with 10 precipitation = t1.precipitation = 10;