Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT P.ID_PLYWALNI, K.ID_KLIENTA, K.IMIE, K.NAZWISKO
- FROM UDZIAL U LEFT JOIN KLIENT K
- ON U.ID_KLIENTA = K.ID_KLIENTA
- INNER JOIN ZAJECIE Z
- ON Z.ID_ZAJECIA = U.ID_ZAJECIA
- INNER JOIN PRACOWNIK P
- ON P.ID_PRACOWNIKA = Z.ID_PRACOWNIKA
- GROUP BY P.ID_PLYWALNI, 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