#Leetcode# 596. Classes More Than 5 Students

旧城等待， 2021-11-09 23:30 241阅读 0赞

[https://leetcode.com/problems/classes-more-than-5-students/][https_leetcode.com_problems_classes-more-than-5-students]

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 below
    SELECT class FROM Courses
    GROUP BY class Having Count(distinct student)>=5

转载于:https://www.cnblogs.com/zlrrrr/p/10848790.html

[https_leetcode.com_problems_classes-more-than-5-students]: https://leetcode.com/problems/classes-more-than-5-students/

发表评论取消回复

表情：

评论列表（有 0 条评论，241人围观）

还没有评论，来说两句吧...

相关阅读

相关 OpenKruise 2021 规划曝光：More than workloads

![头图.png][.png] 作者 | 王思宇（酒祝）来源|[阿里巴巴云原生公众号][Link 1] 背景 > OpenKruise 项目地址：[https:

女爷i/ 2023年01月02日 09:29/ 0 赞/ 117 阅读

相关 LeetCode - Easy - 181. Employees Earning More Than Their Managers

Topic SQL Description [https://leetcode.com/problems/employees-earning-more-th

淡淡的烟草味﹌/ 2022年12月29日 12:54/ 0 赞/ 124 阅读

相关【leetcode Database】181. Employees Earning More Than Their Managers

题目： The `Employee` table holds all employees including their managers. Every employee h

叁歲伎倆/ 2022年09月24日 06:21/ 0 赞/ 129 阅读

相关 LeetCode--181. Employees Earning More Than Their Managers

Problem: > The Employee table holds all employees including their managers. > Every e

Myth丶恋晨/ 2022年08月21日 01:08/ 0 赞/ 9 阅读

相关【MySQL】【leetcode】 Employees Earning More Than Their Managers解题报告

题目 The Employee table holds all employees including their managers. Every employee ha

爱被打了一巴掌/ 2022年08月09日 09:59/ 0 赞/ 148 阅读

相关 leetcode 181. Employees Earning More Than Their Managers

181. Employees Earning More Than Their Managers Question Editorial Solution [My Subm

客官°小女子只卖身不卖艺/ 2022年07月19日 01:56/ 0 赞/ 62 阅读

相关 TRIPLE is More Than DOUBLE Plus One

https://techsingular.org/2017/12/29/triple-is-more-than-double-plus-one/ TRIPLE i

淩亂°似流年/ 2022年06月01日 06:36/ 0 赞/ 159 阅读

相关 [LeetCode] 596：超过5名学生的课

有一个`courses` 表，有: student (学生) 和 class (课程)。请列出所有超过或等于5名学生的课。例如,表: +---------+

太过爱你忘了你带给我的痛/ 2022年05月16日 00:12/ 0 赞/ 168 阅读

相关 LeetCode596之超过5名的学生(MySQL实现)

一、题目 ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3

傷城~/ 2022年04月18日 00:57/ 0 赞/ 143 阅读

相关 #Leetcode# 596. Classes More Than 5 Students

[https://leetcode.com/problems/classes-more-than-5-students/][https_leetcode.com_problem

旧城等待，/ 2021年11月09日 23:30/ 0 赞/ 242 阅读