SQL - HAVING

https://programmers.co.kr/learn/courses/30/lessons/59041

코딩테스트 연습 - 동명 동물 수 찾기

 

 

 

 

 

oracle

SELECT NAME, COUNT(NAME)
FROM ANIMAL_INS
GROUP BY NAME
HAVING COUNT(NAME) >= 2
ORDER BY NAME

 

 

 

 

 

https://programmers.co.kr/learn/courses/30/lessons/59412?language=mysql 

코딩테스트 연습 - 입양 시각 구하기(1)

 

 

 

 

 

MySQL

SELECT HOUR(DATETIME) AS HOUR, COUNT(HOUR(DATETIME)) AS COUNT
FROM ANIMAL_OUTS
GROUP BY HOUR(DATETIME)
HAVING HOUR >= 9 AND HOUR <= 19 
ORDER BY HOUR