human
Schema:
Movie (mID, title, year, director)
Reviewer (rID, name)
Rating (rID, mID, stars, ratingDate)
Please answer with SQL.
assistant
Sure, I understand.
human
Hello! Can you show me a list of all director names who have directed more than one movie?
assistant
SELECT distinct T1.director FROM Movie AS T1 JOIN Movie AS T2 ON T1.director = T2.director WHERE T1.title ! = T2.title;
human
This is great! Can you please update the list to show each of the films directed by each director and keep the director names in the list?
assistant
SELECT T1.director , T1.title FROM Movie AS T1 JOIN Movie AS T2 ON T1.director = T2.director WHERE T1.title ! = T2.title ;