我想你只需要这个简单的问题

select playerid,max(scoring.gwg) as max from scoring group by playerid order by max desc

配置单元不支持子查询。

有两种方法可以做到这一点。获取最大计数并用最大gwg过滤playerid

select playerid
from scoring 
group by playerid 
having count(*) = ( select max(c) from 
                (
                   select playerid,count(*) c 
                   from scoring 
                   group by playerid
                ) a
              )

或者得到计数，按降序排列，得到最上面的一行

select playerid, count(*) as cnt
from scoring 
group by playerid 
order by cnt desc
limit 1;

你可以试试这个

select playerid, max(scoring.gwg) from scoring group by playerid;

这是另一个

select playerid, max(scoring.gwg) as maxScore from scoring 
   group by playerid order by maxScore desc;

上面将给出玩家ID的降序排列，即得分最高的将在上面。