ࡱ> [ !)bjbj 4ΐΐ!!D D L $o/////4 @IoKoKoKoKoKoKo$vqtooHHHoo//o!!!H//Io!HIo!!+]{_/i0:!_65oo0oE_6t!tl{_{_ntnLHH!HHHHHoooo!HHHoHHHHtHHHHHHHHHD - q: SQL Queries Create the following Tables: LOCATIONLocation_IDRegional_Group122NEW YORK123DALLAS124CHICAGO167BOSTON DEPARTMENTDepartment_IDNameLocation_ID10ACCOUNTING12220RESEARCH12430SALES12340OPERATIONS167 JOBJob_IDFunction667CLERK668STAFF669ANALYST670SALESPERSON671MANAGER672PRESIDENT EMPLOYEEEMPLOYEE_IDLAST_NAMEFIRST_NAMEMIDDLE_NAMEJOB_IDMANAGER_IDHIREDATESALARYCOMMDEPARTMENT_ID7369SMITHJOHNQ667790217-DEC-84800NULL207499ALLENKEVINJ670769820-FEB-851600300307505DOYLEJEANK671783904-APR-852850NULL307506DENNISLYNNS671783915-MAY-852750NULL307507BAKERLESLIED671783910-JUN-852200NULL407521WARKCYNTHIAD670769822-FEB-85125050030Queries based on the above tables: Simple Queries: List all the employee details List all the department details List all job details List all the locations List out first name,lastname,salary, commission for all employees List out employee_id,lastname,department id for all employees and rename employee id as ID of the employee, last name as Name of the employee, department id as department ID List out the employeesanuual salary with their names only. Where Conditions: List the details about SMITH List out the employees who are working in department 20 List out the employees who are earning salary between 3000 and 4500 List out the employees who are working in department 10 or 20 Find out the employees who are not working in department 10 or 30 List out the employees whose name starts with S List out the employees whose name start with S and end with H List out the employees whose name length is 4 and start with S List out the employees who are working in department 10 and draw the salaries more than 3500 list out the employees who are not receiving commission. Order By Clause: List out the employee id, last name in ascending order based on the employee id. List out the employee id, name in descending order based on salary column list out the employee details according to their last_name in ascending order and salaries in descending order list out the employee details according to their last_name in ascending order and then on department_id in descending order. Group By & Having Clause: How many employees who are working in different departments wise in the organization List out the department wise maximum salary, minimum salary, average salary of the employees List out the job wise maximum salary, minimum salary, average salaries of the employees. List out the department id having atleast four employees. Sub-Queries Display the employee who got the maximum salary. Display the employees who are working in Sales department Display the employees who are working as Clerk. Display the employees who are working in New York Find out no.of employees working in Sales department. Update the employees salaries, who are working as Clerk on the basis of 10%. Delete the employees who are working in accounting department. Display the second highest salary drawing employee details. JOINS Simple join List our employees with their department names Display employees with their designations (jobs) Display the employees with their department name and regional groups. How many employees who are working in different departments and display with department name. How many employees who are working in sales department. Which is the department having greater than or equal to 5 employees and display the department names in ascending order. How many jobs in the organization with designations. How many employees working in New York. Self Join: Display the employee details with their manager names. Display the employee details who earn more than their managers salaries. Show the no. of employees working under every manager. Outer Join: Display employee details with all departments. Display all employees in sales or operation departments. Answers SQL > Select * from employee; SQL > Select * from department; SQL > Select * from job; SQL > Select * from loc; SQL > Select first_name, last_name, salary, commission from employee; SQL > Select employee_id id of the employee, last_name name", department id as department id from employee; SQL > Select last_name, salary*12 annual salary from employee SQL > Select * from employee where last_name=SMITH; SQL > Select * from employee where department_id=20 SQL > Select * from employee where salary between 3000 and 4500 SQL > Select * from employee where department_id in (20,30) SQL > Select last_name, salary, commission, department_id from employee where department_id not in (10,30) SQL > Select * from employee where last_name like S% SQL > Select * from employee where last_name like S%H SQL > Select * from employee where last_name like S___ SQL > Select * from employee where department_id=10 and salary>3500 SQL > Select * from employee where commission is Null SQL > Select employee_id, last_name from employee order by employee_id SQL > Select employee_id, last_name, salary from employee order by salary desc SQL > Select employee_id, last_name, salary from employee order by last_name, salary desc SQL > Select employee_id, last_name, salary from employee order by last_name, department_iddesc SQL > Select department_id, count(*), from employee group by department_id SQL > Select department_id, count(*), max(salary), min(salary), avg(salary) from employee group by department_id SQL > Select job_id, count(*), max(salary), min(salary), avg(salary) from employee group by job_id SQL > Select department_id, count(*) from employee group by department_id having count(*)>=4 SQL > Select * from employee where salary=(select max(salary) from employee) SQL > Select * from employee where department_id IN (select department_id from department where name=SALES) SQL > Select * from employee where job_id in (select job_id from job where function=CLERK SQL > Select * from employee where department_id=(select department_id from department where location_id=(select location_id from location where regional_group=New York)) SQL > Select * from employee where department_id=(select department_id from department where name=SALES group by department_id) SQL > Update employee set salary=salary*10/100 wehrejob_id=(select job_id from job where function=CLERK) SQL > delete from employee where department_id=(select department_id from department where name=ACCOUNTING) SQL > Select * from employee where salary=(select max(salary) from employee where salary <(select max(salary) from employee)) SQL > Select employee_id, last_name, name from employee e, department d where e.department_id=d.department_id SQL > Select employee_id, last_name, function from employee e, job j where e.job_id=j.job_id SQL > Select employee_id, last_name, name, regional_group from employee e, department d, location l where e.department_id=d.department_id and d.location_id=l.location_id SQL > Select name, count(*) from employee e, department d where d.department_id=e.department_id group by name SQL > Select name, count(*) from employee e, department d where d.department_id=e.department_id group by name having name=SALES SQL > Select name, count(*) from employee e, department d where d.department_id=e.department_id group by name having count (*)>=5 order by name SQL > Select function, count(*) from employee e, job j where j.job_id=e.job_id group by function SQL > Select regional_group, count(*) from employee e, department d, location l where e.department_id=d.department_id and d.location_id=l.location_id and regional_group=NEW YORK group by regional_group SQL > Select e.last_nameemp_name, m.last_name, mgr_name from employee e, employee m where e.manager_id=m.employee_id SQL > Select e.last_nameemp_name, e.salaryemp_salary, m.last_name, mgr_name, m.salarymgr_salary from employee e, employee m where e.manager_id=m.employee_id and m.salary SQL > Select m.manager_id, count(*) from employee e, employee m where e.emSployee_id=m.manager_id group by m.manager_id SQL > Select last_name, d.department_id, d.name from employee e, department d where e.department_id(+)=d.department_id SQL > Select last_name, d.department_id, d.name from employee e, department d where e.department_id(+)=d.department_id and d.department_idin (select department_id from department where name IN (SALES,OPERATIONS))   )+35@AOQTU]_bciknovx{|         ¶¶¶¶¶¶¶¶¶¶¶¶¶¶¶¶¶¶¶¶¶¶¶h7CJOJQJaJh7h75CJOJQJ\aJh75B* OJQJ\phh7B*phfff%h75B*CJ8OJQJ\aJ8phH  *+45APBkd$$If4622 l4af4 $$Ifa$d-DM gd7$d-DM a$gd7PQU^_cjPRkd$$If0CC622 l4a $$Ifa$Rkds$$If0CC622 l4ajkowx|PRkdb$$If0CC622 l4a $$Ifa$Rkd$$If0CC622 l4aPBkd$$If4=622 l4af4 $$Ifa$d-DM gd7Rkd$$If0CC622 l4a $$Ifa$ekd$$IfFKCC6    22 l4a $$Ifa$ekd$$IfFKCC6    22 l4a $$Ifa$ekd$$IfFKCC6    22 l4a $$Ifa$ekd>$$IfFKCC6    22 l4a =Bkd$$If4&622 l4af4 $$Ifa$d-DM gd7ekd$$IfFKCC6    22 l4a      # PRkd$$If0C622 l4aRkd$$If0C622 l4a $$Ifa$ " $ ' ( / 1 4 5 @ B E F M O R S \ ^ ` h i j u v         ʾʾʾʾʾʾʾʾʾʾʺʾʾʾʾʾʾʾʾʾʺʾʾʾhhhoOCJOJQJaJhoOhoO;CJOJQJaJhoO;CJOJQJaJh7B*phfffh7h7CJOJQJaJI# $ ( 0 1 5 A PRkd" $$If0C622 l4a $$Ifa$Rkdu $$If0C622 l4aA B F N O S ] PRkd| $$If0C622 l4a $$Ifa$Rkd $$If0C622 l4a] ^ _ ` i j ~2Kkd $$If4 6u6 6#u622 l4af4yth$$$#&#$/If[$\$a$gdoOd-DM gd7Rkd) $$If0C622 l4aj v $$#&#$/If]a$gdoOFf$$#&#$/Ifa$gdoO kd$$If  z(%`)- 6<&88 6#u6((((2 2 l4ayth         $$#&#$/Ifa$gdoO kd'$$If  z(%`)- 6<&88 6#u6((((2 2 l4ayth     ! & 0 5 9 < $$#&#$/Ifa$gdoO   ! % & / 0 4 5 8 9 ; < = A B G H L M N O R S W X a b f g k l n o p t u { |   hhhoOCJOJQJaJhoO]< = kd$$If  z(%`)- 6<&88 6#u6((((2 2 l4ayth= B H M O S X b g l o $$#&#$/Ifa$gdoO o p kd$$If  z(%`)- 6<&88 6#u6((((2 2 l4aythp u | $$#&#$/Ifa$gdoO kdt$$If  z(%`)- 6<&88 6#u6((((2 2 l4ayth $$#&#$/Ifa$gdoO kd$$If  z(%`)- 6<&88 6#u6((((2 2 l4ayth  $$#&#$/Ifa$gdoO   / 1 @ B _ ` a    V W X Y  տտhhB*CJaJphfffhhhhB*CJaJphfff%hhh7B*CJOJQJaJphfffhhh7B*CJaJphfff+hhh75B*CJOJQJ\aJphh7B*phfffh75B* OJQJ\phhhhoOhoOCJOJQJaJ3 kdR$$If  z(%`)- 6<&88 6#u6((((2 2 l4ayth 0 1 A B ` a !gdhd-DM ^gdh & Fd-DM gd7d-DM gd7   W X Y !ST!gdhd-DM ^gdh & Fd-DM gd7d-DM gd7 !RST89:stvͽݽͪݽͽݚͪwaRݽͪݽhph7B*CJaJphfff+hph75B*CJOJQJ\aJphhhB*phfffh7B*phfff%hph7B*CJOJQJaJphfffhpB*CJOJQJaJphfff%hhhhB*CJOJQJaJphfffhhB*CJOJQJaJphfffh7B*CJOJQJaJphfff%hhh7B*CJOJQJaJphfffhhhhB*CJaJphfff 9:stuv&d-DM gd7 & Fd-DM gdpd-DM ^gdhhd-DM ^hgdp & Fd-DM gdh./0=>?xyz{znzznz[z%hh7B*CJOJQJaJphfffhpB*CJaJphfffhphpB*CJaJphfff%hph7B*CJOJQJaJphfffhph7B*CJaJphfff+hph75B*CJOJQJ\aJphh7B*phfff%hhhpB*CJOJQJaJphfffh7B*CJOJQJaJphfff%hhh7B*CJOJQJaJphfff/0>?yz{!gd & Fd-DM gd!gdpd-DM ^gdp & Fd-DM gd7d-DM gd7'()\]^_%&'bcdefglmɶɶɶɶɶxܶp\E,h76;B*CJOJQJ]^JaJph333&h7;B*CJOJQJ^JaJphh7B*phfffh7B*CJOJQJaJphfffhphpB*CJaJphfffhpB*CJaJphfff%hhpB*CJOJQJaJphfff%hh7B*CJOJQJaJphfff%hph7B*CJOJQJaJphfff%hhB*CJOJQJaJphfffhB*CJOJQJaJphfff()]^_&'cdef!gd & F d-DM ^`gd{Bd-DM ^gdp!gdp & Fd-DM gdd-DM ^gdfgmyz ~/dd-DM gdB4d-DM ^gdB4 & F d-DM ^`gd{B!$d<&d-DM P[$\$gd7d-DM gd7mxz)*BC9:op 23vwBCѾ䯟||||||||||||||||||||h7B*CJOJQJaJphfff%h75B* CJ$OJQJ\aJ$phh7B*CJOJQJaJphfffh75B* OJQJ\ph%hB4h7B*CJOJQJaJphfff%h{Bh7B*CJOJQJaJphfffh7B*phfff%h75B*CJOJQJ\aJph0R^_* & Fdxx-DM gd7$d-DM a$gd7d-DM gd7d-DM ^gdcd-DM gdB4 & F d-DM ^`gdB4*C:p 3wCHy4=  & Fdxx-DM gd7GHxy34< = )!*!!!""""""####{$|$ % %l%m%8&9&&&W'X'''''F(G() )!)h7hh7BB*CJOJQJaJphfffh7B*CJOJQJaJphfffh7B*phfff8= *!!""""##|$ %m%9&&X''G( )!)dxx-DM ^gd{B & Fdxx-DM gd721h:ph/ =!"#$% q$$If!vh5&#v&:V 46,5/ 22 l4 f4$$If!vh5C5#vC#v:V 6,5C/ / / /  22 l4 $$If!vh5C5#vC#v:V 6,5C/ / / /  22 l4 $$If!vh5C5#vC#v:V 6,5C/ / / /  22 l4 $$If!vh5C5#vC#v:V 6,5C/ / / /  22 l4 $$If!vh5C5#vC#v:V 6,5C/ / / /  22 l4 q$$If!vh5=#v=:V 46,5=/ 22 l4 f4$$If!vh55C5C#v#vC:V 6,55C/ / / /  22 l4 $$If!vh55C5C#v#vC:V 6,55C/ / / /  22 l4 $$If!vh55C5C#v#vC:V 6,55C/ / / /  22 l4 $$If!vh55C5C#v#vC:V 6,55C/ / / /  22 l4 $$If!vh55C5C#v#vC:V 6,55C/ / / /  22 l4 q$$If!vh5&#v&:V 46,5&/ 22 l4 f4$$If!vh5C5#vC#v:V 6,5C5/ / / /  22 l4 $$If!vh5C5#vC#v:V 6,5C5/ / / /  22 l4 $$If!vh5C5#vC#v:V 6,5C5/ / / /  22 l4 $$If!vh5C5#vC#v:V 6,5C5/ / / /  22 l4 $$If!vh5C5#vC#v:V 6,5C5/ / / /  22 l4 $$If!vh5C5#vC#v:V 6,5C5/ / / /  22 l4 $$If!vh5C5#vC#v:V 6,5C5/ / / /  22 l4 $$If!vh5u6#vu6:V 4 6#u6,5u6/ 22 l4 f4ythq$$If!v h5<555&5855585 5 #v<#v#v#v&#v8#v#v#v8#v #v :V ? 6#u6, 5<555&5855585 5 / /  / /  2 2 l4 ythkd[ $$If?  z(%`)- 6<&88 6#u6((((2 2 l4aythm$$If!v h5<555&5855585 5 #v<#v#v#v&#v8#v#v#v8#v #v :V 6#u6, 5<555&5855585 5 / /  / /  2 2 l4 ythm$$If!v h5<555&5855585 5 #v<#v#v#v&#v8#v#v#v8#v #v :V 6#u6, 5<555&5855585 5 / /  / /  2 2 l4 ythm$$If!v h5<555&5855585 5 #v<#v#v#v&#v8#v#v#v8#v #v :V 6#u6, 5<555&5855585 5 / /  / /  2 2 l4 ythm$$If!v h5<555&5855585 5 #v<#v#v#v&#v8#v#v#v8#v #v :V 6#u6, 5<555&5855585 5 / /  / /  2 2 l4 ythm$$If!v h5<555&5855585 5 #v<#v#v#v&#v8#v#v#v8#v #v :V 6#u6, 5<555&5855585 5 / /  / /  2 2 l4 ythm$$If!v h5<555&5855585 5 #v<#v#v#v&#v8#v#v#v8#v #v :V 6#u6, 5<555&5855585 5 / /  / /  2 2 l4 ythm$$If!v h5<555&5855585 5 #v<#v#v#v&#v8#v#v#v8#v #v :V 6#u6, 5<555&5855585 5 / /  / /  2 2 l4 yth^" 2 0@P`p2( 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p8XV~_HmH nH sH tH @`@ NormalCJ_HaJmH sH tH R@R 7 Heading 1dd@&[$\$5CJ0KH$\aJ0N@"N 7 Heading 2dd@&[$\$5CJ$\aJ$N2N 7 Heading 3dd@&[$\$5CJ\aJFBF 7 Heading 4dd@&[$\$5\DA D Default Paragraph FontRi@R 0 Table Normal4 l4a (k ( 0No List ,, 7 post-icons.. 7 post-labelsBB 7apple-converted-space6U!6 7 Hyperlink >*B*phFV1F 7FollowedHyperlink >*B*phB^BB 7 Normal (Web)dd[$\$*WQ* 7Strong5\\\\7 z-Top of FormPa$<CJOJQJ^JaJb]b7z-Bottom of FormNa$<CJOJQJ^JaJ22 7 post-locationFF 7comment-footerdd[$\$>> 7widget-item-control"" 7zippy,, 7 post-count:: 7zippy toggle-open44 7at_pinitbutton66 7meta_categoriesDD 7share-button-link-text@@@ h List Paragraph !^m$PK![Content_Types].xmlj0Eжr(΢Iw},-j4 wP-t#bΙ{UTU^hd}㨫)*1P' ^W0)T9<l#$yi};~@(Hu* Dנz/0ǰ $ X3aZ,D0j~3߶b~i>3\`?/[G\!-Rk.sԻ..a濭?PK!֧6 _rels/.relsj0 }Q%v/C/}(h"O = C?hv=Ʌ%[xp{۵_Pѣ<1H0ORBdJE4b$q_6LR7`0̞O,En7Lib/SeеPK!kytheme/theme/themeManager.xml M @}w7c(EbˮCAǠҟ7՛K Y, e.|,H,lxɴIsQ}#Ր ֵ+!,^$j=GW)E+& 8PK!%ӺXtheme/theme/theme1.xmlYo6 $A–fkۡGڦ-6dtR(0u+ö-Kdu=RL9CE}{H굇!pH5mhI4mwBݶG8M{}m[`Դg;"A3bW$NB1 :!-VJ%"VBp{k2!#l K{wK1L4hf!ò@ib!ڴq|<mQ8h%gwNfD[Ů'2`|X}&aީ㸎K囸nuܟFrQ}FfX4:ղWW78\%(l{=%(ŻxǩU|GKP6R4DUhs${FxuzJ|ِ.$qRId Of(&'ӀnFi6D%dƛ3b?uɓ_N>=ysHCTz?wo}e3Of ,7_Ջ7| V*|@B̬غ009&f1Q-Zє^ <7"K@DL~91x i;NQ!R0hq= $f[FjieGBDՎi|#aU j ?T u4(4G<0/2b[1fds+*IbN]:2sűć~™ 'Qb?b0Eu;&A y@t#XKjpS <1:_ Rj@5It|=\pTeVBkfoMُ1A6Yދ{qm=_$TZl|[Bi/(gr͠{(gY?J44AJb A?@3غmd2SfbGFl-tY.e* U{SW[rTwP:IT $jF$yHȑ]E]_jP˳# TMū(<^fW&"3- (wl2\O.jgȴFBn: YX8,45׍UJ5z"Y,8on]h*U]2#4k8psM-S5Iϣ,bAp):Ģ$lbyh$5Dr+W@.-e#Iד' [i~~~0>tA0ZYpL|)$ jLvorUUS|cum,nmW x?C=CAP:Ө ƛ2,4;kkrP;KPT[][^#A*?حZh,2B^@<:!wN9˃/$lyȳyBrJu[pNPw[Bu[.uڕPXxޤ"=7({ڕQcyCR JݠmJ#kTmШzӮ.t !!    m!) )268:=@Pj # A ] j < = o p f*= !)!"#$%&'(*+,-./0134579;<>?AL# AA@0(  B S  ?_GoBack#!#!5@AOW`a h h m PZ\e]f-6LYn{&Vc >BP[]f :GUb)6XeW]io !/`mvKXan$/1:etu L[\kp}~:IJYIQRZz*8FY[fhp 0<=JOWeq$ 3 7 F T ] _ n #!:>|~ " #!)L`s!>x*4d. \r$ 6Zk?t8oHr3o%Z^,q,*X /G-4&v,M͘ ] OD\0GU]]Ha5%;gpM: i$"-0akz;=o9 {vehCt}Li^`.^`.pp^p`.@ @ ^@ `.^`.^`.^`.^`.PP^P`.^`CJOJQJo(^`CJOJQJo(opp^p`CJOJQJo(@ @ ^@ `CJOJQJo(^`CJOJQJo(^`CJOJQJo(^`CJOJQJo(^`CJOJQJo(PP^P`CJOJQJo(^`CJOJQJo(^`CJOJQJo(opp^p`CJOJQJo(@ @ ^@ `CJOJQJo(^`CJOJQJo(^`CJOJQJo(^`CJOJQJo(^`CJOJQJo(PP^P`CJOJQJo(^`CJOJQJo(^`CJOJQJo(opp^p`CJOJQJo(@ @ ^@ `CJOJQJo(^`CJOJQJo(^`CJOJQJo(^`CJOJQJo(^`CJOJQJo(PP^P`CJOJQJo(^`CJOJQJo(^`CJOJQJo(opp^p`CJOJQJo(@ @ ^@ `CJOJQJo(^`CJOJQJo(^`CJOJQJo(^`CJOJQJo(^`CJOJQJo(PP^P`CJOJQJo(^`CJOJQJo(^`CJOJQJo(opp^p`CJOJQJo(@ @ ^@ `CJOJQJo(^`CJOJQJo(^`CJOJQJo(^`CJOJQJo(^`CJOJQJo(PP^P`CJOJQJo(^`CJOJQJo(^`CJOJQJo(opp^p`CJOJQJo(@ @ ^@ `CJOJQJo(^`CJOJQJo(^`CJOJQJo(^`CJOJQJo(^`CJOJQJo(PP^P`CJOJQJo(^`CJOJQJo(^`CJOJQJo(opp^p`CJOJQJo(@ @ ^@ `CJOJQJo(^`CJOJQJo(^`CJOJQJo(^`CJOJQJo(^`CJOJQJo(PP^P`CJOJQJo(^`CJOJQJo(^`CJOJQJo(opp^p`CJOJQJo(@ @ ^@ `CJOJQJo(^`CJOJQJo(^`CJOJQJo(^`CJOJQJo(^`CJOJQJo(PP^P`CJOJQJo(^`.^`.pp^p`.@ @ ^@ `.^`.^`.^`.^`.PP^P`.^`CJOJQJo(^`CJOJQJo(opp^p`CJOJQJo(@ @ ^@ `CJOJQJo(^`CJOJQJo(^`CJOJQJo(^`CJOJQJo(^`CJOJQJo(PP^P`CJOJQJo(^`CJOJQJo(^`CJOJQJo(opp^p`CJOJQJo(@ @ ^@ `CJOJQJo(^`CJOJQJo(^`CJOJQJo(^`CJOJQJo(^`CJOJQJo(PP^P`CJOJQJo("^`.^`.pp^p`.@ @ ^@ `.^`.^`.^`.^`.PP^P`.^`.^`.pp^p`.@ @ ^@ `.^`.^`.^`.^`.PP^P`.^`CJOJQJo(^`CJOJQJo(opp^p`CJOJQJo(@ @ ^@ `CJOJQJo(^`CJOJQJo(^`CJOJQJo(^`CJOJQJo(^`CJOJQJo(PP^P`CJOJQJo(hh^h`.^`.pp^p`.@ @ ^@ `.^`.^`.^`.^`.PP^P`.^`CJOJQJo(^`CJOJQJo(opp^p`CJOJQJo(@ @ ^@ `CJOJQJo(^`CJOJQJo(^`CJOJQJo(^`CJOJQJo(^`CJOJQJo(PP^P`CJOJQJo(^`CJOJQJo(^`CJOJQJo(opp^p`CJOJQJo(@ @ ^@ `CJOJQJo(^`CJOJQJo(^`CJOJQJo(^`CJOJQJo(^`CJOJQJo(PP^P`CJOJQJo(^`CJOJQJo(^`CJOJQJo(opp^p`CJOJQJo(@ @ ^@ `CJOJQJo(^`CJOJQJo(^`CJOJQJo(^`CJOJQJo(^`CJOJQJo(PP^P`CJOJQJo(^`CJOJQJo(^`CJOJQJo(opp^p`CJOJQJo(@ @ ^@ `CJOJQJo(^`CJOJQJo(^`CJOJQJo(^`CJOJQJo(^`CJOJQJo(PP^P`CJOJQJo(+^`.^`.pp^p`.@ @ ^@ `.^`.^`.^`.^`.PP^P`.^`CJOJQJo(^`CJOJQJo(opp^p`CJOJQJo(@ @ ^@ `CJOJQJo(^`CJOJQJo(^`CJOJQJo(^`CJOJQJo(^`CJOJQJo(PP^P`CJOJQJo(^`CJOJQJo(^`CJOJQJo(opp^p`CJOJQJo(@ @ ^@ `CJOJQJo(^`CJOJQJo(^`CJOJQJo(^`CJOJQJo(^`CJOJQJo(PP^P`CJOJQJo(^`.^`.pp^p`.@ @ ^@ `.^`.^`.^`.^`.PP^P`.)0GUHt}G--0ak,M\r$ {va;=o%Z^,] OoM: it. *4s6Zq,;g]]>M@p{.V}@W%_',1U&L1U%J{-D KN1U$V}@Wx7V}@WB%^V}@WrBV}@WRntlfQt%kbUV}@WczV?j$h?% "@j$h$j@L&@F'A60AV}@W9oCARv{AV}@WJCBL&qBb  JYDbUD%-D,avdaE,*HV}@W7H1U I%2XI_'FJV}@WZJV}@W) J%[KN84Kj$h $5MrzNV}@Wa+NL&0,NV}@W"NV}@WcOlu*v.wPAUh{UPiC^UV}@W1Uc=bUj@j{V;H k"W_'xV}@WKkoWIW;H kW~|W%#W%-2X;H k\WXV}@WC6ZV}@WCjZ%U[1Uhu [V}@WSA]B2"/r]V}@WC ]znh^;H kiC^s983K (^;H kyab _a JYD2aV}@WiaV}@W/bR[r#CbV}@Wcx(1H0dV}@WI!f/mY9fV}@Wg#gV}@W'g;H kj$hM~8AUhJ{~iAUh Wi[KfaiV}@W;H k1U+.nk%'*k%Kk@F'A`kV}@WVM4l%ntlAUh$|P`m1UO?@ABDEFGHIJKLMNOPRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~Root Entry Fƴ0Data C1TableQuWordDocument4SummaryInformation(DocumentSummaryInformation8CompObjy  F'Microsoft Office Word 97-2003 Document MSWordDocWord.Document.89q