select * from (
$ k. v" Z% @+ U9 W- d, ~8 Mselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area
) u/ h0 Y. I: s6 B8 J5 \+ Tfrom admissions_data_info ) t/ @0 j( P8 P! \
group by business_year,area
! P9 u, e$ r9 z- u x) dunion all5 c$ T/ M2 N; T( c& i: O
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area6 H* Z6 V: N' v& P$ I+ J3 p
from admissions_data_info
$ a* L: E7 F$ l _: h6 r8 rgroup by business_year,area) ?3 P) t0 \ Q3 m% b
union all
$ o! K9 B' ^! n2 m' ~- Rselect business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area
, {' v' h2 \* I- d+ W* O7 Jfrom admissions_data_info * w K. ^, @3 }& d7 h% p
group by business_year
2 Q- m+ s* W/ l( m+ eunion all
# z x% E- b$ M xselect business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area
3 u+ n" Y$ W4 F0 N7 i9 e& Gfrom admissions_data_info
2 H% h& ]8 [. ]& agroup by business_year
- K& m/ P/ f* j, G)a
8 w0 M) \: h, B- i8 @& nwhere area=:area" H$ F F! \ } A) G% |
order by x |
楼主: 干一炮
发表于 2021-3-9 11:43:04
显身卡
