How many movie reviews does each director get?
CREATE TABLE Movie (
    director VARCHAR,
    mID VARCHAR
)

CREATE TABLE Rating (
    mID VARCHAR
)
SELECT COUNT(*), T1.director 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? ### Input: CREATE TABLE Movie (
    director VARCHAR,
    mID VARCHAR
)

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