Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT p.KATEDRA, p.PRZEDMIOT ,COUNT(o.OCENA), p2.o1c
- FROM A1_PRZEDMIOT p
- LEFT JOIN A1_OCENA o ON o.IDPRZEDMIOT = p.IDPRZEDMIOT
- INNER JOIN (SELECT p1.KATEDRA p1k, COUNT(o1.OCENA) o1c
- FROM A1_PRZEDMIOT p1
- LEFT JOIN A1_OCENA o1 ON o1.IDPRZEDMIOT = p1.IDPRZEDMIOT
- GROUP BY p1.KATEDRA) p2 ON p2.p1k=p.KATEDRA
- GROUP BY p.KATEDRA, p.PRZEDMIOT
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement