CREATE TABLE "ACTOR" ( "ID" NUMBER(9,0) NOT NULL,

"NAME" VARCHAR2(100) NOT NULL,

CONSTRAINT ACTOR_PK PRIMARY KEY (ID));

CREATE TABLE "MOVIE" ( "ID" NUMBER(9,0) NOT NULL,

"TITLE" VARCHAR2(100) NOT NULL "YR" NUMBER(4,0), "SCORE" NUMBER(3,1), "VOTES" NUMBER(9,0), "DIRECTOR" VARCHAR2(100),

CONSTRAINT MOVIE_PK PRIMARY KEY (ID));

CREATE TABLE "CASTING" (

"MOVIE_ID" NUMBER(9,0) NOT NULL

"ACTOR_ID" NUMBER(9,0) NOT NULL

"ORD" CONSTRAINT CASTING_PK Primary Key (Movie_ID, ACTOR_ID), CONSTRAINT CASTING_FK1 FOREIGN KEY (MOVIE_ID) REFERENCES MOVIE(ID),

CONSTRAINT CASTING_FK2 FOREIGN KEY (ACTOR_ID) REFERENCES ACTOR(ID)) ;

Youre using PL/SQL:

First manually create a new table (named New_Movie) in APEX. This table should have the same schema as the movie table. You dont need to show the code for creating this table. Then write PL/SQL to do the following: find movies with at least 50,000 votes. Insert all of these movies (all columns) into the New_Movie table. If the number of movies inserted is , you should display on the screen as follows

Inserted movies into the New_Movie table