SELECT count(*) ,  Grape FROM WINE GROUP BY Grape
How many wines are there for each grape?
SELECT count ( * ) , Grape FROM WINE GROUP BY Grape
select count ( * ) , grape from wine group by grape
How many wines are there for each grape ?