-- Database schema
| Movie : mID [ INT ] primary_key , title [ TEXT ] , year [ INT ] , director [ TEXT ] | Reviewer : rID [ INT ] primary_key , name [ TEXT ] | Rating : rID [ INT ] Rating.rID = Reviewer.rID , mID [ INT ] Rating.mID = Movie.mID , stars [ INT ] , ratingDate [ TEXT ] |
-- -- For each director, how many reviews have they received?

SELECT count(*) ,  T1.director FROM Movie AS T1 JOIN Rating AS T2 ON T1.mID  =  T2.mID GROUP BY T1.director;