Develop and document the SQL queries necessary to satisfy the following. Only show in the output the details required by the specifics of the query. No unnecessary or debug columns.

15. List the details for an actor who has had a role in a Comedy movie that has received more than 5 nominations or 2 awards. Only show cach actor's details once and sequence by actor -16. List the details for those movies whose title contains within it cither pirate' or twilight -17. Show the number of roles in 2010 for each actor whose total fees in that year exceeded S1,000,000 -18. List the details for the directors that have directed in any movie where Harrison Ford had a role. Show each director only once. -19. Count the number of living actors that where born in London -20(). Write a command to add a new movie to the database - 20(ii). Write a command to double that new movie's number of nominations. (Use a numeric expression. Don't calculate manually and hard code the valuc) - 20ii).Write a command to delete the new movie actor role actnumb: INTEGER NOT NULL mvnumb: INTEGER NOT NULL (FK) actnumb: INTEGER NOT NULL(FK) actname: CHAR(20) NOT NULL birthplace: CHAR(20) NOT NULL yearbom: INTEGER NOT NULL yeardied: INTEGER NULL mvfee: INTEGER NOT NULL ea movie mvnumb: INTEGER NOT NULL director mvite: CHAR(30) NOT NULL yearmade: INTEGER NOT NULL mvtype: CHAR(10) NOT NULU noms: INTEGER NOT NULL awrds: INTEGER NOT NULL dimumb: INTEGER NOT NULL (FK) dirnumb: INTEGER NOT NULL dirname: CHAR(20) NOT NULL yearbom: INTEGER NOT NULL yeardied: INTEGER NULL ie 15. List the details for an actor who has had a role in a Comedy movie that has received more than 5 nominations or 2 awards. Only show cach actor's details once and sequence by actor -16. List the details for those movies whose title contains within it cither pirate' or twilight -17. Show the number of roles in 2010 for each actor whose total fees in that year exceeded S1,000,000 -18. List the details for the directors that have directed in any movie where Harrison Ford had a role. Show each director only once. -19. Count the number of living actors that where born in London -20(). Write a command to add a new movie to the database - 20(ii). Write a command to double that new movie's number of nominations. (Use a numeric expression. Don't calculate manually and hard code the valuc) - 20ii).Write a command to delete the new movie actor role actnumb: INTEGER NOT NULL mvnumb: INTEGER NOT NULL (FK) actnumb: INTEGER NOT NULL(FK) actname: CHAR(20) NOT NULL birthplace: CHAR(20) NOT NULL yearbom: INTEGER NOT NULL yeardied: INTEGER NULL mvfee: INTEGER NOT NULL ea movie mvnumb: INTEGER NOT NULL director mvite: CHAR(30) NOT NULL yearmade: INTEGER NOT NULL mvtype: CHAR(10) NOT NULU noms: INTEGER NOT NULL awrds: INTEGER NOT NULL dimumb: INTEGER NOT NULL (FK) dirnumb: INTEGER NOT NULL dirname: CHAR(20) NOT NULL yearbom: INTEGER NOT NULL yeardied: INTEGER NULL ie