```
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 * FROM SCORE
ORDER BY SUBJECT, SCORE DESC
LIMIT 3;
```
2023-07-12 15:19
109
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
123
0
0
0
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
111
0
0
0
SELECT
stu_num,
stu_name,
AVG(score) AS avg_score
FROM
student
GROUP BY
stu_num,
s
2023-07-13 09:14
114
0
0
0
select student.name, course.name, score.score
from student
inner join score on score.student_id=student.
2023-07-13 09:14
128
0
0
0
SELECT student_name, course_name,score FROM student_course WHERE score>70;
2023-07-13 09:14
132
0
0
0