select D2.Nome, D2.Cognome, D2.Dipartimento
from
        )
        select D.Cognome
        from docenti D
        group by D.Cognome
        having count(*) = 2
        ) AS D
        NATURAL JOIN
        docenti D2