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
name of the station refers to network_name; joining tables to match station information refers to JOIN; matching a specific condition (precipitation = 10) refers to WHERE clause;