Advertisement
Guest User

Untitled

a guest
Nov 18th, 2018
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.23 KB | None | 0 0
  1. SELECT GRUPY.NAZWA,SREDNIA FROM GRUPY
  2. JOIN(SELECT G.GRUPA_ID GGI, COUNT(S.OSOBA_ID) SREDNIA FROM STUDENCI S RIGHT OUTER JOIN GRUPY G ON G.GRUPA_ID=S.GRUPA_ID
  3. GROUP BY G.GRUPA_ID having count(*)=COUNT(S.OSOBA_ID)) ON GRUPY.GRUPA_ID=GGI
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement