CREATE TABLE Plays_Games (StuID NUMBER, GameID NUMBER, Hours_Played NUMBER)
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 Video_Games (GameID NUMBER, GName VARCHAR2, GType VARCHAR2)

Visualize a bar chart for how many students play each sport?
SELECT SportName, COUNT(*) FROM SportsInfo GROUP BY SportName
SELECT "SportName", COUNT(*) FROM "SportsInfo" GROUP BY "SportName"