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
for each director refers to GROUP BY director; how many reviews refers to COUNT(*); received refers to linking director with the counts of reviews through JOIN operation between Movie and Rating tables based on movie ID.