that was quick, thank you again. then could you please let me know if there is any station which has less than 10 maximum precipitation?
SELECT t2.id FROM weekly_weather AS t1 JOIN station AS t2 ON t1.station_id   =   t2.id GROUP BY t1.station_id HAVING max ( t1.precipitation )   <  10
station with less than 10 maximum precipitation refers to HAVING MAX(t1.precipitation) < 10;