SELECT h.hacker_id, h.name, SUM(s.score) FROM hackers AS h JOIN (SELECT hacker_id, challenge_id, max(score) AS score FROM submissions GROUP ...
確定! 回上一頁