Ok ho risolto!!!!!

Ho creato una vista MOST_POPULAR così fatta:
create view most_popular (_id_module,vote,click) as
select _id_module,sum(click),avg(vote) from popularity group by (_id_module) order by(sum(click)) desc

Poi la utilizzo per estrarre gli _id_module che mi interessano e successivamente i relativi titoli:
select title from modules inner join most_popular on id=_id_module where _id_module in (select top 5 _id_module from most_popular where vote>=5 order by (vote) desc)