반응형
https://leetcode.com/problems/classes-more-than-5-students/description/
Classes More Than 5 Students - LeetCode
Can you solve this real interview question? Classes More Than 5 Students - Table: Courses +-------------+---------+ | Column Name | Type | +-------------+---------+ | student | varchar | | class | varchar | +-------------+---------+ (student, class) is the
leetcode.com
group by ~ having 절을 사용해본 문제였습니다.
📕 풀이방법
📔 풀이과정
class열에 대해 goup by를 한 뒤 count를해 나온 학생 수가 5이상인 class들을 courses table로 부터 select해줍니다.
📕 Code
📔 MySQL & Oracle
-- MySQL & Oracle
select class
from courses
group by class
having count(*) >= 5*더 나은 내용을 위한 지적, 조언은 언제나 환영합니다.
'Algorithm > SQL' 카테고리의 다른 글
| (SQL) - LeetCode (easy) 620. Not Boring Movies (0) | 2023.05.24 |
|---|---|
| (SQL) - LeetCode (easy) 607. Sales Person (0) | 2023.05.19 |
| (SQL) - LeetCode (easy) 586. Customer Placing the Largest Number of Orders (0) | 2023.05.03 |
| (MySQL) - LeetCode (easy) 197. Rising Temperature (0) | 2022.12.22 |
| (MySQL) - LeetCode (easy) 196. Delete Duplicate Emails (0) | 2022.12.21 |