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

Give me the maximum low temperature and average precipitation at the Amersham station.
SELECT MAX(t1.low_temperature), AVG(t1.precipitation) FROM weekly_weather AS t1 JOIN station AS t2 ON t1.station_id = t2.id WHERE t2.network_name = "Amersham"
SELECT MAX("t1"."low_temperature"), AVG("t1"."precipitation") FROM "weekly_weather" "t1" JOIN "station" "t2" ON "Amersham" = "t2"."network_name" AND "t1"."station_id" = "t2"."id"