Question: How would I write a function that takes year as input, and returns a list of the titles of the most rented films among the

 How would I write a function that takes year as input,

How would I write a function that takes year as input, and returns a list of the titles of the most rented films among the films released that year. Using Sqllite query

Customers ( cardNo INTEGER PRIMARY KEY, first TEXT, last TEXT, sex CHAR, dob DATE Movies movieId INTEGER PRIMARY KEY, title TEXT, year INTEGER Rentals cardNo INTEGER, movieId INTEGER, date DATE, rating INTEGER, PRIMARY KEY (cardNo, movieID, date), FOREIGN KEY (cardNo) REFERENCES Customers, FOREIGN KEY (movield) REFERENCES Movies

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!