Query assistant for nfl

CREATE TABLE "players" (
"player_id" TEXT,
  "player_display_name" TEXT,
  "position" TEXT,
  "recent_team" TEXT,
  "season" INTEGER,
  "week" INTEGER,
  "completions" INTEGER,
  "attempts" INTEGER,
  "passing_yards" REAL,
  "passing_tds" INTEGER,
  "interceptions" REAL,
  "sacks" REAL,
  "sack_yards" REAL,
  "sack_fumbles" INTEGER,
  "sack_fumbles_lost" INTEGER,
  "passing_air_yards" REAL,
  "passing_yards_after_catch" REAL,
  "passing_first_downs" REAL,
  "passing_2pt_conversions" INTEGER,
  "carries" INTEGER,
  "rushing_yards" REAL,
  "rushing_tds" INTEGER,
  "rushing_fumbles" REAL,
  "rushing_fumbles_lost" REAL,
  "rushing_first_downs" REAL,
  "rushing_2pt_conversions" INTEGER,
  "receptions" INTEGER,
  "targets" INTEGER,
  "receiving_yards" REAL,
  "receiving_tds" INTEGER,
  "receiving_fumbles" REAL,
  "receiving_fumbles_lost" REAL,
  "receiving_air_yards" REAL,
  "receiving_yards_after_catch" REAL,
  "receiving_first_downs" REAL,
  "receiving_2pt_conversions" INTEGER,
  "special_teams_tds" REAL,
  "fantasy_points" REAL,
  "fantasy_points_ppr" REAL,
  "opponent_team" TEXT
);
CREATE VIEW players_yearly AS
    SELECT
        player_id,
        player_display_name,
        position,
        GROUP_CONCAT(DISTINCT recent_team) AS recent_teams,
        season,
        count(*) AS games_played,
        SUM(completions) AS completions,
        SUM(attempts) AS attempts,
        SUM(passing_yards) AS passing_yards,
        SUM(passing_tds) AS passing_tds,
        SUM(interceptions) AS interceptions,
        SUM(sacks) AS sacks,
        SUM(sack_yards) AS sack_yards,
        SUM(sack_fumbles) AS sack_fumbles,
        SUM(sack_fumbles_lost) AS sack_fumbles_lost,
        SUM(passing_air_yards) AS passing_air_yards,
        SUM(passing_yards_after_catch) AS passing_yards_after_catch,
        SUM(passing_first_downs) AS passing_first_downs,
        SUM(passing_2pt_conversions) AS passing_2pt_conversions,
        SUM(carries) AS carries,
        SUM(rushing_yards) AS rushing_yards,
        SUM(rushing_tds) AS rushing_tds,
        SUM(rushing_fumbles) AS rushing_fumbles,
        SUM(rushing_fumbles_lost) AS rushing_fumbles_lost,
        SUM(rushing_first_downs) AS rushing_first_downs,
        SUM(rushing_2pt_conversions) AS rushing_2pt_conversions,
        SUM(receptions) AS receptions,
        SUM(targets) AS targets,
        SUM(receiving_yards) AS receiving_yards,
        SUM(receiving_tds) AS receiving_tds,
        SUM(receiving_fumbles) AS receiving_fumbles,
        SUM(receiving_fumbles_lost) AS receiving_fumbles_lost,
        SUM(receiving_air_yards) AS receiving_air_yards,
        SUM(receiving_yards_after_catch) AS receiving_yards_after_catch,
        SUM(receiving_first_downs) AS receiving_first_downs,
        SUM(receiving_2pt_conversions) AS receiving_2pt_conversions,
        SUM(special_teams_tds) AS special_teams_tds,
        SUM(fantasy_points) AS fantasy_points,
        SUM(fantasy_points_ppr) AS fantasy_points_ppr
    FROM players
    GROUP BY player_id, player_display_name, position, season