SELECT nazwa
FROM Bandy B
WHERE
    B.nr_bandy IN
    (
    SELECT nr_bandy FROM Kocury HAVING COUNT(pseudo) >= 5 GROUP BY nr_bandy
    )
    AND
    2 =
    (
    SELECT COUNT(*)
    FROM Kocury K JOIN Wrogowie_Kocurow WK USING(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 <= 3
            )
    );