SELECT count(*) ,  hand FROM players GROUP BY hand
How many players are there for each hand type?
SELECT count ( * ) , hand FROM players GROUP BY hand
select count ( * ) , hand from players group by hand
How many players are there for each hand type ?