Click here to see the full article post
Looks like this piece of code
Bonus ON Employee.empid = Bonus.empid
bonus < 1000 OR bonus IS NULL
should not be in this post.
GROUP BY class
HAVING COUNT(student) >= 5
what is the difference with or without distinct, I think any one even the same name can be counted, and it's not a major problem.
@glad2be, The Note at the very bottom states: "Note: The students should not be counted duplicate in each course." Thus you need the distinct.
Looks like your connection to LeetCode Discuss was lost, please wait while we try to reconnect.