You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
SELECT h.hacker_id, h.name, COUNT(c.challenge_id) AS total_challenges
FROM hackers h
LEFT JOIN challenges c ON h.hacker_id = c.hacker_id
GROUP BY h.hacker_id, h.name
)
SELECT *
FROM result
WHERE total_challenges NOT IN
(SELECT total_challenges FROM result WHERE total_challenges != (SELECT MAX(total_challenges) FROM result) GROUP BY total_challenges HAVING COUNT(total_challenges) > 1 )