CREATE TABLE station (id VARCHAR2, local_authority VARCHAR2)
CREATE TABLE weekly_weather (station_id VARCHAR2)

Find the id and local authority of the station with has the highest average high temperature.
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
SELECT "t2"."id", "t2"."local_authority" FROM "weekly_weather" "t1" JOIN "station" "t2" ON "t1"."station_id" = "t2"."id" GROUP BY "t1"."station_id" ORDER BY AVG("high_temperature") DESC FETCH FIRST 1 ROWS ONLY