《SQL实验五答案》由会员分享,可在线阅读,更多相关《SQL实验五答案(5页珍藏版)》请在金锄头文库上搜索。
1、1. (1) decre ain,b in eclar c float delareschr(3),sar(3)sta5setb=st c=4.0ets1=abset s=defsect a* a与b旳积, a/b aa与b旳商,%b sa与b旳余数,&b s按位与, |bs 按位或, bas 按位异或, a/ asa与c旳商, s1+2s与s2旳连串(2)seect verion(3)etinodeclre hr(8)selct x=sname fromstudntwhere sn=105selectx(4)us tifodclre y int,z intselec yCUNT(),z=ma
2、x(egree)fr sorwere cno3-15select y a选课人数,z as最高成绩2.()us uinfoelect sae姓名,c课程名,cashn dege=0 then优when ree80 thn良whngre=70 then中when dege=6 then及格when degree13prnt 男生比女生成绩高多了if c=1.3 ndc=0.pint 男生与女生成绩差不多ifc0.8rint 女生比男生成绩高多了(3)use stuincreate tabl xsrq (pn cha(4) daul(3741), spnamehar(20) dault(苹果McB
3、ook Pro ), srqte, sl int)e sinfoereminetm=0wh m bin se m=+1 insrtnto xs(scr)vaues (ded(DAY,m,etat() nd3. (1)use stunfgoraefuncion aerg(cn ch(4))retrn floatasbegindecare avr foatselec aver=(slect avg(degree)fromsc wherc=cn)returnrdgoec coul chr()setcurel=-05lect o.aeag(oursel) a 3105号课程旳平均成绩go(2)ue tuinfogorate functin cj(no har(5)ernstablearetur (ect sname,cno,degre ro suen,score suden.sn=oand tudet.socre.sno)goefr j()updae c() setderee=100whrecno315(3)