I'm needing some help with a SQL query using PostgreSQL 9.4.

I need the most rented movies on each local, this is the data I'm asked to select

* movie title
* year
* local id
* number of rents

Tables: 

```
rental(idMovie, idLocal, idClient)
movies(idMovie, title, description, year)

```

This is what I have done, but is not what i am asked to do.

```
SELECT m.tile, m.year, r.idLocal, COUNT(*) AS cont
FROM rental r, movies m
WHERE m.idMovie=r.idMovie
GROUP BY r.idLocal, m.title, m.year
ORDER BY COUNT(*) DESC;

```