按照需求完成如下 DQL 语句编写:
--1.select * from emp where gender = '女' and age in (20,21,22,23);--2.select * from emp where gender = '男' and (age between 20 and 40) and name like '___';--3.select gender, count(*) from emp where age < 60 group by gender;--4.select name, age from emp where age <= 35 order by age asc, entrydate desc;--5.select * from emp where gender = '男' and age between 20 and 40order by age asc, entrydate asc limit 5; /*limit 应放在最后*/
