Advertisement
Guest User

Untitled

a guest
Nov 20th, 2017
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.16 KB | None | 0 0
  1. SELECT B.nazwa
  2. FROM Kocury K JOIN Bandy B ON K.nr_bandy = B.nr_bandy
  3. GROUP BY B.nazwa
  4. HAVING (SELECT COUNT(*) FROM Kocury WHERE nr_bandy = MAX(B.nr_bandy)) > 4;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement