[프로그래머스][MySQL] 한 해에 잡은 물고기 수 구하기

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

프로그래머스

SELECT COUNT(*) AS FISH_COUNT
FROM FISH_INFO
WHERE TIME >= '2021-01-01' AND TIME < '2022-01-01'

 

범위조건을 쓰거나 년도만 비교하거나

SELECT COUNT(*) AS FISH_COUNT
FROM FISH_INFO
WHERE YEAR(TIME) = '2021'