使用多余的聚合列在MySQL中INSERT SELECT

I'd like to do an insert select where the select statement has aggregate columns for use by a "HAVING" clause, but where I do not actually want those columns to be inserted. A simple example:I'd like to do an insert select where the selec