An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being aggregated is an outer reference.

聚合不能出现在WHERE子句,除非这个WHERE子句是包含HAVING子句或查询条件,并且你所聚合的列是外部参数