select * from (
0 P; ^' F6 J0 ^. t, R* [# n% uselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area- I9 [* C, q, O* M
from admissions_data_info
8 e( M: o; I* S, bgroup by business_year,area. K2 T% r, T5 W! T0 ^
union all/ x: u9 Z0 j1 b8 c0 P8 {" I
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area! g! K1 |( d1 D! ^
from admissions_data_info
@- `& B7 `% p# Cgroup by business_year,area7 N0 I1 p4 _1 E
union all9 n) D$ q' [) c# P) K
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area# y; ^& i6 Y- l( B9 {+ r9 p; |
from admissions_data_info
2 p9 C- r; W7 R5 O8 f/ Ngroup by business_year
0 m9 s1 w" E2 G# Q$ Lunion all5 ?& c8 c* B! ]
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area
) \9 O4 y# O0 p5 ifrom admissions_data_info
4 Y" J0 m3 ~: o9 ^group by business_year
( y# x# J; ]' f)a7 M* P' c. k. k& X0 A' D8 p
where area=:area2 H7 P$ f, d! ?% a
order by x |
楼主: 干一炮
发表于 2021-3-9 11:43:04
显身卡
