Who are all the directors?
select distinct director from movie
What about the lowest rating their movies have ever received?
select t2.director, min(t1.stars) from rating as t1 join movie as t2 on t1.mid = t2.mid group by director
Also give me those movies' title.
select t2.title, t1.stars, t2.director, min(t1.stars) from rating as t1 join movie as t2 on t1.mid = t2.mid group by t2.director