CREATE VIEW StarMovies(movieTitle, movieYear, movieStarName) AS SELECT title, year, movieStarName FROM Movies, StarsIn WHERE movieTitle = title AND movieYear = year;(Edited: 2019-11-20)
CREATE VIEW StarMovies(title, year, movieStarName) AS SELECT title, year, starName FROM Movies, StarsIn WHERE title=movieTitle AND year=movieYear;(Edited: 2019-11-20)
CREATE VIEW StarMovies(title, year, starName) AS SELECT title, year, starName FROM StarsIn WHERE StarsIn.title=title AND StarsIn.year = year;(Edited: 2019-11-20)
CREATE VIEW StarMovies(title, year, movieStarName) AS SELECT title, year, MovieStar.name FROM Movies, StarsIn, MovieStar WHERE StarsIn.movie = Movies.title AND StarsIn.year = Movies.year AND StarsIn.starName = MovieStar.name(Edited: 2019-11-20)
CREATE VIEW StarMovies(title, year, movieStarName) AS SELECT movieTitle, movieYear, starName FROM StarsIn WHERE true;(Edited: 2019-11-20)
CREATE VIEW StarMovies(title, year, movieStarName) AS (SELECT * FROM StarsIn);(Edited: 2019-11-20)
CREATE VIEW StarMovies(title, year, movieStarName) AS SELECT title, year, movieStarName FROM (Movies NATURAL JOIN StarsIn)
CREATE VIEW StarMovies(title, year, movieStarName) AS SELECT title, year, starName FROM Movies, StarsIn WHERE title = Movies.title AND year = Movies.year;(Edited: 2019-11-20)
CREATE VIEW StarMovies(title, year, movieStarName) AS SELECT title, year, name FROM Movies, StarsIn WHERE title=movieTitle AND name=starName(Edited: 2019-11-20)