實(shí)驗(yàn)報(bào)告2關(guān)系數(shù)據(jù)庫(kù)標(biāo)準(zhǔn)語言sql(編輯修改稿)
2025-08-10 20:00 本頁(yè)面
【文章內(nèi)容簡(jiǎn)介】 39。課程號(hào)39。FROM Student_courseWHERE Grade is NULL。7SELECT Sno 39。學(xué)號(hào)39。, Grade 39。成績(jī)39。FROM Student_courseWHERE Cno = 39。C60139。ORDER BY Grade DESC。8SELECT COUNT(DISTINCT Sno)FROM Student_course。9SELECT AVG(Grade)FROM Student_courseWHERE Cno = 39。C60139。10SELECT Sno 39。學(xué)號(hào)39。FROM Student_courseGROUP BY SnoHAVING COUNT(Cno) 2。11SELECT Cno39。課程號(hào)39。, SUM(Grade)39?？偡?9。FROM Student_courseGROUP BY Cno。12SELECT , FROM Student,Student_course,CourseWHERE = and = and = 39。高等數(shù)學(xué)39。 and 80。13SELECT , FROM Course FIRST,Course SECONDWHERE = 。14SELECT Sname, Sdept, SageFROM StudentWHERE Sage ANY(SELECT Sage FROM Student WHERE Sdept = 39。EG39。)。
范文總結(jié)相關(guān)推薦
鄂ICP備17016276號(hào)-1