SELECT pName, COUNT(pName) FROM Player AS T1 JOIN Tryout AS T2 ON T1.pID = T2.pID GROUP BY pName ORDER BY T1.pName
What are the names of all students who tried out in alphabetical order, and count them by a pie chart
CREATE TABLE Tryout (
    pID numeric(5,0),
    cName varchar(20),
    pPos varchar(8),
    decision varchar(3)
)

CREATE TABLE Player (
    pID numeric(5,0),
    pName varchar(20),
    yCard varchar(3),
    HS numeric(5,0)
)

CREATE TABLE College (
    cName varchar(20),
    state varchar(2),
    enr numeric(5,0)
)