🔥码云GVP开源项目 12k star Uniapp+ElementUI 功能强大 支持多语言、二开方便! 广告
``` select device_id, gender, case when age >= 25 then '25岁及以上' when age >= 20 then '20-24岁' when age < 20 then '20岁以下' else '其他' end as age_cut from user_profile ``` ![](https://img.kancloud.cn/09/2d/092d8274171df31bf407684ffd129c17_323x313.png) ``` select DATE_FORMAT(date, '%d') as day, count(question_id) as question_cut from question_practice_detail where DATE_FORMAT(date, '%Y-%m') = '2021-08' group by date ```