We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
- Prepare
- SQL
- Basic Join
- Top Competitors
- Discussions
Top Competitors
Top Competitors
Sort by
recency
|
2358 Discussions
|
Please Login in order to post a comment
Oracle:
Filter out max score per challenege for a hacker guys first. Then is shoud give correct results. For example, if a hacker made 3 submissions, two of which hit the full score, the challenge would be counted twice, leading to incorrect leaderboard rankings.
**CODE: **
I think it's worth to mention that, there is just one Submission per Hacker, for a Challenge...
I initially thought that, Submissions might be recording all submissions made by a Hacker, correct or incorrect.
Quite intrincate this challenge, I dare to say...
I think data is wrong. Becouse Challenges table does not match with submissions table on hacker_id and challenge_id.