Using the Assignment 1 database, populate the database with sufficient data to test your queries. Develop and document the SQL queries necessary to satisfy the following queries. Only show in the output the details required by the specifics of the query. No unnecessary or debug columns. 1) List details for the movies where the actor named "Nicole Kidman" has had a role. 2) List the actor number for each actor and actress and the total amount of movie fees they have received for all their roles combined. Only show actors and actresses where the total fees are in excess of $1,000,000 3) List the details for the actors and actresses that have had roles in movies of a Comedy type that were made in either 2015 or 2016. Only show each actor's details once 4) List the details for each director that directed any movie in 2018. Show each the details for each director only once. Sequence the output by director name. 5) List the actor number for the actors that have had at least 2 roles in 2017 6) List the details for all directors that were born before the year 1970. Sequence the output by oldest to youngest. 7) List the year the oldest comedy movie was made. 8) List the total number of different movies types where "Nicole Kidman" has had a role Using the Assignment 1 database, populate the database with sufficient data to test your queries. Develop and document the SQL queries necessary to satisfy the following queries. Only show in the output the details required by the specifics of the query. No unnecessary or debug columns. 1) List details for the movies where the actor named "Nicole Kidman" has had a role. 2) List the actor number for each actor and actress and the total amount of movie fees they have received for all their roles combined. Only show actors and actresses where the total fees are in excess of $1,000,000 3) List the details for the actors and actresses that have had roles in movies of a Comedy type that were made in either 2015 or 2016. Only show each actor's details once 4) List the details for each director that directed any movie in 2018. Show each the details for each director only once. Sequence the output by director name. 5) List the actor number for the actors that have had at least 2 roles in 2017 6) List the details for all directors that were born before the year 1970. Sequence the output by oldest to youngest. 7) List the year the oldest comedy movie was made. 8) List the total number of different movies types where "Nicole Kidman" has had a role