For each director who directed more than one movie, what are the titles and dates of release for all those movies?
CREATE TABLE reviewer (
    rid number,
    name text
)

CREATE TABLE rating (
    rid number,
    mid number,
    stars number,
    ratingdate time
)

CREATE TABLE movie (
    mid number,
    title text,
    year number,
    director text
)
SELECT T1.title, T1.year FROM movie AS T1 JOIN movie AS T2 ON T1.director = T2.director WHERE T1.title <> T2.title
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: For each director who directed more than one movie, what are the titles and dates of release for all those movies? ### Input: CREATE TABLE reviewer (
    rid number,
    name text
)

CREATE TABLE rating (
    rid number,
    mid number,
    stars number,
    ratingdate time
)

CREATE TABLE movie (
    mid number,
    title text,
    year number,
    director text
) ### Response: SELECT T1.title, T1.year FROM movie AS T1 JOIN movie AS T2 ON T1.director = T2.director WHERE T1.title <> T2.title