某个sql笔试题记录

题目：

SELECT 
	s.name AS NAME,
	b.avg_grade AS avg_grade
FROM student s INNER JOIN (SELECT student_id,AVG(grade) AS avg_grade
                           FROM grade
                           GROUP BY student_id) b
ON s.id=b.student_id
WHERE s.id IN (
    SELECT a.student_id
	FROM(SELECT student_id,
        CASE WHEN grade<60 THEN 1 ELSE 0 END AS num
    	FROM grade) a
	GROUP BY a.student_id
	HAVING SUM(a.num)>1
)

运行结果：