In this Tutorial you will continue working on the EliteVideo database from last week. If you have not

finished Task $1$ in Tutorial $8,$ you need to work on it during the tutorial.

Make sure that you have already created the EliteVideo database and entered sample data on your

computer before starting the tasks for this week.

Task $1$

Construct a SQL statement that retrieves the movie titles along with the count of rentals for each

movie.

Task $2$

Construct a SQL statement to display name, email, phone number and address of the

members who have rented movies released after $01/01/2023.$

Task $3$

Construct a nested SQL statement using the EXISTS function to display members $($memberID$,$

name, address$)$ who have rented at least one movie.

Task $4$

Construct a nested SQL statement using the EXISTS function to display members $($memberID$,$

name, address$)$ who have rented movies with a rating higher than $4($Assuming that the scale of

rating is from $1$ to $5).$