SELECT nazwa
FROM Bandy B
WHERE   B.nr_bandy IN
                (SELECT nr_bandy
                 FROM Kocury K
                 LEFT JOIN Wrogowie_Kocurow WK ON K.pseudo = WK.pseudo
                 GROUP BY K.nr_bandy
                 HAVING COUNT(DISTINCT K.pseudo) > 4)
    AND 2 = (SELECT COUNT(*)
             FROM Kocury K
             JOIN Wrogowie_Kocurow WK ON K.pseudo = WK.pseudo
             WHERE B.nr_bandy = K.nr_bandy
                AND WK.imie_wroga IN
                  (SELECT *
                   FROM
                    (SELECT imie_wroga
                     FROM Wrogowie
                     ORDER BY stopien_wrogosci DESC)
                   WHERE ROWNUM < 4))