[solveSql] 3년간 들어온 소장품 집계하기

*solveSql은 문제를 게시하는 걸 금하기 때문에 답만 첨부

https://solvesql.com/problems/summary-of-artworks-in-3-years/

문제유형 : CASE/IF
난이도2

SELECT
  classification
  ,SUM(IIF(STRFTIME('%Y',acquisition_date)='2014',1,0)) '2014'
  ,SUM(IIF(STRFTIME('%Y',acquisition_date)='2015',1,0)) '2015'
  ,SUM(IIF(STRFTIME('%Y',acquisition_date)='2016',1,0)) '2016'
 FROM artworks
GROUP BY classification
ORDER BY classification