select * from (6 @: z; n& k+ K2 s! B- [
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area
, `9 q' u! \4 X0 M8 x( t4 Lfrom admissions_data_info 9 o$ D( p9 i' `4 w2 y3 H* T
group by business_year,area
& b1 a9 Q( e5 g6 r; r" A7 e0 L( {union all
0 @$ Y" z& p: Jselect business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area
8 d3 c6 {3 S! y5 T% Xfrom admissions_data_info
" U2 {9 q% w" ~# Jgroup by business_year,area+ z; S, R9 {3 S
union all
& a& t$ b6 O1 M4 `. vselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area
* c: a& m. B/ L' ?, _( {8 ]$ Ofrom admissions_data_info + ^$ |3 \+ i5 q# j: b( u8 F
group by business_year
* y6 i d; |& Gunion all! B# I: L8 {- L! P5 `# O2 s- {
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area
* J' E: a2 S: W; A+ X) D9 Ufrom admissions_data_info0 i% o0 z `* f, }8 Y
group by business_year
4 X7 e( f! K7 u W( r9 W" N)a
0 J& H: d' ?& h4 M' U7 ^7 I' T% s" awhere area=:area9 \( ]' n" `: ~) { N
order by x |
[复制链接]
发表于 2020-12-3 08:51:46
照妖镜