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… Continue reading adventures in SQL: using ‘where’ and ‘having’