SELECT act.fname, act.name, COUNT(cha.CHARACTER), mov.title
FROM h_o.CHARACTER cha, h_o.CAST cas, h_o.movie mov, h_o.actors act
WHERE cha.cid = cas.cid
  AND act.aid=cas.aid
  AND mov.mid=cas.pid
GROUP BY act.fname, act.name, mov.title
HAVING COUNT(cha.CHARACTER) > 1
ORDER BY COUNT(cha.CHARACTER) DESC;