sqlite006.sql

  SELECT 
      SEASON_ID-20000 AS season,
      TEAM_ID_HOME AS team_id,
      TEAM_NAME_HOME AS team_name,
      FG3_PCT_HOME AS three_point_percentage,
      COUNT(TEAM_ID_HOME) AS team_game_count,
      "home" AS game_location
  FROM Game
  GROUP BY SEASON_ID, TEAM_ID_HOME 

  UNION

  SELECT 
      SEASON_ID-20000 AS season,
      TEAM_ID_AWAY AS team_id,
      TEAM_NAME_AWAY AS team_name,
      FG3_PCT_AWAY AS three_point_percentage,
      COUNT(TEAM_ID_AWAY) AS team_game_count,
      "away" AS game_location
  FROM Game
  GROUP BY SEASON_ID, TEAM_ID_AWAY