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, 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
Get step-by-step solutions from verified subject matter experts
