CREATE TABLE reviewer (rid NUMBER, name CLOB)
CREATE TABLE movie (mid NUMBER, title CLOB, year NUMBER, director CLOB)
CREATE TABLE rating (rid NUMBER, mid NUMBER, stars NUMBER, ratingdate TIME)

What are the names of the directors who created a movie with a 5 star rating, and what was the name of those movies?
SELECT T1.director, T1.title FROM movie AS T1 JOIN rating AS T2 ON T1.mid = T2.mid WHERE T2.stars = 5
SELECT "T1"."director", "T1"."title" FROM "movie" "T1" JOIN "rating" "T2" ON "T1"."mid" = "T2"."mid" AND "T2"."stars" = 5