SELECT
SUM(CASE WHEN sex=男 THEN 1 ELSE 0 END) AS 男生人数,
SUM(CASE WHEN sex=女 THEN 1 ELSE 0 END) AS 女生人数
F
2023-07-13 09:13
129
0
0
0
```
SELECT student_name,AVG(grade) as avg_grade,(SELECT COUNT(DISTINCT(AVG(grade))) FROM student_grade WHERE
2023-07-12 15:20
143
0
0
0
```
SELECT * FROM SCORE
ORDER BY SUBJECT, SCORE DESC
LIMIT 3;
```
2023-07-12 15:19
134
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
122
0
0
0
：
SELECT course_name, COUNT(*) AS students_number FROM course_registration GROUP BY course_name;
2023-07-12 15:04
139
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
152
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
148
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
153
0
0
0