I'm struggling with a question that said Which customer has rented the
most films?

I am doing this using the Seikila sample database in MySQL. I have something that joins my tables together and attempts to give me a count but I know its wrong just looking at the actual data in the rental table. 
my code is as below

```
SELECT r.rental_id, cust.customer_id, count(*) as Total_Rentals
FROM rental as r
INNER JOIN customer AS cust on r.customer_id = cust.customer_id
GROUP BY cust.customer_id;

```

but it tells me for example customer 1 has rented 32 movies, which I know is wrong. what am I doing wrong?
since I was asked for clarification, the database I am using is:
<https://dev.mysql.com/doc/sakila/en/>

And I am trying to find which customer has rented the most films, I am not entirely sure what my script is actually returning.