CREATE TABLE record (ID INT, Result TEXT, Swimmer_ID INT, Event_ID INT)
CREATE TABLE stadium (ID INT, name TEXT, Capacity INT, City TEXT, Country TEXT, Opening_year INT)
CREATE TABLE event (ID INT, Name TEXT, Stadium_ID INT, Year TEXT)
CREATE TABLE swimmer (ID INT, name TEXT, Nationality TEXT, meter_100 FLOAT, meter_200 TEXT, meter_300 TEXT, meter_400 TEXT, meter_500 TEXT, meter_600 TEXT, meter_700 TEXT, Time TEXT)

Show me a bar chart for how many stadiums does each country have?, list in descending by the the total number .
SELECT Country, COUNT(*) FROM stadium GROUP BY Country ORDER BY COUNT(*) DESC
SELECT "Country", COUNT(*) FROM "stadium" GROUP BY "Country" ORDER BY COUNT(*) DESC NULLS LAST