建表语句点击详见
– 查询平均成绩大于等于60分的同学的学生编号和学生姓名和平均成绩
SELECTst.s_id,st.s_name,ROUND(AVG(sc.s_score),2)FROM student stLEFT JOIN score sc ON sc.s_id=st.s_idGROUP BY st.s_id HAVING AVG(sc.s_score)>=60;
时间:2023-02-17 15:51:42
建表语句点击详见
– 查询平均成绩大于等于60分的同学的学生编号和学生姓名和平均成绩
SELECTst.s_id,st.s_name,ROUND(AVG(sc.s_score),2)FROM student stLEFT JOIN score sc ON sc.s_id=st.s_idGROUP BY st.s_id HAVING AVG(sc.s_score)>=60;
找出所有全部成绩合格(分数大于等于60分)的学生姓名 找出总成绩最高的前三名同学姓
2023-11-29
python统计学生平均成绩和及格人数_SQL 查询:查询学生平均成绩
2021-03-22