果然第一反应才是本质。 select case when profile like "%,female" then "female" else "male" end as gender, count(*) as number from user_submit group by gender
点赞
牛客网
牛客网在线编程
牛客网题解
牛客企业服务