SELECT subs.name Schauspieler_Name, subs.fname Schauspieler_Vorname, cha.CHARACTER, mov.TITLE
FROM
  (SELECT a.name, a.fname, a.aid, COUNT(DISTINCT ch.CHARACTER) anzahl_Rollen
  FROM h_o.actors a, h_o.CHARACTER ch, h_o.movie m, h_o.CAST c
  WHERE c.pid = m.mid
  AND c.aid = a.aid
  AND c.cid = ch.cid
  GROUP BY a.name, a.fname, a.aid
  HAVING COUNT(DISTINCT ch.CHARACTER)>1)
subs, h_o.CHARACTER cha, h_o.CAST ca, h_o.movie mov
WHERE cha.cid = ca.cid
AND ca.aid = subs.aid
AND ca.pid = mov.mid
ORDER BY subs.name, subs.fname;