select * from student where pwd is null;
select * from student where age between 100 and 150;
select * from student where createDate between '2024-02-21 00:00:00' and '2024-02-24 11:00:00';
select * from student where age >150 and age <200;
select * from student where sex in ('男','女');
select * from student where userName in ('女娲','蚩尤','盘古');
select * from student where userName not in ('女娲','蚩尤','盘古');