下面是我的SQL查询: select hck.hacker_id, hck.name, cnt Hacker as hck Selecthacker_id, count(challenge_id) as cnt group by hacker_id
) chl_counton hck.hacker_id = chl_count.hacker_id
select h.hacker_id, name, count(challenge_id) as total from Challenges c inner join Hackers h on h.hacker_id=c.hacker_id group by h.hacker_id, name (select count(challenge_id) as cnt fromChallenges c where c.hacker_id!=h.hacker</