Programmin Task 1

The given SQL creates a Movie table with an auto-incrementing ID column. Write a single

INSERT statement immediately after the CREATE TABLE statement that inserts the following

movies:

Title

Raiders of the Lost Ark

The Godfather

The Pursuit of Happyness

);

CREATE TABLE Movie (

Rating

PG

ID INT AUTO_INCREMENT,

R

PG-

13

Note that dates above need to be converted into 'YYYY-MM-DD' format (with single quotes) in

the INSERT statement.

Release Date

Run your solution and verify the movies in the result table have the auto-assigned IDs 1, 2, and

3. (6 points)

-- Write your INSERT statement here:

SELECT *

FROM Movie;

June 15, 1981

March 24, 1972

December 15, 2006

Title VARCHAR (100),

Rating CHAR (5) CHECK (Rating IN ('G', 'PG', 'PG-13', 'R')),

Release Date DATE,

PRIMARY KEY (ID)