The given SQL creates a Movie table and inserts some movies. The SELECT statement selects all movies. Press the Run button to produce a result table. Verify the result table displays five movies. Modify the SELECT statement to only select movies released after October 31, 2015: SELECT*FROM Movie WHERE ReleaseDate >'2015-10-31'; Then run the SQL again and verify the new query returns only three movies, all with release dates after October 31, 2015. CREATE TABLE Movie ( ID INT, Title VARCHAR(100), Rating VARCHAR(5), ReleaseDate DATE ); INSERT INTO Movie VALUES (1, 'Rogue One: A Star Wars Story', 'PG-13', '2016-12-10'), (2, 'Hidden Figures', 'PG', '2017-01-06'), (3, 'Toy Story', 'G', '1995-11-22'), (4, 'Avengers: Endgame', 'PG-13', '2019-04-26'), (5, 'The Godfather', 'R', '1972-03-14'); -- Modify the SELECT statement: SELECT * FROM Movie; Where ReleaseDate > '2015-10-31';
The given SQL creates a Movie table and inserts some movies. The SELECT statement selects all movies.
Press the Run button to produce a result table. Verify the result table displays five movies.
Modify the SELECT statement to only select movies released after October 31, 2015:
Then run the SQL again and verify the new query returns only three movies, all with release dates after October 31, 2015.
CREATE TABLE Movie (
ID INT,
Title VARCHAR(100),
Rating VARCHAR(5),
ReleaseDate DATE
);
INSERT INTO Movie VALUES
(1, 'Rogue One: A Star Wars Story', 'PG-13', '2016-12-10'),
(2, 'Hidden Figures', 'PG', '2017-01-06'),
(3, 'Toy Story', 'G', '1995-11-22'),
(4, 'Avengers: Endgame', 'PG-13', '2019-04-26'),
(5, 'The Godfather', 'R', '1972-03-14');
-- Modify the SELECT statement:
SELECT *
FROM Movie;
Where ReleaseDate > '2015-10-31';
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781285196145/9781285196145_smallCoverImage.gif)
![Programming with Microsoft Visual Basic 2017](https://www.bartleby.com/isbn_cover_images/9781337102124/9781337102124_smallCoverImage.gif)