Advertisement
Guest User

Untitled

a guest
Feb 12th, 2019
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.22 KB | None | 0 0
  1. SELECT TOP 5 s.Nazwisko, s.Imie, w.Nip, (COUNT(o.ocena = 5)/COUNT(IdRodzajOceny) * 100) AS Procent
  2. FROM Studenci AS s
  3. JOIN Oceny o ON o.IdStudenta = s.IdStudenta
  4. JOIN Wykladowcy AS w ON w.IdWykladowcy = o.IdWykladowny
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement