CREATE TABLE route (train_id DECIMAL, station_id DECIMAL)
CREATE TABLE station (id DECIMAL, network_name TEXT, services TEXT, local_authority TEXT)
CREATE TABLE weekly_weather (station_id DECIMAL, day_of_week TEXT, high_temperature DECIMAL, low_temperature DECIMAL, precipitation DECIMAL, wind_speed_mph DECIMAL)
CREATE TABLE train (id DECIMAL, train_number DECIMAL, name TEXT, origin TEXT, destination TEXT, time TEXT, interval TEXT)

Find the id and local authority of the station whose maximum precipitation is higher than 50.
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 HAVING MAX(t1.precipitation) > 50
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" HAVING MAX("t1"."precipitation") > 50