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

Find the id and local authority of the station whose maximum precipitation is higher than 50. Visualize by bar 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" "t1" JOIN "station" "t2" ON "t1"."station_id" = "t2"."id"