大连理工大学软件学院数据库上机题目+答案(最新)

大连理工大学软件学院数据库上机题目+答案(最新) 大连理工大学软件学院——数据库上机题11. Find the ID, names of all the students from depart

大连理工大学软件学院数据库上机题目+答案 (最新) 大连理工大学软件学院——数据库上机题11.FindtheID,names ofallthestudentsfromdepartmentswhosenamecontaincharacter'功 '.2.FindtheID,namesandtotalcreditsofstudentsin邪门学院 departmentorin兵器学院departmentwhosetotalcreditsarehigher than50credits3.Fortheinstructor83821,showcourse_idandtitleof allcoursestaughtbytheinstructor4.Asabove,butshowthetotal numberofcreditsforsuchcourses(taughtbythatinstructor).You shoulduseSQLaggregationoncoursestaughtbythatinstructor.5.As above,butdisplaythetotalcreditsforeachoftheinstructors,along withtheIDoftheinstructor;don'tbotheraboutthenameofthe instructors.(Don'tbotheraboutinstructorswhohavenottaughtany course,theycanbeomitted)6.Findaverageinstructors'salariesforeach ofcourses,alongwiththecourse_idandtitleofthecourse,taughtby instructorsof内功学院,theresultshouldbesortedfromthelowestto thehighestaccordingtotheaveragesalaries.7.Findthenamesofall courseswhichhavebeentaughtin南疆雨林ever(thereshouldbeno duplicatenames)8.DisplaytheIDsandnamesofallstudentswhohave