Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT R.Fornavn, R.Studentnr, SUM(M.Studiepoeng) 'Antall'
- FROM Emne AS M
- JOIN (
- SELECT DISTINCT E.Emnekode, S.Studentnr, S.Fornavn
- FROM Emne AS C
- JOIN Eksamen E
- JOIN Eksamensresultat ER ON ER.Eksamensnr = E.Eksamensnr
- JOIN Student S ON ER.Studentnr = S.Studentnr
- WHERE
- ER.Karakter != 'F'
- ) R
- WHERE
- M.Emnekode = R.Emnekode
- GROUP BY
- R.Fornavn
- HAVING SUM(M.Studiepoeng)>30
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement