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)
CREATE TABLE route (train_id DECIMAL, station_id DECIMAL)

Find names and times of trains that run through stations for the local authority Chiltern.
SELECT t3.name, t3.time FROM station AS t1 JOIN route AS t2 ON t1.id = t2.station_id JOIN train AS t3 ON t2.train_id = t3.id WHERE t1.local_authority = "Chiltern"
SELECT "t3"."name", "t3"."time" FROM "station" AS "t1" JOIN "route" AS "t2" ON "t1"."id" = "t2"."station_id" JOIN "train" AS "t3" ON "t2"."train_id" = "t3"."id" WHERE "Chiltern" = "t1"."local_authority"