select * from (" b- [7 v2 [2 A4 I/ \" U8 W
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area
) m% y z8 N+ m4 wfrom admissions_data_info
3 |# k* X, h0 a; i# Xgroup by business_year,area
4 ?6 ~: D+ x- @& O Punion all
4 o" q0 Q3 o0 }/ Z0 | Eselect business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area' W- i. Y, t* ?# t
from admissions_data_info
- V& K% x. s6 w: R9 |" v8 Cgroup by business_year,area% c. o6 L" i* U6 X D0 I
union all
* o+ |3 d, @5 R# W% y5 Zselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area" R/ \0 B n D. I- x- d( k: o# c
from admissions_data_info
4 n9 z; J4 I {+ v+ @$ P) igroup by business_year
) v( X4 f b0 Lunion all6 X8 J3 G) u6 }. n
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area) Q/ i& c& V" ?& p/ S+ Y( T! W$ a
from admissions_data_info. `+ F# k- p {- v; O _' O
group by business_year
$ b( q; I* f- a# e$ })a
6 f7 \+ r& Y j* Cwhere area=:area; }3 s/ E! z& r0 r$ L/ L: ~
order by x |
楼主: 干一炮
发表于 2021-3-9 11:43:04
显身卡
