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.
  • HackerRank Home

    HackerRank

  • |
  • Prepare
  • Certify
  • Compete
  • Apply
  • Hiring developers?
  1. Prepare
  2. SQL
  3. Basic Join
  4. Top Competitors
  5. Discussions

Top Competitors

Problem
Submissions
Leaderboard
Discussions

    You are viewing a single comment's thread. Return to all comments →

  • harishrajmudira1
    4 months ago+ 1 comment

    Plz someone help me ,what's wrong in this query. select a.hacker_id, a.name from hackers a join submissions b on a.hacker_id= b.hacker_id where b.challenge_id in (select a.challenge_id from challenges a join difficulty b on a.difficulty_level=b.difficulty_level) and b.score in (select a.score from difficulty a join challenges b on a.difficulty_level=b.difficulty_level) group by a.hacker_id having count(a.hacker_id)>1 order by count(a.hacker_id) desc, a.hacker_id asc

    0|
    Permalink
  • Blog
  • Scoring
  • Environment
  • FAQ
  • About Us
  • Support
  • Careers
  • Terms Of Service
  • Privacy Policy