solvesql 의 게임 평점 예측하기 1 with avg_sc_and_cnt as (SELECT gm.genre_id, round(avg(critic_score),3) as avg_critic_sc, ceil(avg(critic_count)) as avg_critic_cnt, round(avg(user_score),3) as avg_user_sc, ceil(avg(user_count)) as avg_user_cntFROM games gm join genres gr on gm.genre_id = gr.genre_idGROUP BY gm.genre_id)SELECT game_id, name, CASE WHEN a.critic_score is null then b.avg_critic_sc else a.cr..