select * from () i2 x+ [( Y- i/ W! \5 [
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area
: H1 ~0 Q( {( T# e: m5 x/ B, hfrom admissions_data_info / }8 }' n- D1 g' s7 \
group by business_year,area
6 L, V( r0 ~2 j- V8 Xunion all
1 J l& ?1 C1 G4 _0 {+ Kselect business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area. O) ?' d# ^/ J7 u1 M( { i# Z3 z
from admissions_data_info
" r) S# K" X- k3 \group by business_year,area
6 G6 J+ j6 X- {' B/ iunion all
6 I; ]! P7 m2 ~5 M9 P/ Uselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area
# f4 [" C/ ~. ? Y2 W# i2 kfrom admissions_data_info 6 r$ Y" c$ Q. I( n+ l
group by business_year
7 e5 R) l* _% i9 aunion all
9 O. x, [6 f9 ^9 e3 u. jselect business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area
5 B% \5 a0 ]7 B. M) E' ?. Vfrom admissions_data_info
1 s# Q( ]6 E, e3 u: Vgroup by business_year, z; G/ j( {7 }. ~; n. ^/ f' E
)a
% \$ U) I0 O ~6 Y6 `) I* F7 Fwhere area=:area
5 l% J) A3 _9 ? R( rorder by x |
[复制链接]
发表于 2021-3-9 11:43:04
显身卡