select * from () i6 a. a) d% F! b7 F, r
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area
4 a5 y3 d2 v. @# e$ K- Nfrom admissions_data_info + ?/ i. V& g8 k3 ]% p/ q% q& y! {
group by business_year,area
$ h+ _) h( E/ {6 D2 C8 punion all
* g# g4 B1 V+ w! b2 l" F& B3 jselect business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area
/ s/ {/ d, r$ A2 x2 zfrom admissions_data_info- h) i8 y# p% f" |
group by business_year,area
) ?- i. q% A& [3 W0 |$ d6 kunion all0 N+ Q' \/ u3 Z# W ~
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area
L( T/ J5 Y" lfrom admissions_data_info
. \. r' M, d# Z5 N2 a; lgroup by business_year
; K4 z* r' |' G9 [+ h& n5 b( Uunion all
+ ?# J- L+ T3 V3 R; E" Lselect business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area C) J" K# N; Y
from admissions_data_info
2 R: G6 o( E7 H6 }" ~group by business_year- {- e! i. o# h" E
)a
- ~8 f+ [9 {% owhere area=:area
3 R E- ?+ F+ b% O0 Q# \order by x |