CREATE TABLE Tryout (pID NUMBER, cName VARCHAR2, pPos VARCHAR2, decision VARCHAR2)
CREATE TABLE College (cName VARCHAR2, state VARCHAR2, enr NUMBER)
CREATE TABLE Player (pID NUMBER, pName VARCHAR2, yCard VARCHAR2, HS NUMBER)

Find the number of students who participate in the tryout for each college ordered by descending count. Visualize by pie chart.
SELECT cName, COUNT(*) FROM Tryout GROUP BY cName ORDER BY COUNT(*) DESC
SELECT "cName", COUNT(*) FROM "Tryout" GROUP BY "cName" ORDER BY COUNT(*) DESC