2019-11-19

Nov 20 In-Class Exercise Thread.

Post your solutions to the Nov 20 In-Class Exercise to this thread.
Best,
Chris
Post your solutions to the Nov 20 In-Class Exercise to this thread. Best, Chris
2019-11-20

-- 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;
(Edited: 2019-11-20)
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 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
 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, 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(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 title, year, MovieStar.name FROM Movies, StarsIn, MovieStar WHERE StarsIn.movie = Movies.title AND StarsIn.year = Movies.year AND StarsIn.starName = MovieStar.name

-- Nov 20 In-Class Exercise Thread
 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 movieTitle, movieYear, starName FROM StarsIn WHERE true;

-- Nov 20 In-Class Exercise Thread
 CREATE VIEW StarMovies(title, year, movieStarName) AS (SELECT * FROM StarsIn);
(Edited: 2019-11-20)
CREATE VIEW StarMovies(title, year, movieStarName) AS (SELECT * FROM StarsIn);

-- Nov 20 In-Class Exercise Thread
 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, movieStarName FROM (Movies NATURAL JOIN StarsIn)

-- Nov 20 In-Class Exercise Thread
 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, starName FROM Movies, StarsIn WHERE title = Movies.title AND year = Movies.year;

-- Nov 20 In-Class Exercise Thread
 CREATE VIEW StarMovies(title, year, movieStarName) AS 
 SELECT title, year, name 
 FROM Movies, StarsIn
 WHERE title=movieTitle AND name=starName
(Edited: 2019-11-20)
CREATE VIEW StarMovies(title, year, movieStarName) AS SELECT title, year, name FROM Movies, StarsIn WHERE title=movieTitle AND name=starName
[ Next ]
X