Answered step by step
Verified Expert Solution
Question
1 Approved Answer
CREATE TABLE NPHDMovies ( Title TEXT, -- Title of the movie, PK Year INTEGER, -- Year the movie was released on one of the platforms
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()
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started