select * from (
7 C3 n- D9 E. ?select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area
7 f" X) D# I# T/ b2 Y. {from admissions_data_info {! F- z7 T* L: g+ n6 q
group by business_year,area ?$ }0 F( \7 h4 X2 J$ G
union all
4 U2 o& a* @- ^ jselect business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area" ^1 X! W" U& `7 b% z
from admissions_data_info
+ ]- ?3 d8 W" W7 h9 I! ygroup by business_year,area
+ t+ N9 s8 K( A! s! K+ Gunion all
9 z W$ P2 e* O5 Uselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area
5 `! W% Q' J' [) m# {: kfrom admissions_data_info
2 X2 x- M/ {- x: ]group by business_year6 I6 ], I: B$ R
union all3 u9 v0 M# d d3 T) L3 M+ N
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area
6 l: ?/ Q$ f% `) Y: s6 hfrom admissions_data_info
% T( Q+ x% e* n. G' b2 X/ Ngroup by business_year9 X+ s: r& t% @# M7 l1 J
)a
% d& H8 `2 w2 k6 s3 ^- hwhere area=:area
: E5 _3 @! y- v( Jorder by x |
楼主: 干一炮
发表于 2021-3-9 11:43:04
显身卡
