CREATE TABLE train (train_id NUMBER, name CLOB, time CLOB, service CLOB)
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_station (train_id NUMBER, station_id NUMBER)

Show the names and total passengers for all train stations not in London.
SELECT name, total_passengers FROM station WHERE location <> 'London'
SELECT "name", "total_passengers" FROM "station" WHERE "location" <> 'London'