qq_31365147的博客

SELECT class_id, sum( CASE WHEN sex = '男' THEN 1 ELSE 0 END ) AS '男', sum( CASE WHEN sex = '女' THEN 1 ELSE 0 END ) AS '女'FROM studentGROUP BY class_id; ...

SELECT CASEWHEN YEAR (CURDATE()) - YEAR (birthday) - ( RIGHT (CURDATE(), 5) < RIGHT (birthday, 5)) <= 10 THEN '[0-10)岁'WHEN YEAR (CURDATE()) - YEAR (birthday) - ( RIGHT (CURDATE(), 5) &l...