Sakila is a movie rental company. Please go through the E$-$R diagram and the structure

of the database to understand the database.

Answer these questions with a SQL query $(2$ Points Each$)$:

$1.$ What is the most watched film $($number of rentals$)$ by each category?

$2.$ What is the total rental amount per category?

$3.$ For each category, list the customer who is the second most renter.

$4.$ What is the second most popular movie title?

$5.$ What are the most popular categories?

$6.$ What are the top $10$ most rented movies by category?

$7.$ What are the average rental days for each movie?

$8.$ What are the top $10$ most rented movies by day of the week?

$9.$ What is the total rental revenue $($total amount of all rentals$)$ by day of the week?

$10.$ What are the most popular movies for each reward tier?

$11.$ What are the average rental days by reward tier?

$12.$ What are the most popular days to rent movies?

$13.$ What are the most popular days to rent movies by reward tier?