SELECT a.student_no, a.course_no, a.score
FROM student_score a
INNER JOIN student_score b
ON a.score=b.
2023-07-14 09:06
180
0
0
0
SELECT course, COUNT(*) AS student_number
FROM course
GROUP BY course;
2023-07-14 09:06
142
0
0
0
SELECT S_NO,S_Name FROM student WHERE C_NO=03 AND S_Score>=80;
2023-07-13 09:14
167
0
0
0
SELECT student_name, course_name,score FROM student_course WHERE score>70;
2023-07-13 09:14
149
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
156
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
134
0
0
0