ࡱ> NM f2\p Administrator Ba== Nt18X@"1[SO1[SO1[SO1[SO1[SO1[SO1[SO1[SO1[SO1[SO1[SO1[SO1[SO1[SO1 h6I{~ Light1,6[SO16[SO16[SO1[SO1[SO1[SO14[SO1 [SO1[SO1 [SO14[SO1 [SO1<[SO1?[SO1>[SO1[SO1 [SO1[SO""#,##0;""\-#,##0""#,##0;[Red]""\-#,##0""#,##0.00;""\-#,##0.00#""#,##0.00;[Red]""\-#,##0.007*2_ ""* #,##0_ ;_ ""* \-#,##0_ ;_ ""* "-"_ ;_ @_ .))_ * #,##0_ ;_ * \-#,##0_ ;_ * "-"_ ;_ @_ ?,:_ ""* #,##0.00_ ;_ ""* \-#,##0.00_ ;_ ""* "-"??_ ;_ @_ 6+1_ * #,##0.00_ ;_ * \-#,##0.00_ ;_ * "-"??_ ;_ @_ \$#,##0_);\(\$#,##0\)\$#,##0_);[Red]\(\$#,##0\) \$#,##0.00_);\(\$#,##0.00\)% \$#,##0.00_);[Red]\(\$#,##0.00\)3#,##0\ " ";\-#,##0\ " "=#,##0\ " ";[Red]\-#,##0\ " "?#,##0.00\ " ";\-#,##0.00\ " "I"#,##0.00\ " ";[Red]\-#,##0.00\ " "k3_-* #,##0\ _ _-;\-* #,##0\ _ _-;_-* "-"\ _ _-;_-@_-q6_-* #,##0\ " "_-;\-* #,##0\ " "_-;_-* "-"\ " "_-;_-@_-{;_-* #,##0.00\ _ _-;\-* #,##0.00\ _ _-;_-* "-"??\ _ _-;_-@_->_-* #,##0.00\ " "_-;\-* #,##0.00\ " "_-;_-* "-"??\ " "_-;_-@_-yyyy\-m\-d\ hh:mm:ss0_                                     P P      a>     ff   `                x@ @  X X x@ @ x@ @ X x@ @ x@ @ x@ @   X x@ @ X  x@ @ x@ @ x@ @  x@ @   x@ @  x@ @  X  X x@ @ x@ @  x@ @ x@ @  x@ @  x@ @  !x@ @ !X ||ZM}<} " "_ef#,##}<} " "_ef#,##}<} " "_ef#,##}<} " "_ef#,##}<} " "_ef#,##}<} " "_ef #,##}<} " "_L#,##}<} " "_L#,##}<} " "_L#,##}<} " "_L#,##}<} " "_L#,##}<} " "_L #,##}<} " "_23#,##}<} " "_23#,##}<} " "_23#,##}<} " "_23#,##}<}  " "_23#,##}<}! " "_23 #,##}-}# " "_}<}$ " "_#,##}<}% " "_?#,##}<}& " "_23#,##}(}' " "_}<}( " "_#,##}<}) a" "_#,##}P}* " "_#,##" "_}}- }" "_#,##" "_"-"? _-;_ }}. " "_#,##???" "_???"-"? ???_-;_ ???}(}/ " "_}(}0 " "_}<}1 }" "_#,##}<}4 " "_#,##}<}5 " "_#,##}<}6 " "_#,##}<}7 " "_#,##}<}8 " "_#,##}<}9 " "_ #,##}<}: W" "_#,##}}; ???" "_#,##???" "_???"-"? ???_-;_ ???}}< ??v" "_̙#,##" "_"-"? _-;_ }x}=" "_#,##" "_ "-"? _-;_}(}>" "_}(}F " "_}(}G " "_}(}L" "_}(}M " "_}(}N" "_}(}S" "_}(}U" "_}(}V " "_}(}W " "_!20% - :_eW[r 1J20% - :_eW[r 1 ef !20% - :_eW[r 2J"20% - :_eW[r 2 ef !20% - :_eW[r 3J&20% - :_eW[r 3 ef !20% - :_eW[r 4J*20% - :_eW[r 4 ef !20% - :_eW[r 5J.20% - :_eW[r 5 ef !20% - :_eW[r 6J220% - :_eW[r 6  ef !40% - :_eW[r 1J40% - :_eW[r 1 L !40% - :_eW[r 2J#40% - :_eW[r 2 L˭ !40% - :_eW[r 3J'40% - :_eW[r 3 L !40% - :_eW[r 4J+40% - :_eW[r 4 L !40% - :_eW[r 5J/40% - :_eW[r 5 L !40% - :_eW[r 6J340% - :_eW[r 6  L !60% - :_eW[r 1J 60% - :_eW[r 1 23 !60% - :_eW[r 2J$60% - :_eW[r 2 23 !60% - :_eW[r 3J(60% - :_eW[r 3 23 !60% - :_eW[r 4J,60% - :_eW[r 4 23f ! 60% - :_eW[r 5J060% - :_eW[r 5 23 !!60% - :_eW[r 6J460% - :_eW[r 6  23Ў "~vRk #h+h DTj% $h 18h 1 DTjDr %h 28h 2 DTj? &h 38h 3 DTj23 'h 4*h 4 DTj(]0]  8^ĉ)}Y0}Y  a *Gl;`BGl;` DrDr+'^, '^[0] -{j{  } .hgUSCQ:_eW[r 1 Dr 5:_eW[r 2>!:_eW[r 2 }1 6:_eW[r 3>%:_eW[r 3  7:_eW[r 4>):_eW[r 4  8:_eW[r 5>-:_eW[r 5 [ 9:_eW[r 6>1:_eW[r 6  pG  :-N2-N  W ;QjQ  ???????????? ??? <eQjeQ ̙ ??v  =lʑ^ lʑ  XTableStyleMedium2PivotStyleLight16`,H Select select)v SQL StatementVV  ;4A 01W(g] zf[b0101W(g] z4020103Rgb/gN] z0104[hQ] z0105Km~] z01070W(] z0108 SehhN!nl] z0109N] z0112W^0W Nzz] z^Q{NĉRf[b0201^Q{f[50207WaNĉR0208ΘofVg03 sXNn] zf[b0303sX] z0308 ^Q{sXNn^(u] z0309~c4lyf[N] z0310nNRR] z03110WtOo`yf[0313sXu`] z04~NmN{tf[b0402] z{t0403"R{t0405Of[0408~Nmf[0414?b0WN_SN{t0415] z N0416ё] z0417DNċ0O05 5uP[NOo`] zf[b05015uP[Oo`] z05020504O] z0505Q~] z0506^Q{5ulNzfS0520irTQ] z06 PgeNSf[] zf[b0601 e:g^ё^\Pge] z0602ؚRP[PgeN] z0603^(uSf[0604Sf[] zN]z0612ё^\Pge] z07petf[b0703^(uirtf[0704~f[0705Xf[08YVf[b080110 :ghN5ul] zf[b1001 :gh6R SvQꁨRS1002 5ul] zSvQꁨRS1003ꁨRS1004Kmcb/gNNhV1005]N1006 Ǐ zňYNc6R] z1007:gh5uP[] z11lQqQ{tf[b1101lf[1102NRDn{t1103RRN>yOO1104W0WDn{t1105W^{tEselect jgdm,jgmc,zyh,zymc,xz,xqh_id,count(*) as zyrs from( select b.jgdm,b.jgmc,c.zyh,c.zymc,d.bj,d.xqh_id,a.* from jw_xjgl_xsjbxxb a,zftal_xtgl_jgdmb b,zftal_xtgl_zydmb c,zftal_xtgl_bjdmb d where substr(trim(a.xh),1,2)='18' and length(trim(a.xh_id))=11 and a.xh not in (select xh from wbd2018) and a.xh not in('18201040229','18202070220','18205010226','18211030141','18201050143','18204150126','18205060241') and a.zyh_id not in('0422','0424','0906') and a.jg_id=b.jg_id and a.zyh_id=c.zyh_id and a.bh_id=d.bh_id ) group by jgdm,jgmc,zyh,zymc,xz,xqh_id order by jgdm,zyh!h:S 7f[6R 7NN Ty 7f[b Ty 7^S 7T 7S!h:SWS!h:Ss~pe 7NN(W!h f[upe 7f[bNx 7NNNx 7 2020~TNNbc~leQf[uNpe`QNȉh   7{:gyf[Nb/g 7blNpeDN4 71 N1S11A2F22E3J33I4N44A5F558f9kcc PK![Content_Types].xmlN0EH-J@%ǎǢ|ș$زULTB l,3;rØJB+$G]7O٭V‡fgנ_K^PkPDIr.jw2et o^ɔQ yt),b-F@)$rh EqY$4h#}:4[CjFO9˖k`{x_?G=ݒG̔~ϿH _ǫf2h}_~zէC{#>"1|g1,P[惏$F"@Cu_FQm>G\Ga8f1aij.£E2sO&>B'(_!n-(J$KOc;V>!]ɘ3{xD&#+B$,]ՖmzF] QoDK4p&/$xz),K.N 9Cm$إ1f"{xIw1(12{gJv!_@4)DYp/obfpILVvms⌎bf ރw :ln|MVYecU='X`Ow.)+dxv9\n$%Jbwi^7mއ:Lw!A8rW#wj!vg%w=E de 2Qkut ""jSnjoڵ:$moƱ.q+ҋ53F ?ظ"Vlgo]{[S\u+>tWJv:r9ʺAE'5&yl3%On|L0%ΏTe&p3Ǚ|h9}d&23͙F=ԭtIzZY.ɴ $0&k \^%{d6D}5ehze¢`PWbrG-? @ Sw3/ӻiE@ NƳX{\Z]jgE7nDYtѳ8kZ)2[4WAn374N[~BȌѼO~s Xt_$̹=$: &sn![ %ׄN)Kƈt>ηZ`%a49Gba 8!ʩ5'nD”]:IP:^\{QwJv[eH]A2hVZYm A(4NW{^7l4O|DvBZI,ԃJۍ~~3`4dF;k7PK! ѐ'theme/theme/_rels/themeManager.xml.relsM 0wooӺ&݈Э5 6?$Q ,.aic21h:qm@RN;d`o7gK(M&$R(.1r'JЊT8V"AȻHu}|$b{P8g/]QAsم(#L[PK-![Content_Types].xmlPK-!֧6 0_rels/.relsPK-!kytheme/theme/themeManager.xmlPK-!Jzq theme/theme/theme1.xmlPK-! ѐ' theme/theme/_rels/themeManager.xml.relsPK]  f2 9VSgt  dMbP?_*+%3%&C&9,{ &P u qQ &N u& BP(?' BP(?(x L LL f@L@E7@ ~ L@ SU L > L LLM@L@E@@ ~ L@ SU L > L LLV@L@E(@ ~ L@ SU L > L LLN@L@E>@ ~ L@ SU L > L LLE@L?E @ ~ L@ SU L > L L L@V@L@E&@ ~ L@ SU L > L L LN@L@E>@ ~ L @ SU L > L L LV@L@E(@ ~ D"@ V W M F M M MN@M@X$@ ~ D$@ VW M F M M M@P@M@X@ ~ D&@ VW M F M MMQ@M@X@ ~ L(@ S U L > L LLM@L@E@@ ~ L*@ SU L >! L LLU@L@E*@ ~ L,@ SU L" ># L LLV@L@E$@ ~ L.@ SU L$ >% L LLV@L@E$@ ~ L0@ SU L& >' L LLN@L@E>@ ~ L1@ SU L( >) L LLE@L?E@ ~ D2@ R* T+ D, E- D DD@V@D@E&@ ~ D3@ RT D. E/ D DD@V@D@E&@ ~ D4@ RT D0 E1 D DDV@D@E$@ ~ D5@ RT D2 E3 D DDM@D@E?@ ~ D6@ RT D4 E5 D DDM@D@E@@ ~ D7@ RT D6 E7 D DDV@D@E(@ ~ D8@ RT D8 E9 D DDV@D@E"@ ~ D9@ RT D: E; D DDN@D@E>@ ~ L:@ S< U= L> >? L LL@V@L@E&@ ~ L;@ SU L@ N L LL@V@L@EG@ ~ L<@ SU LA >B L LLV@L@E"@ Dl(~ppppppp~pp~ppppp~ppppppp~p V@! V@" V@# V@$ V@% V@& V@' V@( V@) V@* V@+ V@, V@- V@. V@/ V@0 V@1 V@2 V@3 V@4 V@5 V@6 V@7 V@8 XI~ L=@ SU LC >D L L LV@L@E$@ ~ !L>@ !SU !LE !>F !L !L!LV@L@E(@ ~ "L?@ "SU "LG ">H "L "L"L@V@L@E&@ ~ #D@@ #RI #TJ #DK #EL #D #D#DV@D@E(@ ~ $D@@ $RT $DM $EN $D $D$DV@D@E"@ ~ %DA@ %RT %DO %EP %D %D%DM@D@E?@ ~ &DA@ &RT &DQ &ER &D &D&DN@D@E=@ ~ 'DB@ 'RT 'DS 'ET 'D 'D'DN@D@E=@ ~ (LB@ (SU (UV (LW (>X (L (L(LF@L?E@ ~ )LC@ )SU )LY )>Z )L )L)LV@L@E$@ ~ *LC@ *SU *L[ *>\ *L *L*LF@L?E@ ~ +DD@ +D] +H^ +D_ +E` +D +D+DV@D@EG@ ~ ,LD@ ,Sa ,Ub ,Lc ,>d ,L ,L,L@V@L@E&@ ~ -LE@ -SU -Le ->f -L -L-LU@L@E*@ ~ .LE@ .SU .Lg .>h .L .L.LV@L@E$@ ~ /LF@ /SU /Li />j /L /L/LV@L@E(@ ~ 0LF@ 0SU 0Lk 0>l 0L 0L0LF@L?E@ ~ 1LG@ 1SU 1Lm 1>n 1L 1L1LF@L?E@ ~ 2LG@ 2SU 2Lo 2>p 2L 2L2LF@L?E@ ~ 3DH@ 3Rq 3Tr 3Ds 3Et 3D 3D3DS@D@E5@ ~ 4DH@ 4RT 4Du 4Ev 4D 4D4DU@D@E,@ ~ 5DI@ 5RT 5Dw 5Ex 5D 5D5DJ@D@EC@ ~ 6DI@ 6RT 6Dy 6Ez 6D 6D6DL@D@EA@ ~ 7DJ@ 7RT 7D{ 7E| 7D 7D7DM@D@E@@ 8O8OOOOOO#8A\@ %7#8A@Y@8 %7~ 8 K@@6: ppp~pppp~pp~~pppppp~pppp>@s@@m    "" 88#'(*,23737,2(*#'7ggD f2 ?ww  dMbP?_*+%&?'?(?)?"&U} P} m  }">@  m 7ggD Oh+'0HP`x IdeallAdministratorMicrosoft Excel@z@cu;@~*v՜.+,0 PXd lt|  Select selectSQL Statement'Select select'!Print_Titles  Χ  !"#$%&'()*+,-./0123456789:;<>?@ABCDFGHIJKLRoot Entry F^/WorkbookxSummaryInformation(=DocumentSummaryInformation8E