Collection of LeetCode questions to ace the coding interview! - Created using LeetHub
- both used to filter results
HAVING
is applied after theGROUP BY
clauseWHERE
is applied before theGROUP BY
clause- KEY difference:
HAVING
can be used with aggregation functions such asCOUNT()