How many wines are there for each grape?
CREATE TABLE grapes (
    id number,
    grape text,
    color text
)

CREATE TABLE wine (
    no number,
    grape text,
    winery text,
    appelation text,
    state text,
    name text,
    year number,
    price number,
    score number,
    cases number,
    drink text
)

CREATE TABLE appellations (
    no number,
    appelation text,
    county text,
    state text,
    area text,
    isava text
)
SELECT COUNT(*), grape FROM wine GROUP BY grape
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: How many wines are there for each grape? ### Input: CREATE TABLE grapes (
    id number,
    grape text,
    color text
)

CREATE TABLE wine (
    no number,
    grape text,
    winery text,
    appelation text,
    state text,
    name text,
    year number,
    price number,
    score number,
    cases number,
    drink text
)

CREATE TABLE appellations (
    no number,
    appelation text,
    county text,
    state text,
    area text,
    isava text
) ### Response: SELECT COUNT(*), grape FROM wine GROUP BY grape