1SELECT user.name, movie.name
2FROM user, movie, list
3WHERE list.user_id = user.id
4 AND list.movie_id = movie.id
5ORDER BY 1,2;
1SELECT user.name, movie.name
2FROM user
3JOIN list ON list.user_id = user.id
4JOIN movie ON list.movie_id = movie.id
5ORDER BY 1,2;