I avoid `having` wherever possible these days. There are data analysts in my team that I know would have to think twice about it if they encountered it in my co

I avoid `having` wherever possible these days. There are data analysts in my team that I know would have to think twice about it if they encountered it in my code, and to be honest, it's a bit of an wart in the SQL grammar anyway. In (almost) all cases, a subquery with an extra `where` clause will have equal performance to a `having` clause in the main query. See the final example in: http://en.wikipedia.org/wiki/Having_(SQL) http://en.wikipedia.org/wiki/Having_(SQL)