UsMEurNW

1CREATE TABLE IF NOT EXISTS park_factor (
2SELECT YEAR(games.date) AS year
3    , games.home_team
4    , sum(games.runs0) AS ht_runs
5    , sum(games.runs1) as away_runs
6    , round(leagues.rules_schedule_games_per_team/2,0) AS home_games
7    , x.home_losses
8FROM games 
9    INNER JOIN leagues ON games.league_id=leagues.league_id
10    INNER JOIN (
11      SELECT YEAR(games.date) as year
12          , games.home_team
13          , COUNT(*) as home_losses
14      FROM games
15      WHERE games.runs1>runs0
16      GROUP BY year, games.home_team
17      ) AS x ON x.year=games.year AND x.home_team=games.home_team
18GROUP BY year, games.home_team, home_games, home_losses );