(See Note below). 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. 11. List details for the directors that have ever directed Horror type movies. Show each director only once and sequence alphabetically by name 12 Lis the average feepaid or acton in roe in a Horr movie in 2011 13. List the number of movies made for each movie type. Order the output by highest count to lowest -14. List the movie types that have had between 3 and 5 movies made between 2008 and 2010 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 each actor's details once and sequence by actor name -16. List the details for those movies whose title contains within it either '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 value) - 20(ii). 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 ovie mvnumb: INTEGER NOT NULL director mvtitle: CHAR(30) NOT NULL yearmade: INTEGER NOT NULL mvtype: CHAR(10) NOT NULL noms: INTEGER NOT NULL awrds: INTEGER NOT NULL dirnumb: INTEGER NOT NULL (FK) dirnumb INTEGER NOT NULL dirname: CHAR(20) NOT NULIL yearbom: INTEGER NOT NULL yeardied INTEGERNULL