Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT Students.Id_Student, Name, Surname, COUNT(*) AS Number_of_exams
- FROM Students
- JOIN Exams ON Exams.Id_Student = Students.Id_Student
- WHERE Passed = 'Y'
- GROUP BY Students.Id_Student
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement