[SQL문제풀기] 특정 조건을 만족하는 물고기별 수와 최대 길이 구하기

문제

MYSQL

내가 작성한 정답

#1
SELECT COUNT(ID) FISH_COUNT, MAX(LENGTH) MAX_LENGTH, FISH_TYPE
FROM (SELECT ID, FISH_TYPE, IFNULL(LENGTH,10) LENGTH FROM FISH_INFO) A
GROUP BY FISH_TYPE
HAVING AVG(LENGTH) >= 33
ORDER BY 3;

#2
SELECT COUNT(ID) FISH_COUNT, MAX(LENGTH) MAX_LENGTH, FISH_TYPE
FROM FISH_INFO
GROUP BY FISH_TYPE
HAVING AVG(IFNULL(LENGTH,10)) >= 33
ORDER BY 3;