반응형
목록 HackerRank : Challenges (1)
KEEP GOING

https://www.hackerrank.com/challenges/challenges/problem?isFullScreen=true Challenges | HackerRank Print the total number of challenges created by hackers. www.hackerrank.com 1. 에러난 코드 SELECT H.hacker_id, H.name, COUNT(C.challenge_id) as challenges_created FROM Hackers H INNER JOIN Challenges C ON H.hacker_id = C.hacker_id WHERE MAX(challenges_created) OR COUNT(challenges_created) = 1 #문제1 GROUP..
code review/sql
2021. 12. 22. 16:15