Question A has been done

Msci 3200 Database Management (Spring2017) SQL Hackathon Due: 4/17/2017 2:20 PM. Submit on ICON Total points: 50 (first 5 questions) 10 (bonus for the last question) Note: 1) This is a group-based quiz. It is OPEN BOOK, OPEN NOTES 2) Use Oracle Application Express (APEX) for this assignment; 3) Download MoVIELDATABASE.sgl from ICON, upload it onto APEx and run it, 4) You can run each query and copy the output as a screenshot to your submission file individually, or put all once and copy the detail view ofyour script results to your submission your queries in one script fileand run file. No matter which way you use, your final solutions to all problems should be put in ONE single file for submission. The MOVIE DATABASE.sql script will create a movie database with three tables, which implement the M:N relationship between MOVIES and ACTORS. The definitions of these tables are given as follows: CREATE TABLE MOVIES movie id NUMBER (11 NOT NULL title varchar2 (100) NUMBER (4) year rating varchar 2 (6), varchar2 (20), genre revenue FLOAT CONSTRAINT PK2 PRIMARY KEY movie id CREATE TABLE ACTORS actor id NUMBER (11) NOT NULL, varchar2 (50), name total gross FLOAT varchar 2 (100) top movie NUMBER (11), num mov les top movie gross FLOAT actorid CONSTRAINT PKl PRIMARY KEY CREATE TABLE MOVIE TO ACTOR actor id NUMBER (11 NOT NULL movie id NUMBER (11) NOT NULL, actorid, movi eid CONSTRAINT PK3 PRIMARY KEY REFERENCES MOVIES (movieid CONSTRAINT FK1 FOREIGN KEY mova, el CONSTRAINT FK2 FOREIGN KEY actorid REFERENCES ACTORS (actorid Some Notes: 1) In this dataset, "ACTORS" include both male and female personnel. In the following questions, we simply use "actors" to refer to all the actors and actresses in the dataset; 2) "num movies" is the total number of movies an actor starred in 3) "total gross" represents the total revenue of all movies an actor starred in; 4) "top movie" s the title of the movie that achieved the largest revenue among all the movies that an actor starred in; 5) "top movie gross" represents the revenue of the top movie an actor starred in