CREATE TABLE Sportsinfo (sportname VARCHAR2)

Show all sport name and the number of students.
SELECT sportname, COUNT(*) FROM Sportsinfo GROUP BY sportname
SELECT "sportname", COUNT(*) FROM "Sportsinfo" GROUP BY "sportname"