SELECT K.pseudo, przydzial_myszy
FROM Kocury K LEFT JOIN Wrogowie_kocurow WK ON K.pseudo = WK.pseudo
WHERE  imie_wroga IS NULL AND 55< (
                                SELECT AVG(NVL(przydzial_myszy,0))
                                FROM Kocury
                                WHERE nr_bandy = K.nr_bandy
                                GROUP BY nr_bandy
                                ) AND plec = 'M';