문제
입력 코드
SELECT class
FROM Courses
GROUP BY class
HAVING COUNT(*) >= 5
코드 설명
#SELECT #GROUP BY #HAVING #COUNT
문제 출처
LeetCode - The World's Leading Online Programming Learning Platform
Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.
leetcode.com
'SQL' 카테고리의 다른 글
| #103. [LeetCode / MySQL] 1045. Customers Who Bought All Products (0) | 2023.09.29 |
|---|---|
| #101. [LeetCode / MySQL] 1729. Find Followers Count (0) | 2023.09.27 |
| #99. [LeetCode / MySQL] 1070. Product Sales Analysis III (0) | 2023.09.25 |
| #98. [LeetCode / MySQL] 1141. User Activity for the Past 30 Days I (0) | 2023.09.24 |
| #97. [LeetCode / MySQL] 2356. Number of Unique Subjects Taught by Each Teacher (0) | 2023.09.23 |