SELECT teacher,AVG(score) AS avg_score
FROM course
GROUP BY teacher
ORDER BY avg_score DESC;
2023-07-11 10:44
124
0
0
0
SELECT s.*,c.score
FROM student s
INNER JOIN course c
ON s.s_id=c.s_id
ORDER BY c.score DESC
LIMIT 1,
2023-07-11 10:44
121
0
0
0
```
select stu_id,stu_name,AVG(score) from student inner join score on student.stu_id=score.stu_id where sco
2023-07-11 10:47
126
0
0
0
```
SELECT s.name AS 姓名, c.name AS 课程名称, s.score AS 成绩, AVG(s.score) AS 平均成绩
FROM student s, course c
WHERE
2023-07-11 10:49
133
0
0
0
```
SELECT
c.id,
c.name,
MAX(s.score) AS maxScore,
MIN(s.score) AS minScore,
AVG(s.score) AS avgScore,
2023-07-11 10:50
135
0
0
0
```
SELECT stu_name,score_sum,
@curRank := @curRank + 1 AS rank
FROM student,(SELECT @curRank := 0) r
ORDE
2023-07-11 10:51
132
0
0
0
```
SELECT course_id, course_name,
COUNT(CASE WHEN score BETWEEN 100 AND 85 THEN 1 END) AS 100-85,
2023-07-11 10:53
128
0
0
0
：
SELECT course_name, COUNT(*) AS students_number FROM course_registration GROUP BY course_name;
2023-07-12 15:04
123
0
0
0