複数テーブルからうまくデータが取得できない

-- 試合情報テーブル
CREATE TABLE Game(
    id              smallint unsigned   AUTO_INCREMENT,
    date            date,
    pitchId         smallint unsigned   NOT NULL,
    category        smallint unsigned   NOT NULL,
    gameTitle       char(255),
    opponent        char(255)           NOT NULL,
    gameType        char(3)             NOT NULL,
    
    PRIMARY KEY(id),
    INDEX(pitchId),
    FOREIGN KEY(pitchId) REFERENCES Pitch(id)
) TYPE=INNODB;


-- 試合ごとの試合参加メンバーを保持するテーブル
CREATE TABLE GameEntry(
    gameId          smallint unsigned,
    memberId        smallint unsigned,
    
    PRIMARY KEY(gameId, memberId),
    INDEX(gameId),
    INDEX(memberId),
    FOREIGN KEY(gameId) REFERENCES Game(id),
    FOREIGN KEY(memberId) REFERENCES Member(id)
) TYPE=INNODB;


-- 試合ごとの得点情報を保持するテーブル
CREATE TABLE Score(
    gameId          smallint unsigned,
    sequence        tinyint  unsigned,
    goalMember      smallint unsigned,
    assistMember    smallint unsigned,
    
    PRIMARY KEY(gameId, sequence),
    INDEX(goalMember),
    INDEX(assistMember),
    FOREIGN KEY(gameId) REFERENCES Game(id),
    FOREIGN KEY(goalMember) REFERENCES Member(id),
    FOREIGN KEY(assistMember) REFERENCES Member(id)
) TYPE=INNODB;


-- 選手情報テーブル
CREATE TABLE Member(
    id              smallint unsigned   AUTO_INCREMENT,
    name            char(32),
    
    PRIMARY KEY(id)
) TYPE=INNODB;

┏━━┯━━━┯━━┯━━━┯━━━┓
┃順位│選手名│得点│試合数│得点率┃
┣━━┿━━━┿━━┿━━━┿━━━┫
┃   1│Aくん │  24│    18│ 0.750┃
┃   2│Bくん │  20│    17│ 1.176┃
┃   3│Cくん │  17│    18│ 0.944┃
┃   4│Dくん │  10│    20│ 0.500┃
┃   5│Eくん │   7│    19│ 0.368┃
┗━━┷━━━┷━━┷━━━┷━━━┛

SELECT M.id, M.name, COUNT(S.goalMember) AS goals
FROM Score AS S, Member AS M, Game AS G
WHERE M.id = S.goalMember
AND G.id = S.gameId
GROUP BY S.goalMember
ORDER BY goals DESC

SELECT M.id, M.name

     , S.cnt

     , G.cnt

     , S.cnt*1.000/G.cnt

  FROM Member M

     , TABLE

       (SELECT COUNT(S.goalMember)

          FROM Score S

         WHERE M.id = S.goalMember

       ) S (cnt)

     , TABLE

       (SELECT COUNT(GE.gameId)

          FROM GameEntry GE

         WHERE M.id = GE.memberId

       ) G (cnt)

 ORDER BY

       S.cnt DESC

SELECT M.id, M.name

     , COUNT(DISTINCT S.gameId*100+S.sequence) AS goals

     , COUNT(DISTINCT E.gameId)                AS games

     , COUNT(DISTINCT S.gameId*100+S.sequence)

        / COUNT(DISTINCT E.gameId)             AS ratio

  FROM Member    M

     , Score     S

     , GameEntry E

 WHERE M.id = S.goalMember

   AND M.id = E.memberId

 GROUP BY

       M.id, M.name

 ORDER BY

       goals DESC