[ Prev ]
2019-11-20

-- Nov 20 In-Class Exercise Thread
	CREATE VIEW StarMovies(title, year, movieStarName) AS
		SELECT Movies.title, Movies.year, StarsIn.starName
		FROM StarsIn, Movies
		WHERE title=movieTitle AND year=movieYear;
(Edited: 2019-11-20)
CREATE VIEW StarMovies(title, year, movieStarName) AS SELECT Movies.title, Movies.year, StarsIn.starName FROM StarsIn, Movies WHERE title=movieTitle AND year=movieYear;

-- Nov 20 In-Class Exercise Thread
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, movieStarName) AS SELECT title, year, starName FROM Movies, StarsIn WHERE title = movieTitle AND year = movieYear;

-- Nov 20 In-Class Exercise Thread
StarsIn(movieTitle, movieYear, starName)
 CREATE VIEW StarMovies(title, year, movieStarName) AS
   SELECT * FROM StarsIn;
StarsIn(movieTitle, movieYear, starName) CREATE VIEW StarMovies(title, year, movieStarName) AS SELECT * FROM StarsIn;

-- Nov 20 In-Class Exercise Thread
 CREATE VIEW StarMovies(movieTitle, movieYear, movieStarName) AS 
	SELECT title, year, movieStarName 
	FROM Movies, StarsIn
        WHERE movieTitle = title AND movieYear = year;
CREATE VIEW StarMovies(movieTitle, movieYear, movieStarName) AS SELECT title, year, movieStarName FROM Movies, StarsIn WHERE movieTitle = title AND movieYear = year;

-- Nov 20 In-Class Exercise Thread
CREATE VIEW StarMovies(title, year, movieStarName) AS SELECT title, year, starName FROM StarsIn, Movie WHERE StarsIn.title = title AND movie.year = year;
CREATE VIEW StarMovies(title, year, movieStarName) AS SELECT title, year, starName FROM StarsIn, Movie WHERE StarsIn.title = title AND movie.year = year;

-- Nov 20 In-Class Exercise Thread
 CREATE VIEW StarMovie(title, year, movieStarName) AS 
 SELECT title, year, name 
 FROM Movies, StarsIn
 WHERE title=movieTitle AND name=starName
CREATE VIEW StarMovie(title, year, movieStarName) AS SELECT title, year, name FROM Movies, StarsIn WHERE title=movieTitle AND name=starName

-- Nov 20 In-Class Exercise Thread
 CREATE VIEW StarMovies(title, year, starName) AS
              SELECT title, year, starName 
              FROM StarsIn
              WHERE StarsIn.title=title AND StarsIn.year = year;
CREATE VIEW StarMovies(title, year, starName) AS SELECT title, year, starName FROM StarsIn WHERE StarsIn.title=title AND StarsIn.year = year;

-- Nov 20 In-Class Exercise Thread
CREATE VIEW StarMovies(movieTitle, movieYear, movieStarName) AS
SELECT title, year, movieStarName
FROM Movies, StarsIn
WHERE movieTitle = title AND movieYear = year;
CREATE VIEW StarMovies(movieTitle, movieYear, movieStarName) AS SELECT title, year, movieStarName FROM Movies, StarsIn WHERE movieTitle = title AND movieYear = year;

-- Nov 20 In-Class Exercise Thread
CREATE VIEW StarMovies(title, year, movieStarName) AS
		SELECT Movies.title, Movies.year, StarsIn.starName
		FROM StarsIn, Movies
		WHERE title=movieTitle AND year=movieYear;
CREATE VIEW StarMovies(title, year, movieStarName) AS SELECT Movies.title, Movies.year, StarsIn.starName FROM StarsIn, Movies WHERE title=movieTitle AND year=movieYear;
2019-11-22

-- Nov 20 In-Class Exercise Thread
 CREATE VIEW StarMovies(title, year, movieStarName) AS
 SELECT Movies.title, Movies.year, StarsIn.starName
 FROM Movies, StarsIn
 WHERE title = Movies.title AND year = Movies.year;
CREATE VIEW StarMovies(title, year, movieStarName) AS SELECT Movies.title, Movies.year, StarsIn.starName FROM Movies, StarsIn WHERE title = Movies.title AND year = Movies.year;
[ Next ]
X