[Solved] what should i do to make this SQL query work? [closed]

by


I’m quite sure this query will work; meaning that it won’t return an error but I’m not certain if it will return correct result as what you intended:

SELECT s.Name, 
       SUM(p.Note=5)/COUNT(*) as Anteil 
FROM Studenten s
JOIN pruefen p ON p.MatrNr = s.MatrNr 
GROUP BY s.Name
ORDER BY Anteil DESC, s.Name ASC;

If this doesn’t return the result you’re looking for, update your question with data samples and expected output.

2

solved what should i do to make this SQL query work? [closed]