两道SQL题目

1.查询省内所有城市气温都大于35度的省份（表名：Temp）

SELECT
	province
FROM
	Temp
WHERE
	province NOT IN (
		SELECT
			province
		FROM
			Temp
		WHERE
			temper <= 35
		GROUP BY
			province
	)
GROUP BY
	province 

 

2、查询所有课程分数都大于85分的学生姓名

SELECT
        NAME
    FROM
        Student s
    WHERE
        NOT EXISTS (
            SELECT
                *
            FROM
                Exam e
            WHERE
                s.person_id = e.person_id
            AND e.score < 84
        )