You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
21 lines
510 B
21 lines
510 B
SELECT stage,d,
|
|
(case d when '03' then '25人及以下'
|
|
when '04' then '26-30人'
|
|
when '05' then '31-35人'
|
|
when '06' then '36-40人'
|
|
when '07' then '41-45人'
|
|
when '08' then '46-50人'
|
|
when '09' then '51-55人'
|
|
when '10' then '56-60人'
|
|
when '11' then '61-65人'
|
|
when '12' then '66人及以上' end
|
|
),
|
|
sum(sum) AS total
|
|
FROM mv_dp_bane_stage_chengxiang
|
|
GROUP BY d,stage
|
|
|
|
order by
|
|
(case when stage='小学' then 1
|
|
when stage='初中' then 2
|
|
when stage='高中' then 3
|
|
end),d |