I was of the understanding that the where
clause which is used like a filter, cannot use aggregate functions for filtering.
Furthermore, if you want to filter using an aggregate function, you need to use the having
clause.
My misunderstanding was that, if I use a having
clause, I couldn’t use a where
clause.
I now know that you can 😅