Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT s.imie, s.nazwisko, avg(o.wartosc)
- FROM student s
- INNER JOIN programosoby po ON (s.ido=po.ido)
- INNER JOIN programstudiow ps ON (po.kodps=ps.kodps)
- INNER JOIN etaposoby eo ON (po.idpo=eo.idpo) INNER JOIN
- semestr se ON (eo.kods=se.kods)
- INNER JOIN ocena o ON (s.ido=o.ido AND eo.ideo=o.ideo)
- WHERE ps.kodw='BGH2I' AND se.nazwas='15/16 Zima'
- GROUP BY s.ido, s.imie, s.nazwisko
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement