subject

The given SQL creates a Movie table and inserts some movies. The SELECT statement selects all movies released before January 1, 2000 Modify the SELECT statement to select the title and release date of PG-13 movies that are released after February 1, 2008. Run your solution and verify the result table shows just the titles and release dates for The Dark Knight and Crazy Rich Asians. 3 6 1 CREATE TABLE Movie ( 2 ID INT AUTO_INCREMENT, Title VARCHAR(100), 4 Rating CHAR(5) CHECK (Rating IN ('G', 'PG', 'PG-13', 'R')), 5 ReleaseDate DATE, PRIMARY KEY (ID) 7); 8 9 INSERT INTO Movie (Title, Rating, ReleaseDate) VALUES 19 ('Casablanca', 'PG', '1943-01-23'), 11 ("Bridget Jones's Diary', 'PG-13', '2001-04-13'), 12 ('The Dark Knight', 'PG-13', '2008-07-18'), 13 ("Hidden Figures', 'PG', '2017-01-06'), 14 ('Toy Story', 'G', '1995-11-22'), 15 ("Rocky', 'PG', '1976-11-21'), 16 ('Crazy Rich Asians', 'PG-13', '2018-08-15'); 17 18 -- Modify the SELECT statement: 19 SELECT * 20 FROM Movie 21 WHERE ReleaseDate < '2000-01-01'; 22

ansver
Answers: 1

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 07:30
An endless cycle of creation and response on the internet is called
Answers: 1
question
Computers and Technology, 23.06.2019 06:20
What is a point-in-time measurement of system performance?
Answers: 3
question
Computers and Technology, 24.06.2019 00:40
Use a software program or a graphing utility with matrix capabilities to solve the system of linear equations using an inverse matrix. x1 + 2x2 βˆ’ x3 + 3x4 βˆ’ x5 = 6 x1 βˆ’ 3x2 + x3 + 2x4 βˆ’ x5 = βˆ’6 2x1 + x2 + x3 βˆ’ 3x4 + x5 = 3 x1 βˆ’ x2 + 2x3 + x4 βˆ’ x5 = βˆ’3 2x1 + x2 βˆ’ x3 + 2x4 + x5 = 5
Answers: 3
question
Computers and Technology, 24.06.2019 08:00
Java the manager of a football stadium wants you to write a program that calculates the total ticket sales after each game
Answers: 1
You know the right answer?
The given SQL creates a Movie table and inserts some movies. The SELECT statement selects all movies...
Questions
question
Physics, 27.09.2019 12:20
question
Computers and Technology, 27.09.2019 12:20
question
Business, 27.09.2019 12:20
question
Mathematics, 27.09.2019 12:20
question
Mathematics, 27.09.2019 12:20
question
Chemistry, 27.09.2019 12:20
Questions on the website: 13722359