SELECT S_NO,S_Name FROM student WHERE C_NO=03 AND S_Score>=80;
2023-07-13 09:14
149
0
0
0
SELECT student_name, course_name,score FROM student_course WHERE score>70;
2023-07-13 09:14
131
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
127
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
113
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
110
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
122
0
0
0