mysql 多个having

SELECT column_name, aggregate_function(column_name)
FROM table_name
GROUP BY column_name
HAVING aggregate_function(column_name) > value;

SELECT employee_id, SUM(sales) as total_sales
FROM sales_table
GROUP BY employee_id
HAVING total_sales > (SELECT AVG(total_sales) FROM (SELECT SUM(sales) as total_sales FROM sales_table GROUP BY employee_id) as subquery);

SELECT column_name, aggregate_function(column_name)
FROM table_name
GROUP BY column_name
HAVING condition1 AND/OR condition2;

SELECT employee_id, SUM(sales) as total_sales, COUNT(order_id) as order_count
FROM sales_table
GROUP BY employee_id
HAVING total_sales > (SELECT AVG(total_sales) FROM sales_table) AND order_count > 10;

SELECT employee_id, SUM(sales) as total_sales, COUNT(order_id) as order_count
FROM sales_table
GROUP BY employee_id
HAVING total_sales > CAST(AVG(total_sales) AS DECIMAL(10, 2)) AND order_count > 10;