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

문제

MYSQL

내가 작성한 정답

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 asc

내가 이전에 작성했던 정답

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