You are viewing a single comment's thread. Return to all comments →
Can anyone explain simply why this code correctly calculates the maximum number of challenges solved by one person...
select count(c1.challenge_id) from challenges as c1 group by c1.hacker_id order by count(c1.challenge_id) desc limit 1
... but this throws an error?
select max(count(c1.challenge_id)) from challenges as c1 group by c1.hacker_id
Seems like cookies are disabled on this browser, please enable them to open this website
Challenges
You are viewing a single comment's thread. Return to all comments →
Can anyone explain simply why this code correctly calculates the maximum number of challenges solved by one person...
... but this throws an error?