a guest Nov 18th, 2018 78 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT K.pseudo, przydzial_myszy
  2. FROM Kocury K LEFT JOIN Wrogowie_kocurow WK ON K.pseudo = WK.pseudo
  3. WHERE  imie_wroga IS NULL AND 55< (
  4.                                 SELECT AVG(NVL(przydzial_myszy,0))
  5.                                 FROM Kocury
  6.                                 WHERE nr_bandy = K.nr_bandy
  7.                                 GROUP BY nr_bandy
  8.                                 ) AND plec = 'M';
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand