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)

How many movie reviews does each director get. Visualize by pie chart.
SELECT director, COUNT(*) FROM Movie AS T1 JOIN Rating AS T2 ON T1.mID = T2.mID GROUP BY T1.director
SELECT "director", COUNT(*) FROM "Movie" AS "T1" JOIN "Rating" AS "T2" ON "T1"."mID" = "T2"."mID" GROUP BY "T1"."director"