human
Schema:
book_club (book_club_id, Year, Author_or_Editor, Book_Title, Publisher, Category, Result)
movie (movie_id, Title, Year, Director, Budget_million, Gross_worldwide)
culture_company (Company_name, Type, Incorporated_in, Group_Equity_Shareholding, book_club_id, movie_id)
Please answer with SQL.
assistant
Sure, I understand.
human
Show all director names.
assistant
SELECT director FROM movie;
human
Among them, who has a movie in 1999?
assistant
SELECT director FROM movie WHERE YEAR = 1999;
human
Also show those who have a movie in 2000.
assistant
SELECT director FROM movie WHERE YEAR = 1999 OR YEAR = 2000 ;