[Programmers] 한 해에 잡은 물고기 수 구하기
정답
-- FISH_INFO: ID, FISH_TYPE, LENGTH, TIME
SELECT COUNT(*) AS FISH_COUNT
FROM FISH_INFO
WHERE YEAR(TIME) = 2021;
✅ Point
- COUNT로 집계
-- FISH_INFO: ID, FISH_TYPE, LENGTH, TIME
SELECT COUNT(*) AS FISH_COUNT
FROM FISH_INFO
WHERE YEAR(TIME) = 2021;