818,485 pitches  ·  pitch-level Statcast data  ·  2025–2026

StatChat


Prompt Log  ·  3 entries
← Back to StatChat
Transmission Log
Timestamp User Question Player SQL Rows Error
2026-04-17T19:09:50-05:00 unknown Highest batters WAR this season SELECT p.name_first || ' ' || p.name_last AS player_name, SUM(pd.delta_run_exp) / 10.0 AS approx_war FROM pitch_data pd JOIN players p ON pd.batter = p.mlbam_id GROUP BY pd.batter, p.name_first, p.name_last ORDER BY approx_war DESC LIMIT 30 30
2026-04-17T19:09:49-05:00 unknown Highest batters WAR this season SELECT p.name_first || ' ' || p.name_last AS player_name, pd.batter, MAX(pd.game_year) AS season, ROUND(SUM(pd.delta_run_exp)::numeric / 10.0, 2) AS approx_war FROM pitch_data pd JOIN players p ON pd.batter = p.mlbam_id GROUP BY pd.batter, p.name_first, p.name_last ORDER BY approx_war DESC LIMIT 30 30
2026-04-17T19:09:46-05:00 unknown Highest batters WAR this season SELECT p.name_first || ' ' || p.name_last AS player_name, pd.batter, ROUND(SUM(pd.delta_run_exp)::numeric / 9.0, 2) AS approx_war FROM pitch_data pd JOIN players p ON pd.batter = p.mlbam_id GROUP BY pd.batter, p.name_first, p.name_last ORDER BY approx_war DESC LIMIT 30 30