Closed catherine0422 closed 4 years ago
Add movie_id: It's possible that a person directed some movies, and he acted in some movies that directed by other people. So we should add movie_id in order to ensure that we select tuples that a person is the actor of his own movie.
Add distinct.
Add movie_id: It's possible that a person directed some movies, and he acted in some movies that directed by other people. So we should add movie_id in order to ensure that we select tuples that a person is the actor of his own movie.
Add distinct.