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

Find times of trains that run through stations for the local authority Chiltern, compare the total number of different times, I want to rank by the X from high to low.
SELECT time, COUNT(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" GROUP BY time ORDER BY time DESC
SELECT "time", COUNT("time") FROM "station" "t1" JOIN "route" "t2" ON "t1"."id" = "t2"."station_id" JOIN "train" "t3" ON "t2"."train_id" = "t3"."id" WHERE "Chiltern" = "t1"."local_authority" GROUP BY "time" ORDER BY "time" DESC