[SQL][GROUP BY][JOIN] 물고기 종류 별 잡은 수 구하기

물고기 종류 별 잡은 수 구하기

프로그래머스

 

 

• 풀이
  • SQL 동작 순서 
    • FROM - ON - JOIN - WHERE - GROUP BY- HAVING - SELECT - DISTINCT - ORDER BY

SELECT COUNT(I.FISH_TYPE) AS FISH_COUNT, N.FISH_NAME
FROM FISH_NAME_INFO N
JOIN FISH_INFO I
ON I.FISH_TYPE = N.FISH_TYPE
GROUP BY N.FISH_NAME
ORDER BY 1 DESC