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

Return a pie chart on how many students participated in tryouts for each college by descennding count?
SELECT cName, COUNT(*) FROM Tryout GROUP BY cName ORDER BY COUNT(*) DESC
SELECT "cName", COUNT(*) FROM "Tryout" GROUP BY "cName" ORDER BY COUNT(*) DESC NULLS LAST