邢唷>? >??= 衫\pKSK-LF Ba==hL,8X@"1@)Arial1@)Arial1@)Arial1@?媅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\)yyyy/m/d\ h:mm:ss? ? ? ? ? ? ? ? ? ? ? ? ? ? ?   ? ,? *? +? )? 1  1  1  €€€€€€`Y! SQL Results燲SQL StatementVV`iyKCDMKCMCKKXYXF01110110:g5u O≧€b/g鶺@x錧N6R 恌[b2.001110280Pg檈褃f[鶺@x3.501110290Pg檈b媁烻t01110490 O韕f[01110500irtSf[01120030瞞婼:Og鹼邁01120040:g癶OS緥01120070Km諎€b/g01120090pe z3.00112021001190100甠:g烻t011901206R錧 z鶺@x2.501190230pe€b/g鶺@x01190790}lft簨01190800}lf弰g 01190810}lf従嫛01190840}lf?uP[6R€b/g02111230鱩軶W觺刧緥蜽aN鷁緥f[b02111250 xSO觺刧02111760S愶嵷RKm z緥1.002111801eh乭錧 z z緥02123010袕y{f[02123020膥莮L圍Nf[1.502123030篘汻D崘nt02124020 艌p欏] z錧 z蠎nUS鱊02140100 'Ylal觛6R z緥02140350 颯L?`xvz z緥02141030痵軴緥Y鶺@x02142030闚hVR恎02142080y橆v颯L?`xvz02190590eh乭錧 z俰簨02190720鷁Q{緥Y錧 z02190780eh乭錧 z02190790S愶嵷RKm緥02190970 蜽^S愶+T貧恖Q飴 02195270eh乭梑棗b螛緥02230210 禰wQNH柧^:Wx02230220匭緥ON瀃瓔4.002230240 匭痵僗(嵪懤hKmON瀃瓔02230250 艌p櫧e錧蔛tON瀃瓔02230260 艌p欏] z匭ND崣eON瀃瓔02230270 錧 z蠎nUS鱊ON瀃瓔02230280艌p橮g檈^:Wx02230290 艌p櫨嫛媜忲NON瀃瓔02292320絜錧膥莮 z緥(絜錧筫T)02292330匭緥 z緥(緥筫T)03110191愥O烻t5uP[酧o`錧 zf[b5.003110211USGr:g烻t03110234 5ulKm蠎€b/gN OahV03110241梴:g6R€b/g031102725u汻5uP[€b/g031102905u:gN謆≧鶺@x03110310皊:W;`縹€b/g03110400梴:gQ軂€b/g031106805u義:WN甠鈒€b/g03110762 5u汻鹼邁鐍5u軴 z緥031107645u汻鹼邁R恎03111200愥O烻t z緥031112335ulKm蠎 z緥03111261 菑 z6R鹼邁錧 z緥03111300 袕≧6R鹼邁錧 z緥04115650USGr:g鶺@x 酧o`褃f[N€b/gf[b05190210pet邁uirNf[b05190220R癳'`瀃寶05190351NNY韹05190620otf[05190670畖筶6R罷錧z俧[05190680o傿Rf[05192440uir€b/go僫r05192960o僫rR恎05192980uiro傿Rf[No僫r鉔"尐R汻f[05197210utf[05197500otf[瀃寶06190060lQqQsQ鹼f[ 噀f[N癳麜 O璬f[b06190090L?etf[06191480Ye瞼f[06191500 瓔聥f[N噀妵eYef[07110530駛Il褘Y齎韹f[b07190050FU8{褘07190060 齎E?f瀃駛 07190460梴:g褘07191740齎E朏U誰08110110t焞蟸Nmtf[b08110180閪Het08110410ON匭钀6R08190190ONbeut08190240irAmt08190360 FUpencc榗Hh婳蔛擽(u08190380翄8R昩D峟[08190450坢9€L圍Nf[09110090b_縍N?eV{(5)?e籰f[b0.309110110b_縍N?eV{(7)10110210^JTDdq_/gf[b10110360Indesign(抍Hro忲N 10110540of聣iir10120430Qu樉嫛10130700^:W%10130830瀃ir≧;u10140500 N魚peW[≧;u鶺@x(鷁!j0Pg(?10140520≧+o噀f[橯\O鶺@x10140560 of聣緥鞻梘膲R 10140630黐o鶺@x10140690厤橯瀃10190110Qu槰R;u緥10190390 ONbeuNCISb_a尵嫛10190440of聣鷁Q{N緥絜10190660禰艌緥10190880 q_茐TgyrHe(+T^)10191210 }蟘篘SOII10191220筶;u篘SOII10191230q_茐黐t簨10191330齎;uI10191390peW[諙QX(zbrush/maya)10.010191400Hr;u韹12112390 騠_N\O罷R恎N z?gf[b12114080z?g瀃鯈踁 12190060q_茐ho鶺@x121901405u茐獈U_GrR\O12191060餢PN擭 12191260hVPN(5)12192040 -N齎l蟚l魰踁 12192170 侶巊R顅抍脋踁 12192200銼xQ偒庻N 12460011hVPN1 124600414tnf頞1 12460151餢PN1 12460181 侶廁W,g烺瓔脋1 1247000012470050茐蓧z?g鶺@x12470090q_茐^JTRa13110384f[MRYe瞼f[SO瞼f[b13110386f[MR?Q鍅SO瞼13110388f[MR?Q鍅8nb13110389 |^?QSO瞼侶RN€b誰14290200?Q鍅Lk騠Rf[MRYe瞼f[b14290210T1UNc%c14290220 |^?Q侶RNho14293070 tZ?Q;m≧緥(2)14293260 睳P[鞻剉R鷁Nt14293300 |^?QSO齹瓔脋(2)14293320茘骲S14295210z?gSO蚫2 15100180^僨[b151002004t1 15100220?Q鍅侶R151002405u亷/g15100250 鼅TPg檈緥N6R\O15100510貧駛韹315100530駛韹橯\O15100570駛韹,T汻315100610 駛韹 zNYef[簨115100670pef[ zNYef[簨15100830韹噀 zNYef[簨15100860駛韹鉙韹貧 15100870駛噀f[T莧 慃15100900駛韹韹誰15130010篘{|N>yO15162070f[t^簨噀15191010鶺@x橯\O15191021 韹噀 zNYef[簨1 15191040 -N齎銼鉔噀f[ 2 15191070Y齎噀f[15191130f[N瞼15191180鉙韹z?g15191210噀f[TW匋[麐15192100 pef[ zNYef[簨1 15192140pef[鷁!j15192160pef[込[c黐15192180Y抁SO擽(u€b/g15192310 RI{pe簨+Tt簨梴/g 15192380pef[8^(uo忲N 惒152160003u簨16190130-N;St;Sf[b5311002060210020'Yf[uL€N裇U\N1\NRNc黐( N) L€N裇U\孴1\Nc黐Yexselect * from (select distinct a.kcdm,a.kcmc,a.kkxy,a.xf from (select distinct kcdm,kcmc,kkxy,xf,xn,xq,sum(rs) zrs,bxsjl from ysjxrwb where xn='2014-2015' and xq='1' and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and (rs>0 or rs is not null) group by xn,xq,kcdm,kcmc,kkxy,xf,bxsjl ) a ,(select distinct kcdm,kcmc,kkxy,xf,xn,xq,sum(rs) zrs from jxrwb where xn='2014-2015' and xq='1' and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and jxjhh not like '%cx%' group by xn,xq,kcdm,kcmc,kkxy,xf ) b where a.kcdm=B.kcdm(+) and a.xn=B.xn(+) and a.xq=B.xq(+) and a.xf=b.xf(+) and a.zrs>b.zrs and (a.bxsjl<>'/f' or a.bxsjl is null)) order by kcdm YHdV*#   jd  Is  qp  FV@@pn: 4  n g = U + 1 yuWY)1ywGU#occ 衫 (A",??qI9SAX d褚MbP?_*+€%&殭櫃櫃?'殭櫃櫃?"d??U} } } } $                                                          !   " #   $ %   & '   ( )   * + ,  - . ,  / 0 , 1 2 3 , 1 4 5 ,  6 7 , 8 9 : , 8 ; < ,  = > , 1 ? @ , 1 A B ,  C D ,  E F ,  G H , 1D€ l8888888888888888888888888888888 !"#$%&'()*+,-./0123456789:;<=>? I J ,  !K !L !, ! "M "N ", " #O #P #, #1 $Q $R $, $8 %S %T %, %1 &U &V &, &W 'X 'Y ', '1 (Z ([ (, (W )\ )] ), )1 *^ *_ *, * +` +a +, +1 ,b ,c ,, , -d -e -, -1 .f .g ., .1 /h /i /j /k 0l 0m 0j 0 1n 1o 1j 1W 2p 2q 2j 2W 3r 3s 3j 3W 4t 4u 4j 4W 5v 5w 5j 5W 6x 6y 6j 6 7z 7{ 7j 7 8| 8} 8j 8 9~ 9 9j 9W :€ : :j :1 ; ; ;j ;1 < < <j < = = =j = > > > > ? ? ? ?D€ l8888888888888888888888888888888@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_ @ @ @ @ A A A A8 B B B B C C C C D D D D E E E E F F F F G G G G H H H H I I I I8 J J J J K K K K L L L L M M M M N N N N O O O O P P P P Q Q Q Q R R R R S S S S T T T T U U U U V V V V W W W W X X X X Y Y Y Y Z Z Z Z [ [ [ [ \ \ \ \ ] ] ] ] ^ ^ ^ ^ _ _ _ _D€ l8888888888888888888888888888888`abcdefghijklmnopqrstuvwxyz{|}~ ` ` ` ` a a a a b b b bk c c c ck d d d dk e e e e f f f fW g g g g h h h h i i i i j j j j k k k k l l l l m m m mW n n n nW o o o o p p p pW q q q q r r r rW s s s s t t t t1 u u u uW v v v vW w w w w x x x x y y  y yW z  z  z zW {  { { { | | | |1 } } } }1 ~ ~ ~ ~1    WD€ l8888888888888888888888888888888€ € € € €                   !   " #   $ % & 8 ' ( & 8 ) * & 8 + , & 8 - . &  / 0 & 8 1 2 & 8 3 4 & 8 5  6 1 7 8 6 1 9 : 6  ; < 6  = > 6  ? @ 6 W A B 6  C D 6  E F 6  G H 6  I J 6  K L 6  M N 6  O P 6  Q R 6  S T 6  U V 6 WD€ l8888888888888888888888888888888 W X 6  Y Z 6 W [ \ 6 W ] ^ 6  _ ` 6  a b 6  c d 6  e f 6  g h 6  i j 6  k l 6  m n 6  o p 6  q r s  t    u v w 1$,888888888888888>@7 衫 tY綴 d褚MbP?_*+€%&殭櫃櫃?'殭櫃櫃?"d??U} $  x">@7 ?鄥燆鵒h珣+'迟0h08 HT`KSK-LF@€↙飳合@€↙飳合?胀諟.摋+,0HP X`hpx   SQL ResultsSQL Statement 工作表  !"#$%&'()*+,?./01234?6789:;<???Root Entry F?WorkbookYSummaryInformation(-DocumentSummaryInformation85