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

문제

내가 작성한 정답

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

다른 사람들이 작성한 정답

SELECT COUNT(*) FISH_COUNT, MAX(LENGTH) MAX_LENGTH, FISH_TYPE
FROM FISH_INFO
GROUP BY FISH_TYPE
HAVING AVG(IFNULL(LENGTH, 10)) >= 33
ORDER BY FISH_TYPE