문제
제출
SELECT count(*) as FISH_COUNT,b.fish_name as FISH_NAME
from fish_info as a
join fish_name_info as b
on a.fish_type=b.fish_type
group by 2
order by 1 desc🚨 error
SELECT count(*) as FISH_COUNT,b.fish_name as FISH_NAME
from fish_info as a
join fish_name_info as b
on a.fish_type=b.fish_type
group by a.fish_type
order by 1 desc
🔥 에러 원인: ONLY_FULL_GROUP_BY 모드와 GROUP BY 조건 불일치
→ b.fish_name이 GROUP BY에 포함되지 않아서 발생한 문제
→ SELECT 문에 있는 컬럼은 GROUP BY에 포함된 컬럼이어야 함
