有一个courses
表 ,有: student (学生) 和 class (课程)。
请列出所有超过或等于5名学生的课。
例如,表:
+---------+------------+ | student | class | +---------+------------+ | A | Math | | B | English | | C | Math | | D | Biology | | E | Math | | F | Computer | | G | Math | | H | Math | | I | Math | +---------+------------+
应该输出:
+---------+ | class | +---------+ | Math | +---------+
先计数每门课的人数
随后取大于等于5的课程列出即可
稍微注意一下去重的DISTINCT即可
So show you my code:
# Write your MySQL query statement below
SELECT class
FROM
(
SELECT COUNT(DISTINCT student) AS num, class
FROM courses
GROUP BY class
) a
WHERE num >= 5