プレーオフで最強の選手

May 10, 2024 - nba

Luka Doncicは, ひとつのプレイオフで600PTS, 200REB, 175AST, 40STL以上を記録した最初の選手です.

シーズン	選手	PTS	AST	REB	STL
2023-24	Luka Doncic	635	178	208	41

SELECT
  SEASON_ID,
  PLAYER_ID,
  MAX(PLAYER_NAME) AS player_name,
  SUM(PTS) AS total_points,
  SUM(REB) AS total_rebounds,
  SUM(AST) AS total_assists,
  SUM(STL) AS total_steals
FROM
  `nba.leaguegamelog2_player`
WHERE
  _SEASON_TYPE = "Playoffs"
GROUP BY
  SEASON_ID,
  PLAYER_ID
HAVING
  SUM(PTS) >= 600
  AND SUM(REB) >= 200
  AND SUM(AST) >= 175
  AND SUM(STL) >= 40

もう少し条件を緩くすると, 4レコードになります. LeBron JamesとLuka Doncicになります. LeBron Jamesが3シーズン分あります.

シーズン	選手	PTS	AST	REB	STL
2012-13	LeBron James	596	152	193	41
2014-15	LeBron James	601	169	226	33
2017-18	LeBron James	748	198	200	30
2023-24	Luka Doncic	635	178	208	41

SELECT
  SEASON_ID,
  PLAYER_ID,
  MAX(PLAYER_NAME) AS player_name,
  SUM(PTS) AS total_points,
  SUM(REB) AS total_rebounds,
  SUM(AST) AS total_assists,
  SUM(STL) AS total_steals
FROM
  `nba.leaguegamelog2_player`
WHERE
  _SEASON_TYPE = "Playoffs"
GROUP BY
  SEASON_ID,
  PLAYER_ID
HAVING
  SUM(PTS) >= 560
  AND SUM(REB) >= 170
  AND SUM(AST) >= 150
  AND SUM(STL) >= 30