```
SELECT * FROM SCORE
ORDER BY SUBJECT, SCORE DESC
LIMIT 3;
```
2023-07-12 15:19
109
0
0
0
```
SELECT s_no,s_name
FROM student
WHERE s_no IN (SELECT s_no
FROM course
GRO
2023-07-12 15:17
108
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
```
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 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
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 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 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