Mysql 子查询是否可以按主查询中的列进行分组

有没有办法将子查询按字段分组？我正在try 让以下内容发挥作用；该表是RetroSheet MLB比赛日志(log)，我正在获取按主队分组的H/HR/RBI等统计数据(此查询按西雅图水手队为客队的比赛进行过滤)

子查询值给出了胜负的完整列表，有没有办法将它们按主队分组？

-- mariners batting avg at away parks

SELECT 
    count(entry_id) G,
    (SELECT 
            COUNT(home_team)
        FROM
            GAME_LOG_ENTRY
        WHERE
            home_team_score > visitor_team_score
                AND game_date > '2017-01-01'
                AND home_team = 'SEA') W,
    (SELECT 
            COUNT(home_team)
        FROM
            GAME_LOG_ENTRY
        WHERE
            home_team_score < visitor_team_score
                AND game_date > '2017-01-01'
                AND home_team = 'SEA') L,
        
    SUM(visitor_at_bats) AB,
    SUM(visitor_hits) H,
    ROUND((SUM(visitor_hits) / SUM(visitor_at_bats)),
            3) AVG,
    SUM(visitor_home_runs) HR,
    SUM(visitor_doubles) doubles,
    SUM(visitor_triples) triples,
    SUM(visitor_rbi) rbi,
    SUM(visitor_so) SO,
    SUM(visitor_bb) BB,
    SUM(visitor_lob) LOB,
    home_team
FROM
    GAME_LOG_ENTRY
WHERE
    visit_team = 'SEA'
        AND home_league = 'AL'
        AND game_date > '2017-01-01'
GROUP BY home_team, W, L
ORDER BY W desc

跟进

我能够执行如下查询:

select game_date,
(home_team_score < visitor_team_score) 'W/L'
FROM GAME_LOG_ENTRY

并获得正确的输出 ‘2022-04-07 00:00:00’，‘1’ ‘2022-04-07 00:00:00’，‘0’

等等，但我无法在主场得分大于客场得分的情况下获得计数.当我试着这样做的时候，我得到了比赛的总数.