adventures in SQL: using ‘where’ and ‘having’

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 😅

Leave a comment

Your email address will not be published. Required fields are marked *