CREATE TABLE Video_Games (GameID NUMBER, GName VARCHAR2, GType VARCHAR2)
CREATE TABLE Student (StuID NUMBER, LName VARCHAR2, Fname VARCHAR2, Age NUMBER, Sex VARCHAR2, Major NUMBER, Advisor NUMBER, city_code VARCHAR2)
CREATE TABLE Plays_Games (StuID NUMBER, GameID NUMBER, Hours_Played NUMBER)
CREATE TABLE SportsInfo (StuID NUMBER, SportName VARCHAR2, HoursPerWeek NUMBER, GamesPlayed NUMBER, OnScholarship VARCHAR2)

Show all sport name and the number of students in a bar chart, and sort bars in descending order.
SELECT SportName, COUNT(*) FROM SportsInfo GROUP BY SportName ORDER BY SportName DESC
SELECT "SportName", COUNT(*) FROM "SportsInfo" GROUP BY "SportName" ORDER BY "SportName" DESC