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

How many trains have 'Express' in their names?
SELECT COUNT(*) FROM train WHERE name LIKE "%Express%"
SELECT COUNT(*) FROM "train" WHERE "name" LIKE "%Express%"