How many wines are there for each grape?
SELECT count(*) ,  Grape FROM WINE GROUP BY Grape
SELECT count(*) ,  Grape FROM WINE GROUP BY Grape
[{'count(*)': 1, 'Grape': 'Barbera'}, {'count(*)': 1, 'Grape': 'Cabernet Franc'}, {'count(*)': 68, 'Grape': 'Cabernet Sauvingnon'}, {'count(*)': 104, 'Grape': 'Chardonnay'}, {'count(*)': 10, 'Grape': 'Grenache'}, {'count(*)': 1, 'Grape': 'Malbec'}, {'count(*)': 1, 'Grape': 'Marsanne'}, {'count(*)': 10, 'Grape': 'Merlot'}, {'count(*)': 6, 'Grape': 'Petite Sirah'}, {'count(*)': 109, 'Grape': 'Pinot Noir'}, {'count(*)': 1, 'Grape': 'Roussanne'}, {'count(*)': 1, 'Grape': 'Sangiovese'}, {'count(*)': 46, 'Grape': 'Sauvignon Blanc'}, {'count(*)': 61, 'Grape': 'Syrah'}, {'count(*)': 1, 'Grape': 'Tempranillo'}, {'count(*)': 1, 'Grape': 'Viognier'}, {'count(*)': 78, 'Grape': 'Zinfandel'}]