Allen's 데이터 맛집

문제   풀이Julia가 주최한 최근 코딩 대회에서 우수한 성적을 거둔 뒤, 이번에도 그녀의 요청으로 새로운 챌린지에 참여하게 되었습니다! 이번 문제는 각 해커의 챌린지별 최고 점수를 합산하여 해커의 총점을 계산하고, 이를 기반으로 리더보드를 생성하는 SQL 쿼리를 작성하는 것입니다.  SELECT s.hacker_id, h.name, SUM(s.max_score) AS total_max_scoreFROM (SELECT hacker_id, challenge_id, MAX(score) AS max_score FROM Submissions GROUP BY hacker_id, challenge_id ) s JO..