题解 | #查找某个年龄段的用户信息#

#使用between a and b，即[a,b]
select device_id,gender,age from user_profile where age between 20 and 23;

#使用and运算符
select device_id,gender,age from user_profile where age >= 20 and age <= 23;