596.Classes More Than 5 Students
难度:Easy
SQL架构 There is a table courses with columns: student and class
Please list out all classes which have more than or equal to 5 students.
For example, the table:
+---------+------------+| student | class |+---------+------------+| A | Math || B | English || C | Math || D | Biology || E | Math || F | Computer || G | Math || H | Math || I | Math |+---------+------------+Should output:+---------+| class |+---------+| Math |+---------+
Note: The students should not be counted duplicate in each course.
# Write your MySQL query statement belowselect class from courses group by class having count(distinct student)>=5 ;
执行用时 :299 ms, 在所有 C++ 提交中击败了88.32%的用户 内存消耗 : N/A
Last updated 1 year ago