What are all the directors?
select distinct director from movie
How many movie reviews does each of them get?
select count(*), t1.director from movie as t1 join rating as t2 on t1.mid = t2.mid group by t1.director