企业🤖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 ```