Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT GRUPY.NAZWA,SREDNIA FROM GRUPY
- 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
- 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