select * from (' ~8 j" J. }1 f3 Y
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area
4 {2 K$ \/ V b( x& Z1 \: Kfrom admissions_data_info ; O! ~0 n: ?5 K; l9 [9 s
group by business_year,area f1 C5 G' _; |4 n# _% A6 i- z7 B
union all
2 R s8 k3 m; H: v: h* H6 i7 Cselect business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area
# H/ R7 D5 G! w( mfrom admissions_data_info
& D) m9 d2 g; J" T& q0 u( |. Kgroup by business_year,area
1 P( ~4 h. N! k4 E/ `- [) v5 Gunion all3 Y! w5 i& |3 i8 Z+ d
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area5 [) } ]9 ~; k2 w9 A
from admissions_data_info
, I+ E1 p, f3 e8 N* I) E9 zgroup by business_year
) `9 B5 F% V. \union all
8 _" y7 ?+ x) x! k' t) dselect business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area
' e) ^6 n3 d5 t/ yfrom admissions_data_info
9 K, l" B. H* R6 `+ Pgroup by business_year
# g' b1 u. e! b# }4 ]% j$ O* y)a
0 |5 N) m& x7 ^& ]1 k- Vwhere area=:area. U! g! E2 Z, L* t
order by x |
[复制链接]
发表于 2020-12-3 08:51:46
照妖镜