select * from (
! D& b. o' e* q1 {- T+ J8 b+ i* \select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area
& q' |+ F" ^ ?! y# Y0 |from admissions_data_info
9 y6 \* L K( U, Ngroup by business_year,area$ e7 a4 |/ p9 z5 y- ~7 S
union all# n; [1 a& j9 X
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area6 e. e# d I/ o; z
from admissions_data_info% Q6 X1 s. Z9 z# F+ K
group by business_year,area- @3 u8 S5 Y9 ^! K0 s
union all# G; v. V1 e4 G
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area
8 j! [+ N& _' `, L' G9 j( [from admissions_data_info
7 i. S" W2 x* ?& s# Q* f: rgroup by business_year
6 F0 G( Y; q2 Vunion all
- @/ Z6 s$ k- h! ?select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area/ x6 Y* X+ s& @& w# d- N
from admissions_data_info
8 M, A" ?9 d8 F8 x# m. ?1 kgroup by business_year, S2 a! ~% x$ N, C6 N: f- m1 V7 ^
)a
% I' L4 F7 ?2 r8 hwhere area=:area: A( Y" a$ S( f2 O
order by x |
[复制链接]
发表于 2021-3-9 11:43:04
显身卡