sql面试
1.查询各个课程总成绩(显示课程号和总成绩)
SELECT cid,SUM(score) AS 总成绩 FROM t_score GROUP BY cid;
2.查询选了课程的学生人数
SELECT COUNT(DISTINCT(sid)) FROM t_score;
3.查询各科成绩的最高分和最低分
SELECT cid,MAX(score) AS 最高分,MIN(score) AS 最低分 FROM t_score GROUP BY cid;
4.查询每门课被选修的学生数
SELECT cid,COU
原创
2021-02-10 20:42:50 ·
188 阅读 ·
1 评论