View the original community article here
Last tested: Jan 31, 2019
A filter on a dimension will generally result in a WHERE clause, and a filter on a measure (aggregation) will result in a HAVING clause
See this doc
This content is subject to limited support.