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

Find the id and local authority of the station whose maximum precipitation is higher than 50. Plot them as pie chart.
SELECT local_authority, id FROM weekly_weather AS t1 JOIN station AS t2 ON t1.station_id = t2.id
SELECT "local_authority", "id" FROM "weekly_weather" AS "t1" JOIN "station" AS "t2" ON "t1"."station_id" = "t2"."id"