[SQL문제풀기 - Advent of SQL 2025 🎅] 장르, 연도별 게임 평론가 점수 구하기

문제

solvesql.com

https://solvesql.com/problems/critic-scores-by-genre-and-year/

내가 작성한 정답

MySQL, SQLite, PostgreSQL

select r.name genre,
       round(avg(case when g.year = 2011 then g.critic_score end),2) score_2011,
       round(avg(case when g.year = 2012 then g.critic_score end),2) score_2012,
       round(avg(case when g.year = 2013 then g.critic_score end),2) score_2013,
       round(avg(case when g.year = 2014 then g.critic_score end),2) score_2014,
       round(avg(case when g.year = 2015 then g.critic_score end),2) score_2015  
from games g
join genres r on r.genre_id = g.genre_id
where g.year between 2011 and 2015
group by r.name;