SELECT count(*) ,  hand FROM players GROUP BY hand
Find the number of players for each hand type.
SELECT count ( * ) , hand FROM players GROUP BY hand
select count ( * ) , hand from players group by hand
Find the number of players for each hand type .