CREATE TABLE reviewer (rid NUMBER, name CLOB)
CREATE TABLE rating (rid NUMBER, mid NUMBER, stars NUMBER, ratingdate TIME)
CREATE TABLE movie (mid NUMBER, title CLOB, year NUMBER, director CLOB)

How many movie reviews does each director get?
SELECT COUNT(*), T1.director FROM movie AS T1 JOIN rating AS T2 ON T1.mid = T2.mid GROUP BY T1.director
SELECT COUNT(*), "T1"."director" FROM "movie" "T1" JOIN "rating" "T2" ON "T1"."mid" = "T2"."mid" GROUP BY "T1"."director"