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 route (train_id INT, station_id INT)
CREATE TABLE station (id INT, network_name TEXT, services TEXT, local_authority TEXT)
CREATE TABLE train (id INT, train_number INT, name TEXT, origin TEXT, destination TEXT, time TEXT, interval TEXT)

Plot how many name by grouped by name as a bar graph, I want to order by the X in descending please.
SELECT name, COUNT(name) FROM train GROUP BY name ORDER BY name DESC
SELECT "name", COUNT("name") FROM "train" GROUP BY "name" ORDER BY "name" DESC NULLS LAST