Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT TOP 5 s.Nazwisko, s.Imie, w.Nip, (COUNT(o.ocena = 5)/COUNT(IdRodzajOceny) * 100) AS Procent
- FROM Studenci AS s
- JOIN Oceny o ON o.IdStudenta = s.IdStudenta
- JOIN Wykladowcy AS w ON w.IdWykladowcy = o.IdWykladowny
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement