What are the names of the directors who created a movie with a 5 star rating, and what was the name of those movies?
CREATE TABLE reviewer (
    rid number,
    name text
)

CREATE TABLE movie (
    mid number,
    title text,
    year number,
    director text
)

CREATE TABLE rating (
    rid number,
    mid number,
    stars number,
    ratingdate time
)
SELECT T1.director, T1.title FROM movie AS T1 JOIN rating AS T2 ON T1.mid = T2.mid WHERE T2.stars = 5
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What are the names of the directors who created a movie with a 5 star rating, and what was the name of those movies? ### Input: CREATE TABLE reviewer (
    rid number,
    name text
)

CREATE TABLE movie (
    mid number,
    title text,
    year number,
    director text
)

CREATE TABLE rating (
    rid number,
    mid number,
    stars number,
    ratingdate time
) ### Response: SELECT T1.director, T1.title FROM movie AS T1 JOIN rating AS T2 ON T1.mid = T2.mid WHERE T2.stars = 5