數(shù)據(jù)庫應(yīng)用數(shù)據(jù)庫基礎(chǔ)與應(yīng)用-0018(浙江電大-課程號(hào)：3306805)參考資料-資料下載頁
2025-04-15 02:41本頁面
【正文】 udentB、Select count (S_ID) as 學(xué)生數(shù) From StudentC、Select max(S_ID) as 學(xué)生數(shù) From StudentD、Select avg(S_ID) as 學(xué)生數(shù) From Student列出學(xué)生少于6人的系名。A、Select depart as 系別, count(*) as 人數(shù)From StudentGroup by departHaving count (*) amp。lt 6B、Select depart as 系別, count(*) as 人數(shù)From StudentHaving count (*) amp。lt 6C、Select depart as 系別, count(*) as 人數(shù)From Studentwhere count (*) amp。lt 6D、Select depart as 系別, count(*) as 人數(shù)From Studentorder by departHaving count (*) amp。lt 6在 Course 表中找出學(xué)分大于3并且小于5的課程。A、Select * From Course Where credit amp。gt 3 or credit amp。lt 5B、Select * From Course Where credit amp。gt 3 and credit amp。lt 5C、Select * From Course Where credit amp。gt =3 or credit =amp。lt 5D、Select * From Course Where credit amp。gt =3 and credit =amp。lt 5在 Student 表中求出每個(gè)系別的人數(shù)。A、Select depart as 系名,count (*)as 人數(shù) From Student order by departB、Select depart as 系名,count (*)as 人數(shù) From Student group by snameC、Select depart as 系名,count (*)as 人數(shù) From Student group by departD、Select depart as 系名,sum(*)as 人數(shù) From Student group by depart參考答案：12345 16 / 16
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1