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

Stacked bar of services and how many services colored by local_authority, could you order from high to low by the bar please?
SELECT services, COUNT(services) FROM station GROUP BY local_authority, services ORDER BY services DESC
SELECT "services", COUNT("services") FROM "station" GROUP BY "local_authority", "services" ORDER BY "services" DESC