CREATE TABLE "NPHDMovies" ( "Title" TEXT, -- Title of the movie, PK "Year" INTEGER, -- Year the movie was released on one of the platforms "Netflix" INTEGER, -- 1 if the movie is streamed on this platform, 0 otherwise "Hulu" INTEGER, -- 1 if the movie is streamed on this platform, 0 otherwise "PrimeVideo" INTEGER, -- 1 if the movie is streamed in this platform, 0 otherwise "Disney" INTEGER, -- 1 if the movie is streamed in this platform, 0 otherwise PRIMARY KEY("Title") ) CREATE TABLE "IMDBMovie" ( "Title" TEXT, -- Title of the movie, PK "Genre" TEXT, -- A string containing possibly several genres "Director" TEXT, -- Self-explanatory "Actors" TEXT, -- A list of actor names "Rating" REAL, -- Self-explanatory "Votes" INTEGER, -- Number of votes the movie has received (in IMDB) "Revenue" REAL, -- Self-explanatory PRIMARY KEY("Title") Q10 (3 Marks). What is the percentage of directors that have all their movies with a rating above 8.0? Note that the aggregate function COUNT() returns an INTEGER, you may want to re-cast its output to REAL by using the function CAST()