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';
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
