Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT s.id_student, s.nazwisko, s.imie,
- SUM(e.punkty) AS "Suma punktow",
- p.nazwa_p AS "Nazwa przedmiotu"
- FROM egzaminy e
- INNER JOIN studenci s ON s.id_student = e.id_student
- INNER JOIN przedmioty p ON e.id_przedmiot = p.id_przedmiot
- GROUP BY s.id_student, s.nazwisko, s.imie, p.nazwa_p
- ORDER BY s.id_student, p.nazwa_p ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement