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)
CREATE TABLE station (id INT, network_name TEXT, services TEXT, local_authority TEXT)

A bar graph listing the local authorities and how many local authorities provided by all stations, could you display X from high to low order?
SELECT local_authority, COUNT(local_authority) FROM station GROUP BY local_authority ORDER BY local_authority DESC
SELECT "local_authority", COUNT("local_authority") FROM "station" GROUP BY "local_authority" ORDER BY "local_authority" DESC NULLS LAST