WITh r as (
    SELECT
        ffc.partid
    FROM
        (SELECT
            fc.filmcharacter
        FROM filmcharacter as fc
        GROUP BY fc.filmcharacter
        HAVING count(*)=1) as dch
    JOIN filmcharacter as ffc ON dch.filmcharacter=ffc.filmcharacter
), rr as (
    SELECT
        fp.personid, count(*)
    FROM filmparticipation as fp
    JOIN r ON fp.partid=r.partid
    GROUP BY fp.personid
    HAVING count(*)>199
)