Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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") Q9 ( 3 Marks ). Find, for each platform, the movie that yielded the highest revenue. Your output should have the name of the platform, the title of the movie, and its revenue

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intranet And Web Databases For Dummies

Authors: Paul Litwin

1st Edition

0764502212, 9780764502217

More Books

Students also viewed these Databases questions