ThinkChat🤖让你学习和工作更高效,注册即送10W Token,即刻开启你的AI之旅 广告
``` 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 ```