SELECT s.name, g.score
FROM student AS s
INNER JOIN grade AS g ON s.id = g.student_id
INNER JOIN course
2023-07-15 08:48
176
0
0
0
SELECT sno,AVG(score)
FROM student
WHERE score < 60
GROUP BY sno
HAVING COUNT(score)>=2;
2023-07-14 09:07
171
0
0
0
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
201
0
0
0
SELECT course, COUNT(*) AS student_number
FROM course
GROUP BY course;
2023-07-14 09:06
162
0
0
0
SELECT S_NO,S_Name FROM student WHERE C_NO=03 AND S_Score>=80;
2023-07-13 09:14
187
0
0
0
SELECT student_name, course_name,score FROM student_course WHERE score>70;
2023-07-13 09:14
175
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
174
0
0
0