student inner join score Р on student.studentno=score.studentno Р inner join count1Р on student.studentno=count1.studentnoР where score.final<60 and countNUM<3 РgoР第七章Р3 上机题练习Р01 程序代码如下:Р--ame。РUSE teachingРGOРCREATE NONCLUSTERED INDEX ame ON ame)РGOР02 程序代码如下:РUSE teachingРGOРIF EXISTS(SELECT name FROM sysindexes WHERE name='UQ_stu')Р DROP INDEX student.UQ_stuРGOРCREATE NONCLUSTERED INDEX UQ_stu ON student(studentno,classno)РGOРSELECT * FROM studentР03 程序代码如下:РUSE teachingРGOРALTER INDEX UQ_stu ON student REBUILDР WITH (PAD_INDEX = ON, FILLFACTOR = 80)РGOР04 程序代码如下:Р--创建一个视图v_teacher,查询所有“计算机学院”教师的信息。РUSE teachingРGOРCREATE VIEW v_teacherРASРSELECT *РFROM teacherРWHERE department = '计算机学院'РGOРSELECT * FROM v_teacherР05 程序代码如下:Р--创建一个视图v_avgstu,查询每个学生的学号、姓名及平均分,并且按照平均分降序排序。РUSE teachingРGO
全文预览
