Advertisement
Kocyk

Untitled

Nov 3rd, 2022
1,062
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.30 KB | None | 0 0
  1. SELECT  e.Id_egzaminator , e.Imie, e.Nazwisko, COUNT(*) AS "Liczba egzaminow"
  2. FROM Egzaminatorzy e
  3. INNER JOIN Egzaminy egz
  4. ON e.Id_egzaminator = egz.Id_egzaminator
  5. GROUP BY e.Id_egzaminator, e.Imie, e.Nazwisko
  6. HAVING COUNT(*) = (SELECT MAX(COUNT(*)) FROM Egzaminy e
  7. GROUP BY e.Id_egzaminator
  8. )
  9.  
  10.  
  11.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement