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

A pie chart for finding the number of the name of all students who were in the tryout sorted in alphabetic order.
SELECT pName, COUNT(pName) FROM Player AS T1 JOIN Tryout AS T2 ON T1.pID = T2.pID GROUP BY pName ORDER BY T1.pName
SELECT "pName", COUNT("pName") FROM "Player" "T1" JOIN "Tryout" "T2" ON "T1"."pID" = "T2"."pID" GROUP BY "pName" ORDER BY "T1"."pName"