What is the number of players whose last name is Green that played in the league but not coached?
played in the league but not coached means playerID is not NULL and coachID is NULL;
SELECT COUNT(playerID) FROM Master WHERE lastName = 'Green' AND coachID IS NULL