立即学习:https://edu.csdn.net/course/play/27328/362529?utm_source=blogtoedu
group by 语法:
SELECT column_name,aggregate_function(column_name)
FROM table_name
GROUP BY column_name
select sex, count(*) from employee group by sex;
having 语法
HAVING aggregate_function(column_name) operator value
group by dept having max(salary)>=10000;