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

문제 

https://school.programmers.co.kr/learn/courses/30/lessons/293257

프로그래머스

FISH_INFO
ID	FISH_TYPE	LENGTH	TIME
0	0	13.37	2021-12-04
1	0	50	2020-03-07
2	0	40	2020-03-07
3	1	43.33	2022-03-09
4	1	null	2022-04-08
5	2	32	2020-04-28

FISH_NAME_INFO
FISH_TYPE	FISH_NAME
0	BASS
1	SNAPPER
2	ANCHOVY

 

 

풀이

select 
    count(*) as FISH_COUNT
    ,b.FISH_NAME
    

from FISH_INFO a
join FISH_NAME_INFO b on a.FISH_TYPE = b.FISH_TYPE

group by b.FISH_NAME
order by FISH_COUNT desc