CREATE TABLE injury_accident (game_id NUMBER, id NUMBER, Player CLOB, Injury CLOB, Number_of_matches CLOB, Source CLOB)
CREATE TABLE stadium (id NUMBER, name CLOB, Home_Games NUMBER, Average_Attendance FLOAT, Total_Attendance FLOAT, Capacity_Percentage FLOAT)
CREATE TABLE game (stadium_id NUMBER, id NUMBER, Season NUMBER, Date CLOB, Home_team CLOB, Away_team CLOB, Score CLOB, Competition CLOB)

I want to see trend of the number of season by season, and order in descending by the X.
SELECT Season, COUNT(Season) FROM game GROUP BY Season ORDER BY Season DESC
SELECT "Season", COUNT("Season") FROM "game" GROUP BY "Season" ORDER BY "Season" DESC