一道SQL数据库语句题求解

2025-03-10 18:25:13
推荐回答(1个)
回答1:

select count(*) rs,max(grade) maxgrade,min(grade) mingrade, avg(grade) avggrade from student a,course b ,sc c where a.sno=c.sno and b.cno=c.cno
and b.cno=1