The station name.
select t2.network_name 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
What is Charleywood's ID?
select id from station where network_name = "Chorleywood"
What is the local authority of Chorleywood, ID 10?
select local_authority from station where network_name = "Chorleywood"