[SQL 코드카타] 175 ~ 177번(HackerRank)
175번 contest-leaderboard > ?? with 절을 사용하는데 계속 오류가 나서 사용하지 못함 select hacker_id, name, sum(score) as sum_score from (select sm.hacker_id, hk.name, sm.challenge_id, max(sm.score) as score from submissions sm join hackers hk on sm.hacker_id = hk.hacker_id group by 1,2,3) abc group by 1,2 having sum(score) > 0 order by 3 desc, 1 176번 sql-projects > 이해 x.. 해답 참고 WITH source AS( SELECT Start_Date, End..
2024. 1. 24.