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

Show all sport name and the number of students Show bar chart, and list in desc by the Y.
SELECT SportName, COUNT(*) FROM SportsInfo GROUP BY SportName ORDER BY COUNT(*) DESC
SELECT "SportName", COUNT(*) FROM "SportsInfo" GROUP BY "SportName" ORDER BY COUNT(*) DESC