2023-07-14 09:06
123
0
0
0
SELECT course, COUNT(*) AS student_number
FROM course
GROUP BY course;
2023-07-13 09:14
150
0
0
0
SELECT S_NO,S_Name FROM student WHERE C_NO='03' AND S_Score>=80;
2023-07-13 09:14
123
0
0
0
SELECT CourseId FROM SC WHERE Grade
2023-07-13 09:14
133
0
0
0
SELECT student_name, course_name,score FROM student_course WHERE score>70;
2023-07-13 09:14
130
0
0
0
select student.name, course.name, score.score
from student
inner join score on score.student_id=student.id
inner join course on course.id=score.course_id;
2023-07-13 09:14
115
0
0
0
SELECT
stu_num,
stu_name,
AVG(score) AS avg_score
FROM
student
GROUP BY
stu_num,
stu_name
HAVING
avg_score >= 85;
2023-07-13 09:14
112
0
0
0
SELECT * FROM students WHERE YEAR(dob) = 1990;
2023-07-13 09:13
112
0
0
0
SELECT
SUM(CASE WHEN sex='男' THEN 1 ELSE 0 END) AS '男生人数',
SUM(CASE WHEN sex='女' THEN 1 ELSE 0 END) AS '女生人数'
FROM
student;