MySQL-DQL-分组查询

 

select gender,count(*) from emp group by gender;
select gender,avg(age) from emp group by gender;
select workaddress,count(*) from emp where age < 45 group by workaddress having count(*) >= 3;