SELECT subs.fname Name, subs.name Vorname, cha.CHARACTER Rolle, mov.TITLE Film
FROM
  (SELECT a.fname, a.name, mov.title, a.aid, COUNT(DISTINCT cha.CHARACTER) AS anzahl_Rollen
  FROM h_o.actors a, h_o.CHARACTER cha, h_o.movie mov, h_o.CAST c
  WHERE c.pid = mov.mid
  AND c.aid = a.aid
  AND c.cid = cha.cid
  GROUP BY a.name, a.fname, a.aid, mov.title
  HAVING COUNT(DISTINCT cha.CHARACTER)>1)
subs, h_o.CHARACTER cha, h_o.CAST cas, h_o.movie mov
WHERE cha.cid = cas.cid
AND cas.aid = subs.aid
AND cas.pid = mov.mid