Hi, can you please tell me what is the ID of the station whose maximum precipitation is higher than 50?
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 )   >  50
ID of the station refers to station.id; maximum precipitation higher than 50 refers to HAVING MAX(precipitation) > 50;