Advertisement
Guest User

Untitled

a guest
Mar 22nd, 2019
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.32 KB | None | 0 0
  1. SELECT K.ID_KLIENTA, K.IMIE, K.NAZWISKO
  2. FROM UDZIAL U LEFT JOIN KLIENT K
  3.     ON U.ID_KLIENTA = K.ID_KLIENTA
  4. GROUP BY K.ID_KLIENTA,K.IMIE,K.NAZWISKO
  5. HAVING COUNT(U.ID_ZAJECIA ) > (SELECT COUNT (UD.ID_ZAJECIA) / COUNT (KL.ID_KLIENTA)
  6.                                 FROM UDZIAL UD FULL OUTER JOIN KLIENT KL
  7.                                 ON UD.ID_KLIENTA = KL.ID_KLIENTA)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement