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