按照需求完成如下 DQL 语句编写:
    image.png

    1. --1.
    2. select * from emp where gender = '女' and age in (20,21,22,23);
    3. --2.
    4. select * from emp where gender = '男' and (age between 20 and 40) and name like '___';
    5. --3.
    6. select gender, count(*) from emp where age < 60 group by gender;
    7. --4.
    8. select name, age from emp where age <= 35 order by age asc, entrydate desc;
    9. --5.
    10. select * from emp where gender = '男' and age between 20 and 40
    11. order by age asc, entrydate asc limit 5; /*limit 应放在最后*/