DATABASE APPLICATIONS COURSE:

The given SQL creates a Movie table and inserts some movies. The SELECT statement selects all movies. Modify the SELECT statement to select movies with the word 'star' somewhere in the title. Run your solution and verify the result table shows just the movies Rogue One: A Star Wars Story, Star Trek and Stargate. 1 CREATE TABLE Movie ( 2 ID INT AUTO_INCREMENT, 3 Title VARCHAR(100), 4 Rating CHAR(5) CHECK (Rating IN ('G', 'PG', 'PG-13', 'R')), 5 ReleaseDate DATE, 6 PRIMARY KEY (ID) 7; 8 9 INSERT INTO Movie (Title, Rating, ReleaseDate) VALUES 10 ('Rogue One: A Star Wars Story', 'PG-13', '2016-12-16'), 11 ('Star Trek', 'PG-13', '2009-05-08'), 12 ('The Dark Knight', 'PG-13', '2008-07-18'), 13 ('Stargate', 'PG-13', '1994-10-28'), 14 ('Avengers: Endgame', 'PG-13', '2019-04-26'); 15 16 -- Modify the SELECT statement: 17 SELECT * 18 FROM Movie; 19 Run Reset code