-
需求:计算 全日制 哲学,经济学,法学,教育学,文学,历史学,理学,工学,农学,医学,军事学各占总人数多少
-
展示
-
代码
SELECT
COUNT( 1 ) AS allcount,
SUM( CASE WHEN garduate_school_major = 11 THEN 1 ELSE 0 END ) AS 医学,
SUM( CASE WHEN garduate_school_major = 10 THEN 1 ELSE 0 END ) AS 农学,
SUM( CASE WHEN garduate_school_major = 12 THEN 1 ELSE 0 END ) AS 军事学,
SUM( CASE WHEN garduate_school_major = 13 THEN 1 ELSE 0 END ) AS 普师,
SUM( CASE WHEN garduate_school_major = 2 THEN 1 ELSE 0 END ) AS 哲学,
SUM( CASE WHEN garduate_school_major = 3 THEN 1 ELSE 0 END ) AS 经济学,
SUM( CASE WHEN garduate_school_major = 4 THEN 1 ELSE 0 END ) AS 法学,
SUM( CASE WHEN garduate_school_major = 5 THEN 1 ELSE 0 END ) AS 教育学,
SUM( CASE WHEN garduate_school_major = 6 THEN 1 ELSE 0 END ) AS 文学,
SUM( CASE WHEN garduate_school_major = 7 THEN 1 ELSE 0 END ) AS 历史学,
SUM( CASE WHEN garduate_school_major = 8 THEN 1 ELSE 0 END ) AS 理学,
SUM( CASE WHEN garduate_school_major = 9 THEN 1 ELSE 0 END ) AS 工学
FROM
user
- 效果