SELECT

class_id,

sum(

CASE

WHEN sex = '男' THEN

1

ELSE

0

END

) AS '男',

sum(

CASE

WHEN sex = '女' THEN

1

ELSE

0

END

) AS '女'

FROM

student

GROUP BY

class_id;