CREATE TABLE station (station_id NUMBER, name CLOB, annual_entry_exit NUMBER, annual_interchanges NUMBER, total_passengers NUMBER, location CLOB, main_services CLOB, number_of_platforms NUMBER)
CREATE TABLE train (train_id NUMBER, name CLOB, time CLOB, service CLOB)
CREATE TABLE train_station (train_id NUMBER, station_id NUMBER)

Show the station name and number of trains in each station.
SELECT T2.name, COUNT(*) FROM train_station AS T1 JOIN station AS T2 ON T1.station_id = T2.station_id GROUP BY T1.station_id
SELECT "T2"."name", COUNT(*) FROM "train_station" "T1" JOIN "station" "T2" ON "T1"."station_id" = "T2"."station_id" GROUP BY "T1"."station_id"