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(workaddress) >=3); -- 或 select workaddress,count(*) address_count from emp where age <45 group by workaddress having address_count >=4;