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

How many students play each sport Show bar chart, and sort bar in ascending order.
SELECT SportName, COUNT(*) FROM SportsInfo GROUP BY SportName ORDER BY SportName
SELECT "SportName", COUNT(*) FROM "SportsInfo" GROUP BY "SportName" ORDER BY "SportName" NULLS FIRST