Question

一个成绩统计表 三个学生 每个学生两门成绩，写一个sql语句获得每门课成绩都大于80分学生的名字

Answer 1

SELECT D.name FROM (
SELECT S.name,S.score AS ITEM1,S1.score AS ITEM2,S2.score AS ITEM3
FROM Student S
inner join Student S1 on S.name = S1.name and S.course <> S1.course
inner join Student S2 on S.name = S2.name and S.course <> S2.course
WHERE S.score>=80 and S1.score>=80 and S2.score>=80
) D
GROUP BY D.name

Answer 2

SELECT name FROM 表 WHERE score >80 GROUP BY name HAVING COUNT(`subject`)>1