2023-07-12 15:20
126
0
0
0
```
SELECT student_name,AVG(grade) as avg_grade,(SELECT COUNT(DISTINCT(AVG(grade))) FROM student_grade WHERE AVG(grade) > sg.AVG(grade))+1 AS rank FROM student_grade sg GROUP BY st
2023-07-12 15:19
110
0
0
0
```
SELECT * FROM SCORE
ORDER BY SUBJECT, SCORE DESC
LIMIT 3;
```
2023-07-12 15:17
109
0
0
0
```
SELECT s_no,s_name
FROM student
WHERE s_no IN (SELECT s_no
FROM course
GROUP BY s_no
HAVING COUNT(*) = 2);
```
2023-07-12 15:04
125
0
0
0
：
SELECT course_name, COUNT(*) AS students_number FROM course_registration GROUP BY course_name;
2023-07-11 10:53
131
0
0
0
```
SELECT course_id, course_name,
COUNT(CASE WHEN score BETWEEN 100 AND 85 THEN 1 END) AS '100-85',
COUNT(CASE WHEN score BETWEEN 85 AND 70 THEN 1 END) AS '85-70',
2023-07-11 10:51
133
0
0
0
```
SELECT stu_name,score_sum,
@curRank := @curRank + 1 AS rank
FROM student,(SELECT @curRank := 0) r
ORDER BY score_sum DESC
```
2023-07-11 10:50
139
0
0
0
```
SELECT
c.id,
c.name,
MAX(s.score) AS maxScore,
MIN(s.score) AS minScore,
AVG(s.score) AS avgScore,
SUM(CASE WHEN s.score >= 60 THEN 1 ELSE 0 END)/COUNT(*) AS passRate,
2023-07-11 10:49
134
0
0
0
```
SELECT s.name AS '姓名', c.name AS '课程名称', s.score AS '成绩', AVG(s.score) AS '平均成绩'
FROM student s, course c
WHERE s.course_id = c.id
GROUP BY c.name
ORDER BY AVG(s.score) DESC;
`