CREATE TABLE SportsInfo (StuID NUMBER, SportName VARCHAR2, HoursPerWeek NUMBER, GamesPlayed NUMBER, OnScholarship 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 Video_Games (GameID NUMBER, GName VARCHAR2, GType VARCHAR2)

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