Rar!ϐs 9ut 6]e"z=3 chapter 9\9-12.sql  /dx?PA44BAZևRḷ3_V- *e2B^2~RaŞdtQZ±J~7U,J I=t@t 6$=3 chapter 9\9-13.sql  LP'/F DnQ7\ԅF weU* eL`$<,/yՠ񃵀:w87L@-!P#?}MIcWYl{gw L+t 6E= =0 chapter 9\9-14.sqlDBCC SHOWCONTIG (student) GO ot 6[[ԤfŶ=0 chapter 9\9-15.sqlCREATE INDEX IX_Student_Name ON Student(studentName) WITH FILLFACTOR=70,DROP_EXISTING GOt 6::K^2=0 chapter 9\9-16.sqlALTER INDEX IX_Student_classID ON Student REORGANIZE GO(t 655cb=0 chapter 9\9-17.sqlALTER INDEX IX_Class_MonitorID ON Class REBUILD GOTt 6//,r=0 chapter 9\9-18.sqlDBCC SHOW_STATISTICS ( Student,PK_Student ) GOUt 7z*s =3 chapter 10\10-1.sql U {#TF:G20QBa1`X!+Xu,t:db%23}93=uZի^>G5'YѹJ5&' qݙ6"yܻ|ט҇#*uJ|6{J-tA =XüxvX߻G^٭{Wοrz-"g@5㣰D`a'cfg{KtS(ˠ}Hh>Y\RL;` -g;o!KY ESI+^v{<>6vl={wk]Q\7UYUMa*iAjOin"PЗ"/FW$ !BžZ+/f;w qe)IL!6ػ7@ `WN<DbBaن㟟NE|')ҀD,ISG@t 8\goz =3 chapter 10\10-11.sql ULՁ;#.6R1h (R_ .LjRRģ btVY,hO{;Gϖ`GEU[!~6n,9a߷//" Ɩ C2V0IO(j̷.z06Qo(=<>6gvIF{H[+Ctn׳8 o=@DH \Ҹh pz=79t 8OOd2y =0 chapter 10\10-12.sql--10-12ɾͼview_student use sgms go drop view view_student go t 8__v˟gA =0 chapter 10\10-16.sql--10-16 10-1 ͼgirl_viewִвѯ use SGMS go select * from girl_view t 8{FC =3 chapter 10\10-17.sql YP|:qSKZ.u\r3_hMM49:(gqt[B$QSf(_Nss!}{<\RE8t:>+pQ5Idүܞ.I5nvYRJ~L"N<,hJGC^@@&3AU-w+Y!5a0q9Nz>]^v[mz zӻy<#3gP kܸ?9y m;-Yf LY)4v/0K dP)T*)኏ە$Ac I)U$o=[څƥmOs-]Uy<@st 8tKuE =3 chapter 10\10-19.sql Lt̒sKWvۅAG!piDpG$.rPA $eG;yNs9yM8ӧW>;_qqo,S'p ^f0smf޴@}.5Q }+@ #` -`$SdT2TɮJR ts짤#Y[6ؿ9~?:2޿Z/唶t 7=nGnu =3 chapter 10\10-2.sql QL{#RcЋLzXK]VV+ȅ O]lGCFFFrLfOȿ3FId2$AV 5CN6Ĉ+^\5[[C{@ W/+ߦ+ޭ6nj׽vkڧ!@3k<1с_ %XbX RfPFpB#'{sD thx>3@ߒ)CO5'C<2U}ܧR8tLe4Pp#[1!8TaIFa(y8t 8Zz =3 chapter 10\10-20.sql Uwп햂?t5|ʅKFEGd'к(JFofw ϢΝهts IKDž0a $@Y؆>Q04o])r0S-i69KBË&.;ᔉ?WNQt 7ufȖu =3 chapter 10\10-3.sql ٕP|jE-ΦH+bcUƜ5ŴND QաT ծ4s,|+<9;ϐp9p=φ5eNk5jo:zowfMnI%.C珛ps|ϙgŏ 7dʣs7Rzv)Wɩb6a0hҕU;ߒJoާ\ߢ .#FI2(3ZD1 M̡Z@N#N[`Zf)E}xYZ"&bB<y"i30)@̍"l%Ӵ]y%Xf~ĩx%lTQIo_h+t 7;}v =3 chapter 10\10-4.sql QLzTb(;nBN{c(N+|qAAnj#[*XK%{VAGӜs090=ѳevxtWoٯvVR6vFN]Wttg^Wd1,KuqTe*8G!@ I`yH|@P4a!LHP"FK 4d }+8UWu^CwtU՗U_xRIaui`|/n޾߫wwb٪oϋ.đsގy?H FLpf?OLgW8^/8ϩC'_Eܱ@-Rh X]p% ] Z+q+AN^#h9^!dN&W RU~aF / zk+kjO@O(ʥfR`kϴ!U@]:QY5hp*d4~@t 8nHIyc =3 chapter 11\11-10.sql Q ̽t"V܎xTB89Sn_Uk kBD!# *ZQ^}מny/|#*Fw.Ie 5l1Zϣq7K?ݝK?@v<{<}>qJ(MUk\jI[c.osշ#(H@LpɓfbjCQ$>+oZ}t1*ps0kgOz BH~U#pKBs9/.A㑞%,ܳ50uKE!zֆ=B%:#[v 8*vG=mp!;"JW0 ;2IMDCų%x7,%++w8pӄ&]Bš|U^+1b)1=@!6jM}w/hv0?qDP 11@|mۏdŷqm6A%;kgy 7t 8d =3 chapter 11\11-11.sql YLz I"РA#ƃldT~:sTZR ʗ{ppp:F}9Þ{><0?~z(wiG8cυ|{/4D9ϿPx{;t[1{1-6RBFVˋiyB2 XTG&L۴iL䐪ۓ^qyeuRB _ja,Ĺ`O8y06@3t 8NNL=bd =0 chapter 11\11-12.sql--11-12 ɾ11-1Ĵ洢Proc_kc use SGMS go drop proc proc_kc=t 8jCse =3 chapter 11\11-13.sql Q=od܋1433L8I3#fn٨"G(#QAv^axo*ޯz=W~*^*~g[R#-$Cu)ޅ.f~ݪT..j[Vݳ6u~^5,y*Ms,P W=] ? W& EZV[2 X^T\q2 $|xHQ>Rz$:gQSi#|. FPuPTh'>F(6:퇓4L1y\E}-nCjd Oxt8{\7WIRzfk!! -8 %U¥ H}ӘHnad'`jRի+'%o#} \O8oF'(TݽwaI?D4t 8ie =3 chapter 11\11-14.sqlQL=7/TY tGD*RM ȒJ?ZJ(0ݲoUۺ1*>ꠈ( vw17wgdϏw3'sa> ez 21f8U[? ee|sj-W&WԵŕTD/,Ȟ/18ףqA3C8eⷻi m0,I:<qqPKǖtNbʝtnHD SǍfZܵ\´|RrD˚hg'^cwȼ賠&n޽nuhDV4yvwS"(ȸ0Y")=@o ܃sO\1 fN,TY8Y %q!{[NZb/p~ 8pj0!c!x l Z®eDuQ6^hd -x?@t 8iVUXf =3 chapter 11\11-15.sql ݑPW =- T]]Eu>;T6t7u/V4i٦V Z!.ˢH$14wgs9fg>ώfVBPI9Zjz*6z} 5wy'u_i};۝ԫ<@ ZAg厾;mX_Ե1R ș @ 3NCM28hf%6dbXwUNpUZ6ȣĴ1ۢ׽bh,Ղ>2dInb" B(m9hUW82(Œ01:6Vl!~= (w_G;ñT夹G;K1,IhKt 8s̖f =3 chapter 11\11-16.sql U Ձ{#B"51#ʗ l N EcҒ {'4Uw |v9  l_\/KU+1I0Xe?BnMHt 8b f =3 chapter 11\11-17.sql  +9>J=OCW{&w;;}o{[gM]j^%n)1 z|'Ď߫}/Erkݷ|rnbʬ83Xھ!ۮ\_k7F<߻d}շ]˖=m_-MQA\;i?Xڤ3`ӽ͆Jl2*Ű2[30դK4A?fv"GsUH6YM((8.pHڭ&@!<*167ȧ`(4BFxK Hvf҅!a6X 3id2я0q^㡜vBHy6wA:5Vg12X#SOX嚿><;ɪf2bԚ]y/ [mt 77pUK =3 chapter 11\11-2.sql QLՁzjXAM(A #d삾:]Dn`N]DI;Iolss/AGDwߏ =]wpipl'Y{vr2zMh Zxڙr4gSC !/je؛dk!fmdUɟ~őB"qU|rMuɆ~D%X*gԎ K4)'W"2GS>~]<{r>Ȅt 8b\, n =3 chapter 11\11-20.sql {JsFsrJq8NaDpH"Tny< 2um_ @;%M)J7sw7st93 l\;g=,$7Ae!81Y6YPr-^+ӗ.P3 ?\"G7Āt tyF>"4z|yl|ɺ-PҦŎ1T u[)*7? %Ae2AQb6@i'X$OQʹⲫ^8-XiS^ZTb5o$ Z| *e]OxL:72;x,<4Giל-qvUd1EW=˶3xga Ē$<eJ?kFN N6c(Q c=2IdjoĿ`asMAɓ@}hv:;Nf@ft 8qq/ai =0 chapter 11\11-21.sql--11-21 ޸Ĵtr_ins_courseƸΪtri_insert_c use SGMS go sp_rename tr_ins_course,tri_insert_C goRAt 8]d0j =3 chapter 11\11-22.sql =wG72F:G@Ҥ)/#ӡ+Rs2rǀWK"ֺH KkѶO~߸g;t!j =0 chapter 11\11-23.sql--11-23 ɾstudentϽĴtri_del_student use SGMS go drop trigger tri_del_student go˝t 8i 0Ǡͻyw߁y;c.^pt;ݸ\ets*61jU^,tR+;z[|C"UTm $ E, tul$qd,*m(v$`&c%Dґ(4)㟊&JKi5 XA4hnisN2lJ`Yg](/P@E$ ? j5=t 7&2M =3 chapter 11\11-4.sqlU wоP 1 BE MfHթY_Y4LmI,,BFY K7tRh-(ƒqıbI Ig{w9{<"<<%Fwկ?V_׽ú.pxaJʮJq_#nkow=0Ux*tɕ߅)[>NRws WH*U@Xj6 i[ %1_jWNt'KPDzf@ɭNdP d&Jً=ԁi3\)a6J%ꖊ]=.&os{< s2{UiNdD )QQdItN%Xl)yihɗ*P؋0AdNVm&1 ~gP]mcqh"Mr0 `d2ŰB#Efq ىA !V&3PnANyV4cG]Tt 7+lV8*M =3 chapter 11\11-5.sql U z\h]#/S$̲l!WWKt"Q+4QE].e̦[XU3>|ޟ~׷r\@swI9>$?-_ۯ ԎTs723)kS='tuqޙ߷k"nYT 5V ક[ `baKY[/GZ+IRF?bc `aCBxb[AV#'ő,)=r @Ok`U @et 7V\N =3 chapter 11\11-6.sql LՀ#nHJI@:bEB('#m?6IAP$N*I(:".%iC ;(?U&xР9:X7g_71ѺkT רV|)XEVto,'o.|'ﱕx+Řp+\X𕺻P߬.ƕ4JhgQa3C6Bт/G铭?-Uz*&h=DjDCO%St8~t 7RRhR[ =0 chapter 11\11-7.sql--11-7 ִд洢Proc_kcʾпγ̵Ϣ use SGMS go exec proc_kc)t 7?W_\ =0 chapter 11\11-8.sql/*11-8 ִдһĴ洢Proc_S_G_C ʾijضγ̵ijɼϢProc_S_G_C */ use SGMS go exec Proc_S_G_C @courseID='100000'7]t 7@ =] =3 chapter 11\11-9.sqlLՁz_l% Ku]H!Aڐ)$tYHR[JŽj7DAtBK){+0>f`aÚ9 0̂P17wl,~?'XY Fǻqopں@_~*GG|O}geF+Ȓ)!ltBԊƕN|OpN?5_eyT&lN "% QWByzzoٟgMK;Xia'=v6܋ D/KcrfE t 8u-<3 chapter 12\1.ssmssln  .<("KZ$ h7ox6OCtG <73?fg$ϏpĬYht&:䑾59 ICa[>ɳ\u(/ 1ߟ0ECh`ɷr#S(?߽Py@t ;tt0KMW'<0 chapter 12\SQLQuer9.sql--12-19¼˺cheng4ӵSGMSݿУ --ݿûΪcheng44 sp_grantdbaccess 'C6003\cheng4','cheng44't <pp4*Ԁ-<0 chapter 12\SQLQuery1.sql--12-8ʹT-SQL䴴SQL Server¼ --˺JohnΪAbc123 create login John with password ='Abc123' ˽t =JJ ؀-<0 chapter 12\SQLQuery10.sql--12-21 ʹT-SQLɾԶݿɫrole2 sp_droprole 'role2' ]t =ss٫؀-<0 chapter 12\SQLQuery11.sql--12-23ݿûRose1Grade --SelectupdateȨ Use SGMS Grant select ,update on Grade to Rose1 ͂t =BLA؀-<0 chapter 12\SQLQuery12.sql--12-24ݿûRose1John1SGMSݿ --еcreate viewcreate tableȨ Use SGMS grant create view,create table to Rose1,John1T_t =ZZ؀؀-<0 chapter 12\SQLQuery13.sql--12-25 ջRose1GradeSelectȨ Use SGMS Revoke select on Grade from Rose1 t =llUـ-<0 chapter 12\SQLQuery14.sql--12-26 ջrose1create viewcreate tableȨ Use SGMS Revoke create view,create table from Rose1 0]t =q4ـ-<0 chapter 12\SQLQuery15.sql--12-28 ܾݿûJonh1SGMS --ݿеcreate viewcreate tableȨ Use SGMS Deny create view,create table to John1 =t =bb鋤ۀ-<0 chapter 12\SQLQuery16.sql--12-27 ܾRose1SGMS ݿGradeupdateȨ Use SGMS Deny update on grade to Rose1 t =bbwJX'<0 chapter 12\SQLQuery17.sql--12-30 ջcheng33GradeSelectȨ Use SGMS Revoke select on Grade from cheng33 t =ppCY'<0 chapter 12\SQLQuery18.sql--12-31 ջcheng33create viewcreate tableȨ Use SGMS Revoke create view,create table from cheng33 ht =llhc{Y'<0 chapter 12\SQLQuery19.sql--12-32ܾcheng33SGMS ݿ --GradeupdateȨ Use SGMS Deny update on Grade to cheng33 Oit <qqM|-Հ-<0 chapter 12\SQLQuery2.sql--12-9 ʹT-SQL䷽ʽ޸SQL --ServerʻJohnΪAbc123#S alter login John with password ='Abc123#S'qt ="Z'<0 chapter 12\SQLQuery20.sql--12-33ܾݿûcheng44SGMS --ݿеcreate viewcreate tableȨ Use SGMS Deny create view,create table to cheng44 1Bt =UU,#+Ћ;0 chapter 12\SQLQuery21.sql--12-5ʹT-SQL䴴Windows¼˺cheng4 Exec sp_grantlogin 'C6003\cheng4''t =;;0 chapter 12\SQLQuery22.sql--12-6ʹT-SQL䴴SQL Server¼˺cheng5 --Ϊcheng555ĬݿΪSGMSĬΪEnglish Exec sp_addlogin 'cheng5','cheng555','sgms','English',t =WW։;0 chapter 12\SQLQuery23.sql--12-9 ʹT-SQL䷽ʽܾWindows¼ʺcheng2 Exec sp_denylogin 'C6003\cheng2'Dt <?.s;0 chapter 12\SQLQuery3.sql--12-6ʹT-SQL䴴SQL Server¼˺cheng5 --Ϊcheng555ĬݿΪSGMSĬΪEnglish Exec sp_addlogin 'cheng5','cheng555','sgms','English'Ht <::8Aր-<0 chapter 12\SQLQuery4.sql--12-10 ʹT-SQLɾJohn˺ drop login John t <ii2|ր-<0 chapter 12\SQLQuery5.sql--12-12 ʹT-SQLsysadmin --ɫijԱJohn sp_addsrvrolemember 'John', 'sysadmin' Bt <׀-<0 chapter 12\SQLQuery6.sql--12-15 ʹT-SQL佫¼˺Rose --ӵSGMSݿУݿûΪRose1 use SGMS create user Rose1 for login Rose t <DDg׀-<0 chapter 12\SQLQuery7.sql--12-16ʹT-SQL --ɾݿûRose1 drop user Rose1 C@t <qqO׀-<0 chapter 12\SQLQuery8.sql--12-18ʹT-SQLdb_datareader --ݿɫӳԱRose1 sp_addrolemember 'db_datareader','Rose1' Rt <FFm׀-<0 chapter 12\SQLQuery9.sql--12-20 T-SQL䴴Զݿɫrole2 sp_addrole 'role2'ut app4*Ԁ-<0A chapter 12\½ļ\SQLQuery1.sqle ^N9Y\SQLQuery1.sql--12-8ʹT-SQL䴴SQL Server¼ --˺JohnΪAbc123 create login John with password ='Abc123' t aqqM|-Հ-<0A chapter 12\½ļ\SQLQuery2.sqle ^N9Y\SQLQuery2.sql--12-9 ʹT-SQL䷽ʽ޸SQL --ServerʻJohnΪAbc123#S alter login John with password ='Abc123#S'rwt a::8Aր-<0A chapter 12\½ļ\SQLQuery4.sqle ^N9Y\SQLQuery4.sql--12-10 ʹT-SQLɾJohn˺ drop login John _t aii2|ր-<0A chapter 12\½ļ\SQLQuery5.sqle ^N9Y\SQLQuery5.sql--12-12 ʹT-SQLsysadmin --ɫijԱJohn sp_addsrvrolemember 'John', 'sysadmin' t a׀-<0A chapter 12\½ļ\SQLQuery6.sqle ^N9Y\SQLQuery6.sql--12-15 ʹT-SQL佫¼˺Rose --ӵSGMSݿУݿûΪRose1 use SGMS create user Rose1 for login Rose t aDDg׀-<0A chapter 12\½ļ\SQLQuery7.sqle ^N9Y\SQLQuery7.sql--12-16ʹT-SQL --ɾݿûRose1 drop user Rose1 (t aqqO׀-<0A chapter 12\½ļ\SQLQuery8.sqle ^N9Y\SQLQuery8.sql--12-18ʹT-SQLdb_datareader --ݿɫӳԱRose1 sp_addrolemember 'db_datareader','Rose1' ut E2@L=0% chapter 6\6-1.sqlNR6-1.sqlCREATE DATABASE SGMS GO4t G..Ci=0' chapter 6\6-10.sqlNR6-10.sqlALTER DATABASE SGMS REMOVE FILEGROUP fgroup t G66t&dl=0' chapter 6\6-11.sqlNR6-11.sqlALTER DATABASE SGMS MODIFY FILEGROUP fgroup DEFAULT*t E6}=3% chapter 6\6-2.sqlNR6-2.sqlA|iP*MDVVA"BtZRzQDDΈs$ f 0\՞Dz\& f\a.lK!\Z_Klr!df1n0Ҟ*;_sEw3VU;蝛I/ o\cKtYWp*:g. Fi&!Keb]Vt E|~t=3% chapter 6\6-3.sqlNR6-3.sql UT3кcj KDp0~Y*B~J!Fr\N Qp\WFゥ{=N2Ahh I*ͦ~~iU3AM߶xy(kŒt E++^I[i=0% chapter 6\6-9.sqlNR6-9.sqlALTER DATABASE SGMS ADD FILEGROUP fgroup t E)N=3% chapter 7\7-1.sqlNR7-1.sql Uwx>lP*_DnR\Sj}03>{չB4lj٬#0L ׫ _.pXxc1T 3*Q6 z- ݐص*jGq~HuB<GN*E ߧ W>_PBYkmGj t G ITm=3' chapter 7\7-19.sqlNR7-19.sql  7lD]NIIH$==?A !tU; thx]׺\IvjGt[Cx,k*A#c{Х*vGTSCǯV t GIIDn=0' chapter 7\7-20.sqlNR7-20.sqlUSE SGMS GO ALTER TABLE grade ADD primary key (studentID,courseID) GO#8t G! q=3' chapter 7\7-21.sqlNR7-21.sql T̽3dZ(6,+l}PBt_w;|;bÂi|э-dJZ]ƽ^SOg0TQ'boܵ'Cod싥>"eW)bIOI Ȝ^3E )޾u)n}Ƴ쀞t GPPb;r=0' chapter 7\7-22.sqlNR7-22.sqlUSE SGMS GO ALTER TABLE course ADD CONSTRAINT UN_name UNIQUE(coursename) GOGt G'+R5t=3' chapter 7\7-23.sqlNR7-23.sql QՁ? DϤb@d v E-H&~FMU{TV5xhX_S? LVU =JtÁ;X pqB_ hU ^/wF)BE2ֶ[csFIyC6Yha &bn)Њ>\G got GVVt=0' chapter 7\7-24.sqlNR7-24.sqlUSE SGMS GO ALTER TABLE student ADD CONSTRAINT def_sex DEFAULT '' for sex GO %t GNou=3' chapter 7\7-25.sqlNR7-25.sql ̾7lu;kUexlVPGR6J Qx~|x')?MDmj!5C ^l CͰ> 4qugA ק!/u!() ߤ2Vt Ge|jGv=3' chapter 7\7-26.sqlNR7-26.sql A> /ІA`!?DDhFW;61(6=*9K@BmB$өf^PiI;mai [t G's461~C!J=w`OayAŵԅNr]z)FAdeI3(#t E$$a=0% chapter 7\7-3.sqlNR7-3.sqluse SGMS go exec sp_help student -t G??2{:{=0' chapter 7\7-34.sqlNR7-34.sqlUSE SGMS GO ALTER TABLE class DROP CONSTRAINT PK_class GO Xt E??a=0% chapter 7\7-4.sqlNR7-4.sqlUse SGMS Go ALTER TABLE student ADD Email varchar(20) null t E66i'?b=0% chapter 7\7-5.sqlNR7-5.sqlUse SGMS Go ALTER TABLE student DROP COLUMN Email t ESSE~4b=0% chapter 7\7-6.sqlNR7-6.sqluse SGMS go ALTER TABLE student ALTER COLUMN studentName nvarchar(60) NOT NULL t E!!>Yb=0% chapter 7\7-7.sqlNR7-7.sqluse SGMS go DROP TABLE course t 577z1B=0 chapter 8\8-1.sql--8-1 鿴ѧϸϢ select * from Studentwt 6qqu\<0 chapter 8\8-10.sql--8-10 Ȱ༶ٰ併ʾѧϢ SELECT * FROM Student ORDER BY classID ASC, birthday DESCt 6xxs袶B=0 chapter 8\8-11.sql--8-11 鿴ѧϸϢ SELECT TOP 3 * FROM Student ORDER BY datediff(day,birthday,getdate()) DESCt 6bbx?<0 chapter 8\8-12.sql--8-12 ѧߵǰ10%ѧϢ SELECT TOP 10 PERCENT * FROM Student ORDER BY credithour~t 6EE75T<0 chapter 8\8-13.sql--8-13 鿴ѧԴ SELECT DISTINCT address FROM Student ft 6ܥ6T<0 chapter 8\8-14.sql--8-14 ѯѧšԱ --Żʾ SELECT studentID as 'ѧ' ,studentName as '' ,sex as 'Ա' FROM Student ,rt 6v6T<3 chapter 8\8-15.sql Q .Px?͉6tv+[$8kT"Mr 4m:#K> >xn$c);Væug֍?w6%õ-ⶀmX+, -T^Nxb̕&1't?Pe9!~F*3SE_Tt 6G6T<0 chapter 8\8-16.sql--8-16 ͳÿ༶ѧƽ SELECT classID, count(*) as '' ,AVG(DATEDIFF(year,birthday,GETDATE())) AS 'ƽ' FROM Student GROUP BY classIDSt 66T<0 chapter 8\8-17.sql--8-17 ͳÿ༶ѧƽ --ֻ10˵İ༶ SELECT classID, COUNT(*) as '' ,AVG(DATEDIFF(year,birthday,GETDATE())) AS 'ƽ' FROM Student GROUP BY classID HAVING COUNT(*) < 10yt 6xH<3 chapter 8\8-18.sql aLkA'C 2v$ ȓA5m \'QE"BI\q;Ws*C܀amo!Y1W`_v}lݒ-YC.4nlc+9Qz8DMU9hu=aHr L^3π]Q;6l;k4wEF#-%t 6>DV6T<3 chapter 8\8-19.sql]Le zmY=)m.lp\'n7 m/#TXFd8887*.u'?w9NӁARVbhsҸc=n}z8h͟XDuiډLcQH'b7M4Ȏ8 wC&rj؞DT&R ˣP\y뎒Q/2u ^t 5PP1B=0 chapter 8\8-2.sql--8-2 ѧѧ select studentID,studentName from Student_t 6U|I<0 chapter 8\8-20.sql--8-20 鿴ÿѧڵİ༶ SELECT studentID,studentName,className FROM Student INNER JOIN Class ON Student.classID=Class.classIDqt 6t&M<0 chapter 8\8-21.sql--8-21 鿴ÿ༶ڵרҵ SELECT classID,className,specialityName FROM Class AS c INNER JOIN Speciality as s ON c.specialityID=s.specialityID at 6*'T<3 chapter 8\8-22.sql L .Px?dAM jiix<$zGFSTPDE#j#J7-(2zQ +tEFO!$BP_ןɻc6 O㣴חUL, ӲhB4{ۡȺZDD舊#҅vݗM ](G; ^d3>38f8rWX,hZ*rGNǻ[lfpg:WSDH_,CE@7*jiD hŪd廀@B`&ض 4a!j↉bI^/y7w7ⱬd#$t 6¨ǀ%T<0 chapter 8\8-25.sql--8-25 ѯѧ༶Ϣ,га༶ SELECT c.classID,className,studentName FROM Class as c LEFT JOIN Student as s ON c.classID=s.classID|1t 62<V<3 chapter 8\8-26.sql  .Px?uZ",Б:i(C旑jiA! ,iGi' s yg $mŐ7-}tO>{ǿ~qt'+U} p(rE{V8 "Icy8A0]_Jآ.'u t 6wwd!{V<0 chapter 8\8-27.sql--8-27 ѯѧѡεĿ SELECT studentID,studentName,courseID,courseName FROM Student CROSS JOIN Coursevt 6$U<3 chapter 8\8-28.sql ] .Px?KQb`;iZ$א-i HZֶ+J S"<+xeX}=PAQT2s8lï](~ ʵe^:@NRaIQGGNPR wUp,lv 3VE&mJK3)t 6 ;MV<3 chapter 8\8-29.sql P .Px?Pv]7QF #bJ4($k6e{NQLޥtKW5i6KqkQ<j7C$9^&-w`|q(,^;lCҫJf.?asuo#t 5\\$B=0 chapter 8\8-3.sql--8-3 鿴ѧΪ0711001ѧϢ SELECT * FROM Student WHERE studentID='0711001' t 6W]|YjW<3 chapter 8\8-30.sql  .<⃠KKS?Fj7Ai҃jj- ]!kFPX{ Yq"t0JOdgOh(˿ o26mN)ap,1r2k M"Y/h~ ?>i% Ҵ}t 6f{<3 chapter 8\8-31.sql ] /AhFQCU nhZ:؂DAB ? sJ֍KR z܏)~!iir&@b:=3o&lٞYzU ߋQscE)-bȲb|L^UA˚BFs)^bPwJ;/t 6/Om{<3 chapter 8\8-32.sqlYՀkAqhXุRYV,~% ]!/u1tAG%AA%a7K I''^sPz{?:`㷾哬W Pf'/_нϝolx~NPI͸q) lC֛KIhh<#,Î,-ɕ`zKDBA@YpҐ Η8/II> !jZTDvOc #z>iy #t 6cf2>3 chapter 8\8-33.sql LՀ HZeE t PO4(,l[ZPihjDD#C"Cs?py?SmzN_ϙ8웷k-ξt1QʠBӫPYSf`j[aNJ N̏JĐ)tEԸd@4?~)> &?~F@%t 6ٚ2>3 chapter 8\8-34.sql UU /AQƕ n RuZXд(&3 {{cj GK :?9O4Y )Li)}OA_mڝ0"chapter 12\½ļe ^N9Ypt-%Q>0 chapter 9t.#Q>0chapter 10eIt.$Q>0chapter 11t.$Q>0chapter 12t-$Q>0 chapter 6gt-%Q>0 chapter 7t-%Q>0 chapter 8={@