How many movie reviews does each director get. Visualize by pie chart.
CREATE TABLE Reviewer (
    rID int,
    name text
)

CREATE TABLE Rating (
    rID int,
    mID int,
    stars int,
    ratingDate date
)

CREATE TABLE Movie (
    mID int,
    title text,
    year int,
    director text
)
SELECT director, COUNT(*) FROM Movie AS T1 JOIN Rating AS T2 ON T1.mID = T2.mID GROUP BY T1.director
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 movie reviews does each director get. Visualize by pie chart. ### Input: CREATE TABLE Reviewer (
    rID int,
    name text
)

CREATE TABLE Rating (
    rID int,
    mID int,
    stars int,
    ratingDate date
)

CREATE TABLE Movie (
    mID int,
    title text,
    year int,
    director text
) ### Response: SELECT director, COUNT(*) FROM Movie AS T1 JOIN Rating AS T2 ON T1.mID = T2.mID GROUP BY T1.director