select * from (" z1 b& m: c+ B. r; {2 o% m2 s
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area# F& K1 ?) H/ y
from admissions_data_info & J) ?9 h, v$ u% n% g8 |
group by business_year,area5 W# K2 T# g$ q7 [: ?1 P+ s: S3 [
union all9 A' t4 ^* R3 v9 o `% l9 C/ ?/ f
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area
) i5 A# @$ B0 O$ K& d! S4 l% Yfrom admissions_data_info
9 h3 a5 r. O& V9 ?1 ? `3 Zgroup by business_year,area& V g) O/ d7 M7 [: @: c5 K
union all
3 A C' \# F; Y: L4 X8 ?5 dselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area. U" y" W. }; Q8 v
from admissions_data_info 2 t8 R+ h) M6 [- p0 d! r' c8 U: C
group by business_year& @- A- ]# d% p' Q5 X# s
union all; J% |7 R4 M H- q, p6 `- e; X
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area3 m' l' }- q! }
from admissions_data_info/ H9 F1 A3 M) i; ~. k
group by business_year
) ?' [4 ] ^, i( V; |3 W) ])a+ a. F* j" a$ D! I" {
where area=:area2 g9 Q* J* b/ D& T0 m( S/ F
order by x |
楼主: 干一炮
发表于 2021-3-9 11:43:04
显身卡
