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

Stack bar chart of how many home team vs Away_team based on home team, and list by the Y in descending.
SELECT Home_team, COUNT(Home_team) FROM game GROUP BY Away_team, Home_team ORDER BY COUNT(Home_team) DESC
SELECT "Home_team", COUNT("Home_team") FROM "game" GROUP BY "Away_team", "Home_team" ORDER BY COUNT("Home_team") DESC NULLS LAST