Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT K.ID_KLIENTA, K.IMIE, K.NAZWISKO
- FROM UDZIAL U LEFT JOIN KLIENT K
- ON U.ID_KLIENTA = K.ID_KLIENTA
- GROUP BY K.ID_KLIENTA,K.IMIE,K.NAZWISKO
- HAVING COUNT(U.ID_ZAJECIA ) > (SELECT COUNT (UD.ID_ZAJECIA) / COUNT (KL.ID_KLIENTA)
- FROM UDZIAL UD FULL OUTER JOIN KLIENT KL
- ON UD.ID_KLIENTA = KL.ID_KLIENTA)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement