What's the high temperature of each station?
select t1.high_temperature from weekly_weather as t1 join station as t2 on t1.station_id = t2.id;
What's the id of the station with highest average high temperature?
select t2.id from weekly_weather as t1 join station as t2 on t1.station_id = t2.id group by t1.station_id order by avg(high_temperature) desc limit 1
Also show me the local authority of this station.
select t2.id, t2.local_authority from weekly_weather as t1 join station as t2 on t1.station_id = t2.id group by t1.station_id order by avg(high_temperature) desc limit 1