SELECT s.NUMSUPERVISOR, a.FCHALTA, a.PAIS
FROM AUDITOR a, SUPERVISOR s
WHERE a.NUMERO = s.NUMSUPERVISOR
AND NOT EXISTS (SELECT 1
                FROM AUDITOR a1
                WHERE a1.NUMERO NOT IN (SELECT a2.NUMERO
                                        FROM AUDITOR a2, ACEPTAARCHIVO ap1,ARCHIVO ar,CLIENTE cli
                                        WHERE a2.NUMERO=ap1.NUMERO AND ap1.CODIGO=ar.CODIGO AND ar.EMAIL=cli.EMAIL
                                        AND a2.PAIS = cli.PAIS)
                AND NOT EXISTS (SELECT 1
                                FROM  SUPERVISOR sup1
                                WHERE sup1.NUMAUDITOR =a1.NUMERO and sup1.NUMSUPERVISOR = a.NUMERO))
AND EXISTS (SELECT 1
            FROM AUDITOR);