[LeetCode] Database | 596. Classes More Than 5 Students

Problem

---

Example

---

Thinking

---

단순하게 group by, having 절로 해결할 수 있는 문제.

 

Solve

---

제출 답안

 

SELECT class FROM Courses GROUP BY class
    HAVING count(student) >= 5;

 

---

---

 

https://leetcode.com/problems/classes-more-than-5-students

Classes More Than 5 Students - LeetCode