select Teaches.Pnr, count(*)
    from Teaches
    where Teaches.Coursecode in (
        select Coursecode from Externalcourse
        union
        select Coursecode from Internalcourse
    )
    group by Pnr
    having count(*) > 1;