SELECT T1.director ,  T1.title FROM Movie AS T1 JOIN Rating AS T2 ON T1.mID  =  T2.mID WHERE T2.stars  =  5
What are the names of directors who directed movies with 5 star rating? Also return the title of these movies.
-- dbext:type=SQLITE:dbname=movie_rating.db

/* Delete the tables if they already exist */
drop table if exists Movie;
drop table if exists Reviewer;
drop table if exists Rating;

/* Create the schema for our tables */
create table Movie(
	mID int primary key, 
	title text, 
	year int, 
	director text
);
create table Reviewer(
	rID int primary key, 
	name text);

create table Rating(
	rID int, 
	mID int, 
	stars int, 
	ratingDate date,
	FOREIGN KEY (mID) references Movie(mID),
	FOREIGN KEY (rID) references Reviewer(rID)
);

/* Populate the tables with our data */


insert into Movie values(101, 'Gone with the Wind', 1939, 'Victor Fleming');
insert into Reviewer values(201, 'Sarah Martinez');
insert into Rating values(201, 101, 2, '2011-01-22');
INSERT INTO Movie VALUES [(101, 'Gone with the Wind', 1939, 'Victor Fleming'), (102, 'Star Wars', 1977, 'George Lucas')]
INSERT INTO Reviewer VALUES [(201, 'Sarah Martinez'), (202, 'Daniel Lewis')]
INSERT INTO Rating VALUES [(201, 101, 2, '2011-01-22'), (201, 101, 4, '2011-01-27')]
