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

Compute the number of local authorities by local authorities and then split by services. Show the result with a stacked bar graph.
SELECT services, COUNT(services) FROM station GROUP BY local_authority, services
SELECT "services", COUNT("services") FROM "station" GROUP BY "local_authority", "services"