select substr(title,1,instr(title,'of')+1)||'::'||count(*)
from movie
where title like 'The % of %'
and type = ' '
group by substr(title,1,instr(title,'of')+1)
having count(*)>80
order by count(*) desc
/