44. In-demand vs not-in-demand movies

Could you please let me know where I am going wrong with my below query:

As my result gives in-demand:331

not-in-demand:355

whereas expected result not-in-demand:669

with cte as
(select f.film_id, count(r.rental_id) as counters from film f left join inventory i on f.film_id=i.film_id left join rental r on i.inventory_id=r.inventory_id
where r.rental_ts>='2020-05-01' and r.rental_ts<'2020-06-01' group by f.film_id)

select case when counters>1 then 'in-demand'
else 'not-in-demand'  end as demand_category,count(*) from cte
group by demand_category;