{"queries":[{"id":"season_types","compiledQueryString":"-- Defines the shared regular season and postseason filter options.\n\nSELECT 'REG' AS value, 'Regular Season' AS label, 1 AS sort_order\nUNION ALL\nSELECT 'ACC', 'ACC Post Season', 2\nUNION ALL\nSELECT 'NCAA', 'NCAA Post Season', 3\nORDER BY sort_order","inputQueryString":"-- Defines the shared regular season and postseason filter options.\n\nSELECT 'REG' AS value, 'Regular Season' AS label, 1 AS sort_order\nUNION ALL\nSELECT 'ACC', 'ACC Post Season', 2\nUNION ALL\nSELECT 'NCAA', 'NCAA Post Season', 3\nORDER BY sort_order","compiled":false,"inline":false},{"id":"team_pitching_records","compiledQueryString":"-- Builds Clemson team pitching records across single-game, season, totals, and streak categories.\n-- Combined page-local SQL for pages/team-records/pitching/index.md.\n-- Filter this query in the page with RecordKey to retrieve each record table.\n\nSELECT 'team_pitching_single_game_innings_pitched' AS RecordKey, *\nFROM (\n WITH Ranked AS (\n SELECT RANK() OVER (ORDER BY TotalOuts DESC) AS Rank, *\n FROM (\n WITH Stats AS (\n SELECT\n GameID,\n GameDate,\n Season,\n Opponent,\n CONCAT(WinLoss, ' ', CAST(TeamRuns AS INT), '-', CAST(OpponentRuns AS INT)) AS Score,\n CASE WHEN GameID IS NOT NULL THEN CONCAT('/game-snapshot/', CAST(GameID AS VARCHAR)) ELSE NULL END AS link,\n (\n CAST(FLOOR(COALESCE(Pitching_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(Pitching_InningsPitched, 0) - FLOOR(COALESCE(Pitching_InningsPitched, 0))) * 10) AS INTEGER)\n ) AS TotalOuts,\n FLOOR((\n CAST(FLOOR(COALESCE(Pitching_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(Pitching_InningsPitched, 0) - FLOOR(COALESCE(Pitching_InningsPitched, 0))) * 10) AS INTEGER)\n ) / 3.0)\n + (MOD((\n CAST(FLOOR(COALESCE(Pitching_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(Pitching_InningsPitched, 0) - FLOOR(COALESCE(Pitching_InningsPitched, 0))) * 10) AS INTEGER)\n ), 3) / 10.0) AS InningsPitched,\n COALESCE(Pitching_StrikeOuts, 0) AS Strikeouts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_team_stats_by_game\n WHERE IsClemson = 1\n AND SeasonType IN ${inputs.single_game.value}\n )\n SELECT *\n FROM Stats\n )\n WHERE TotalOuts > 0\n )\n SELECT Rank, Season, GameDate, Opponent, Score, InningsPitched, TotalOuts, GameID, link\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, GameDate DESC, GameID DESC\n) AS team_pitching_single_game_innings_pitched\n\nUNION ALL BY NAME\n\nSELECT 'team_pitching_single_game_strikeouts' AS RecordKey, *\nFROM (\n WITH Ranked AS (\n SELECT RANK() OVER (ORDER BY Strikeouts DESC) AS Rank, *\n FROM (\n WITH Stats AS (\n SELECT\n GameID,\n GameDate,\n Season,\n Opponent,\n CONCAT(WinLoss, ' ', CAST(TeamRuns AS INT), '-', CAST(OpponentRuns AS INT)) AS Score,\n CASE WHEN GameID IS NOT NULL THEN CONCAT('/game-snapshot/', CAST(GameID AS VARCHAR)) ELSE NULL END AS link,\n (\n CAST(FLOOR(COALESCE(Pitching_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(Pitching_InningsPitched, 0) - FLOOR(COALESCE(Pitching_InningsPitched, 0))) * 10) AS INTEGER)\n ) AS TotalOuts,\n FLOOR((\n CAST(FLOOR(COALESCE(Pitching_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(Pitching_InningsPitched, 0) - FLOOR(COALESCE(Pitching_InningsPitched, 0))) * 10) AS INTEGER)\n ) / 3.0)\n + (MOD((\n CAST(FLOOR(COALESCE(Pitching_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(Pitching_InningsPitched, 0) - FLOOR(COALESCE(Pitching_InningsPitched, 0))) * 10) AS INTEGER)\n ), 3) / 10.0) AS InningsPitched,\n COALESCE(Pitching_StrikeOuts, 0) AS Strikeouts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_team_stats_by_game\n WHERE IsClemson = 1\n AND SeasonType IN ${inputs.single_game.value}\n )\n SELECT *\n FROM Stats\n )\n WHERE Strikeouts > 0\n )\n SELECT Rank, Season, GameDate, Opponent, Score, Strikeouts, GameID, link\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, GameDate DESC, GameID DESC\n) AS team_pitching_single_game_strikeouts\n\nUNION ALL BY NAME\n\nSELECT 'team_pitching_innings_pitched' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n Season,\n CAST(NULL AS VARCHAR) AS GameID,\n CAST(NULL AS VARCHAR) AS link,\n COUNT(*) AS GamesPlayed,\n SUM(CASE WHEN WinLoss = 'W' THEN 1 ELSE 0 END) AS Wins,\n SUM(CASE WHEN WinLoss = 'L' THEN 1 ELSE 0 END) AS Losses,\n SUM(\n CAST(FLOOR(COALESCE(Pitching_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(Pitching_InningsPitched, 0) - FLOOR(COALESCE(Pitching_InningsPitched, 0))) * 10) AS INTEGER)\n ) AS TotalOuts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_team_stats_by_game\n WHERE IsClemson = 1 AND SeasonType IN ${inputs.season.value}\n GROUP BY Season\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY TotalOuts DESC) AS Rank,\n Season,\n GameID,\n link,\n GamesPlayed,\n Wins,\n Losses,\n FLOOR(TotalOuts / 3.0) + (MOD(TotalOuts, 3) / 10.0) AS InningsPitched,\n TotalOuts,\n ROUND((TotalOuts / 3.0) / NULLIF(GamesPlayed, 0), 1) AS AvgPerGame\n FROM Base\n )\n SELECT\n *,\n CAST(Wins AS VARCHAR) || '-' || CAST(Losses AS VARCHAR) AS WinLossRecord\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, Season DESC\n) AS team_pitching_innings_pitched\n\nUNION ALL BY NAME\n\nSELECT 'team_pitching_strikeouts' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n Season,\n CAST(NULL AS VARCHAR) AS GameID,\n CAST(NULL AS VARCHAR) AS link,\n COUNT(*) AS GamesPlayed,\n SUM(CASE WHEN WinLoss = 'W' THEN 1 ELSE 0 END) AS Wins,\n SUM(CASE WHEN WinLoss = 'L' THEN 1 ELSE 0 END) AS Losses,\n SUM(COALESCE(Pitching_StrikeOuts, 0)) AS Strikeouts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_team_stats_by_game\n WHERE IsClemson = 1 AND SeasonType IN ${inputs.season.value}\n GROUP BY Season\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY Strikeouts DESC) AS Rank,\n Season,\n GameID,\n link,\n GamesPlayed,\n Wins,\n Losses,\n Strikeouts,\n ROUND(Strikeouts * 1.0 / NULLIF(GamesPlayed, 0), 1) AS AvgPerGame\n FROM Base\n )\n SELECT\n *,\n CAST(Wins AS VARCHAR) || '-' || CAST(Losses AS VARCHAR) AS WinLossRecord\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, Season DESC\n) AS team_pitching_strikeouts\n\nUNION ALL BY NAME\n\nSELECT 'team_pitching_victories' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n Season,\n CAST(NULL AS VARCHAR) AS GameID,\n CAST(NULL AS VARCHAR) AS link,\n COUNT(*) AS GamesPlayed,\n SUM(CASE WHEN WinLoss = 'W' THEN 1 ELSE 0 END) AS Victories,\n SUM(CASE WHEN WinLoss = 'L' THEN 1 ELSE 0 END) AS Losses\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_team_stats_by_game\n WHERE IsClemson = 1 AND SeasonType IN ${inputs.season.value}\n GROUP BY Season\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY Victories DESC) AS Rank,\n Season,\n GameID,\n link,\n GamesPlayed,\n Victories,\n Losses,\n CAST(Victories AS VARCHAR) || '-' || CAST(Losses AS VARCHAR) AS WinLossRecord\n FROM Base\n WHERE Victories > 0\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, Season DESC\n) AS team_pitching_victories\n\nUNION ALL BY NAME\n\nSELECT 'team_pitching_era' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n Season,\n CAST(NULL AS VARCHAR) AS GameID,\n CAST(NULL AS VARCHAR) AS link,\n COUNT(*) AS GamesPlayed,\n SUM(CASE WHEN WinLoss = 'W' THEN 1 ELSE 0 END) AS Wins,\n SUM(CASE WHEN WinLoss = 'L' THEN 1 ELSE 0 END) AS Losses,\n SUM(COALESCE(Pitching_EarnedRuns, 0)) AS EarnedRuns,\n SUM(\n CAST(FLOOR(COALESCE(Pitching_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(Pitching_InningsPitched, 0) - FLOOR(COALESCE(Pitching_InningsPitched, 0))) * 10) AS INTEGER)\n ) AS TotalOuts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_team_stats_by_game\n WHERE IsClemson = 1 AND SeasonType IN ${inputs.season.value}\n GROUP BY Season\n ),\n Calculated AS (\n SELECT\n Season,\n GameID,\n link,\n GamesPlayed,\n Wins,\n Losses,\n EarnedRuns,\n FLOOR(TotalOuts / 3.0) + (MOD(TotalOuts, 3) / 10.0) AS InningsPitched,\n ROUND(EarnedRuns * 7.0 / NULLIF(TotalOuts / 3.0, 0), 2) AS ERA\n FROM Base\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY ERA ASC NULLS LAST) AS Rank,\n Season,\n GameID,\n link,\n GamesPlayed,\n Wins,\n Losses,\n EarnedRuns,\n InningsPitched,\n ERA,\n ROUND(ERA * 1.0 / NULLIF(GamesPlayed, 0), 1) AS AvgPerGame\n FROM Calculated\n )\n SELECT\n *,\n CAST(Wins AS VARCHAR) || '-' || CAST(Losses AS VARCHAR) AS WinLossRecord\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, Season DESC\n) AS team_pitching_era\n\nUNION ALL BY NAME\n\nSELECT 'team_pitching_walks_allowed' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n Season,\n CAST(NULL AS VARCHAR) AS GameID,\n CAST(NULL AS VARCHAR) AS link,\n COUNT(*) AS GamesPlayed,\n SUM(CASE WHEN WinLoss = 'W' THEN 1 ELSE 0 END) AS Wins,\n SUM(CASE WHEN WinLoss = 'L' THEN 1 ELSE 0 END) AS Losses,\n SUM(COALESCE(Pitching_BaseOnBalls, 0)) AS WalksAllowed\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_team_stats_by_game\n WHERE IsClemson = 1 AND SeasonType IN ${inputs.season.value}\n GROUP BY Season\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY WalksAllowed ASC) AS Rank,\n Season,\n GameID,\n link,\n GamesPlayed,\n Wins,\n Losses,\n WalksAllowed,\n ROUND(WalksAllowed * 1.0 / NULLIF(GamesPlayed, 0), 1) AS AvgPerGame\n FROM Base\n )\n SELECT\n *,\n CAST(Wins AS VARCHAR) || '-' || CAST(Losses AS VARCHAR) AS WinLossRecord\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, Season DESC\n) AS team_pitching_walks_allowed\n\nUNION ALL BY NAME\n\nSELECT 'team_pitching_hits_allowed' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n Season,\n CAST(NULL AS VARCHAR) AS GameID,\n CAST(NULL AS VARCHAR) AS link,\n COUNT(*) AS GamesPlayed,\n SUM(CASE WHEN WinLoss = 'W' THEN 1 ELSE 0 END) AS Wins,\n SUM(CASE WHEN WinLoss = 'L' THEN 1 ELSE 0 END) AS Losses,\n SUM(COALESCE(Pitching_Hits, 0)) AS HitsAllowed\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_team_stats_by_game\n WHERE IsClemson = 1 AND SeasonType IN ${inputs.season.value}\n GROUP BY Season\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY HitsAllowed ASC) AS Rank,\n Season,\n GameID,\n link,\n GamesPlayed,\n Wins,\n Losses,\n HitsAllowed,\n ROUND(HitsAllowed * 1.0 / NULLIF(GamesPlayed, 0), 1) AS AvgPerGame\n FROM Base\n )\n SELECT\n *,\n CAST(Wins AS VARCHAR) || '-' || CAST(Losses AS VARCHAR) AS WinLossRecord\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, Season DESC\n) AS team_pitching_hits_allowed\n\nUNION ALL BY NAME\n\nSELECT 'team_pitching_runs_allowed' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n Season,\n CAST(NULL AS VARCHAR) AS GameID,\n CAST(NULL AS VARCHAR) AS link,\n COUNT(*) AS GamesPlayed,\n SUM(CASE WHEN WinLoss = 'W' THEN 1 ELSE 0 END) AS Wins,\n SUM(CASE WHEN WinLoss = 'L' THEN 1 ELSE 0 END) AS Losses,\n SUM(COALESCE(Pitching_Runs, 0)) AS RunsAllowed\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_team_stats_by_game\n WHERE IsClemson = 1 AND SeasonType IN ${inputs.season.value}\n GROUP BY Season\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY RunsAllowed ASC) AS Rank,\n Season,\n GameID,\n link,\n GamesPlayed,\n Wins,\n Losses,\n RunsAllowed,\n ROUND(RunsAllowed * 1.0 / NULLIF(GamesPlayed, 0), 1) AS AvgPerGame\n FROM Base\n )\n SELECT\n *,\n CAST(Wins AS VARCHAR) || '-' || CAST(Losses AS VARCHAR) AS WinLossRecord\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, Season DESC\n) AS team_pitching_runs_allowed\n\nUNION ALL BY NAME\n\nSELECT 'team_pitching_saves' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n Season,\n CAST(NULL AS VARCHAR) AS GameID,\n CAST(NULL AS VARCHAR) AS link,\n COUNT(*) AS GamesPlayed,\n SUM(CASE WHEN WinLoss = 'W' THEN 1 ELSE 0 END) AS Wins,\n SUM(CASE WHEN WinLoss = 'L' THEN 1 ELSE 0 END) AS Losses,\n SUM(COALESCE(Pitching_Save, 0)) AS Saves\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_team_stats_by_game\n WHERE IsClemson = 1 AND SeasonType IN ${inputs.season.value}\n GROUP BY Season\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY Saves DESC) AS Rank,\n Season,\n GameID,\n link,\n GamesPlayed,\n Wins,\n Losses,\n Saves,\n ROUND(Saves * 1.0 / NULLIF(GamesPlayed, 0), 1) AS AvgPerGame\n FROM Base\n )\n SELECT\n *,\n CAST(Wins AS VARCHAR) || '-' || CAST(Losses AS VARCHAR) AS WinLossRecord\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, Season DESC\n) AS team_pitching_saves\n\nUNION ALL BY NAME\n\nSELECT 'team_pitching_shutouts' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n Season,\n CAST(NULL AS VARCHAR) AS GameID,\n CAST(NULL AS VARCHAR) AS link,\n COUNT(*) AS GamesPlayed,\n SUM(CASE WHEN WinLoss = 'W' THEN 1 ELSE 0 END) AS Wins,\n SUM(CASE WHEN WinLoss = 'L' THEN 1 ELSE 0 END) AS Losses,\n SUM(COALESCE(Pitching_ShutOut, 0)) AS Shutouts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_team_stats_by_game\n WHERE IsClemson = 1 AND SeasonType IN ${inputs.season.value}\n GROUP BY Season\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY Shutouts DESC) AS Rank,\n Season,\n GameID,\n link,\n GamesPlayed,\n Wins,\n Losses,\n Shutouts,\n ROUND(Shutouts * 1.0 / NULLIF(GamesPlayed, 0), 1) AS AvgPerGame\n FROM Base\n )\n SELECT\n *,\n CAST(Wins AS VARCHAR) || '-' || CAST(Losses AS VARCHAR) AS WinLossRecord\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, Season DESC\n) AS team_pitching_shutouts\n\nUNION ALL BY NAME\n\nSELECT 'team_pitching_shutout_streak' AS RecordKey, *\nFROM (\n WITH GameShutouts AS (\n SELECT\n GameID,\n GameDate,\n Season,\n Opponent,\n CASE WHEN OpponentRuns = 0 THEN 1 ELSE 0 END AS IsShutout\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_team_stats_by_game\n WHERE IsClemson = 1 AND SeasonType IN ${inputs.season.value}\n ),\n SI AS (\n SELECT\n GameID,\n GameDate,\n Season,\n Opponent,\n IsShutout,\n (ROW_NUMBER() OVER (ORDER BY GameDate, GameID)) -\n (ROW_NUMBER() OVER (PARTITION BY IsShutout ORDER BY GameDate, GameID)) AS StreakID\n FROM GameShutouts\n ),\n SL AS (\n SELECT\n IsShutout,\n COUNT(*) AS StreakLength,\n MIN(GameDate) AS StreakStart,\n MAX(GameDate) AS StreakEnd,\n CAST(NULL AS VARCHAR) AS GameID,\n CAST(NULL AS VARCHAR) AS link\n FROM SI\n GROUP BY IsShutout, StreakID\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY StreakLength DESC) AS Rank,\n StreakLength,\n StreakStart,\n StreakEnd,\n GameID,\n link\n FROM SL\n WHERE IsShutout = 1\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, StreakStart DESC\n) AS team_pitching_shutout_streak\n\nUNION ALL BY NAME\n\nSELECT 'team_pitching_home_runs_allowed' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n Season,\n CAST(NULL AS VARCHAR) AS GameID,\n CAST(NULL AS VARCHAR) AS link,\n COUNT(*) AS GamesPlayed,\n SUM(CASE WHEN WinLoss = 'W' THEN 1 ELSE 0 END) AS Wins,\n SUM(CASE WHEN WinLoss = 'L' THEN 1 ELSE 0 END) AS Losses,\n SUM(COALESCE(Pitching_HomeRuns, 0)) AS HomeRunsAllowed\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_team_stats_by_game\n WHERE IsClemson = 1 AND SeasonType IN ${inputs.season.value}\n GROUP BY Season\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY HomeRunsAllowed ASC) AS Rank,\n Season,\n GameID,\n link,\n GamesPlayed,\n Wins,\n Losses,\n HomeRunsAllowed,\n ROUND(HomeRunsAllowed * 1.0 / NULLIF(GamesPlayed, 0), 1) AS AvgPerGame\n FROM Base\n )\n SELECT\n *,\n CAST(Wins AS VARCHAR) || '-' || CAST(Losses AS VARCHAR) AS WinLossRecord\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, Season DESC\n) AS team_pitching_home_runs_allowed","inputQueryString":"-- Builds Clemson team pitching records across single-game, season, totals, and streak categories.\n-- Combined page-local SQL for pages/team-records/pitching/index.md.\n-- Filter this query in the page with RecordKey to retrieve each record table.\n\nSELECT 'team_pitching_single_game_innings_pitched' AS RecordKey, *\nFROM (\n WITH Ranked AS (\n SELECT RANK() OVER (ORDER BY TotalOuts DESC) AS Rank, *\n FROM (\n WITH Stats AS (\n SELECT\n GameID,\n GameDate,\n Season,\n Opponent,\n CONCAT(WinLoss, ' ', CAST(TeamRuns AS INT), '-', CAST(OpponentRuns AS INT)) AS Score,\n CASE WHEN GameID IS NOT NULL THEN CONCAT('/game-snapshot/', CAST(GameID AS VARCHAR)) ELSE NULL END AS link,\n (\n CAST(FLOOR(COALESCE(Pitching_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(Pitching_InningsPitched, 0) - FLOOR(COALESCE(Pitching_InningsPitched, 0))) * 10) AS INTEGER)\n ) AS TotalOuts,\n FLOOR((\n CAST(FLOOR(COALESCE(Pitching_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(Pitching_InningsPitched, 0) - FLOOR(COALESCE(Pitching_InningsPitched, 0))) * 10) AS INTEGER)\n ) / 3.0)\n + (MOD((\n CAST(FLOOR(COALESCE(Pitching_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(Pitching_InningsPitched, 0) - FLOOR(COALESCE(Pitching_InningsPitched, 0))) * 10) AS INTEGER)\n ), 3) / 10.0) AS InningsPitched,\n COALESCE(Pitching_StrikeOuts, 0) AS Strikeouts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_team_stats_by_game\n WHERE IsClemson = 1\n AND SeasonType IN ${inputs.single_game.value}\n )\n SELECT *\n FROM Stats\n )\n WHERE TotalOuts > 0\n )\n SELECT Rank, Season, GameDate, Opponent, Score, InningsPitched, TotalOuts, GameID, link\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, GameDate DESC, GameID DESC\n) AS team_pitching_single_game_innings_pitched\n\nUNION ALL BY NAME\n\nSELECT 'team_pitching_single_game_strikeouts' AS RecordKey, *\nFROM (\n WITH Ranked AS (\n SELECT RANK() OVER (ORDER BY Strikeouts DESC) AS Rank, *\n FROM (\n WITH Stats AS (\n SELECT\n GameID,\n GameDate,\n Season,\n Opponent,\n CONCAT(WinLoss, ' ', CAST(TeamRuns AS INT), '-', CAST(OpponentRuns AS INT)) AS Score,\n CASE WHEN GameID IS NOT NULL THEN CONCAT('/game-snapshot/', CAST(GameID AS VARCHAR)) ELSE NULL END AS link,\n (\n CAST(FLOOR(COALESCE(Pitching_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(Pitching_InningsPitched, 0) - FLOOR(COALESCE(Pitching_InningsPitched, 0))) * 10) AS INTEGER)\n ) AS TotalOuts,\n FLOOR((\n CAST(FLOOR(COALESCE(Pitching_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(Pitching_InningsPitched, 0) - FLOOR(COALESCE(Pitching_InningsPitched, 0))) * 10) AS INTEGER)\n ) / 3.0)\n + (MOD((\n CAST(FLOOR(COALESCE(Pitching_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(Pitching_InningsPitched, 0) - FLOOR(COALESCE(Pitching_InningsPitched, 0))) * 10) AS INTEGER)\n ), 3) / 10.0) AS InningsPitched,\n COALESCE(Pitching_StrikeOuts, 0) AS Strikeouts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_team_stats_by_game\n WHERE IsClemson = 1\n AND SeasonType IN ${inputs.single_game.value}\n )\n SELECT *\n FROM Stats\n )\n WHERE Strikeouts > 0\n )\n SELECT Rank, Season, GameDate, Opponent, Score, Strikeouts, GameID, link\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, GameDate DESC, GameID DESC\n) AS team_pitching_single_game_strikeouts\n\nUNION ALL BY NAME\n\nSELECT 'team_pitching_innings_pitched' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n Season,\n CAST(NULL AS VARCHAR) AS GameID,\n CAST(NULL AS VARCHAR) AS link,\n COUNT(*) AS GamesPlayed,\n SUM(CASE WHEN WinLoss = 'W' THEN 1 ELSE 0 END) AS Wins,\n SUM(CASE WHEN WinLoss = 'L' THEN 1 ELSE 0 END) AS Losses,\n SUM(\n CAST(FLOOR(COALESCE(Pitching_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(Pitching_InningsPitched, 0) - FLOOR(COALESCE(Pitching_InningsPitched, 0))) * 10) AS INTEGER)\n ) AS TotalOuts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_team_stats_by_game\n WHERE IsClemson = 1 AND SeasonType IN ${inputs.season.value}\n GROUP BY Season\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY TotalOuts DESC) AS Rank,\n Season,\n GameID,\n link,\n GamesPlayed,\n Wins,\n Losses,\n FLOOR(TotalOuts / 3.0) + (MOD(TotalOuts, 3) / 10.0) AS InningsPitched,\n TotalOuts,\n ROUND((TotalOuts / 3.0) / NULLIF(GamesPlayed, 0), 1) AS AvgPerGame\n FROM Base\n )\n SELECT\n *,\n CAST(Wins AS VARCHAR) || '-' || CAST(Losses AS VARCHAR) AS WinLossRecord\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, Season DESC\n) AS team_pitching_innings_pitched\n\nUNION ALL BY NAME\n\nSELECT 'team_pitching_strikeouts' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n Season,\n CAST(NULL AS VARCHAR) AS GameID,\n CAST(NULL AS VARCHAR) AS link,\n COUNT(*) AS GamesPlayed,\n SUM(CASE WHEN WinLoss = 'W' THEN 1 ELSE 0 END) AS Wins,\n SUM(CASE WHEN WinLoss = 'L' THEN 1 ELSE 0 END) AS Losses,\n SUM(COALESCE(Pitching_StrikeOuts, 0)) AS Strikeouts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_team_stats_by_game\n WHERE IsClemson = 1 AND SeasonType IN ${inputs.season.value}\n GROUP BY Season\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY Strikeouts DESC) AS Rank,\n Season,\n GameID,\n link,\n GamesPlayed,\n Wins,\n Losses,\n Strikeouts,\n ROUND(Strikeouts * 1.0 / NULLIF(GamesPlayed, 0), 1) AS AvgPerGame\n FROM Base\n )\n SELECT\n *,\n CAST(Wins AS VARCHAR) || '-' || CAST(Losses AS VARCHAR) AS WinLossRecord\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, Season DESC\n) AS team_pitching_strikeouts\n\nUNION ALL BY NAME\n\nSELECT 'team_pitching_victories' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n Season,\n CAST(NULL AS VARCHAR) AS GameID,\n CAST(NULL AS VARCHAR) AS link,\n COUNT(*) AS GamesPlayed,\n SUM(CASE WHEN WinLoss = 'W' THEN 1 ELSE 0 END) AS Victories,\n SUM(CASE WHEN WinLoss = 'L' THEN 1 ELSE 0 END) AS Losses\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_team_stats_by_game\n WHERE IsClemson = 1 AND SeasonType IN ${inputs.season.value}\n GROUP BY Season\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY Victories DESC) AS Rank,\n Season,\n GameID,\n link,\n GamesPlayed,\n Victories,\n Losses,\n CAST(Victories AS VARCHAR) || '-' || CAST(Losses AS VARCHAR) AS WinLossRecord\n FROM Base\n WHERE Victories > 0\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, Season DESC\n) AS team_pitching_victories\n\nUNION ALL BY NAME\n\nSELECT 'team_pitching_era' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n Season,\n CAST(NULL AS VARCHAR) AS GameID,\n CAST(NULL AS VARCHAR) AS link,\n COUNT(*) AS GamesPlayed,\n SUM(CASE WHEN WinLoss = 'W' THEN 1 ELSE 0 END) AS Wins,\n SUM(CASE WHEN WinLoss = 'L' THEN 1 ELSE 0 END) AS Losses,\n SUM(COALESCE(Pitching_EarnedRuns, 0)) AS EarnedRuns,\n SUM(\n CAST(FLOOR(COALESCE(Pitching_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(Pitching_InningsPitched, 0) - FLOOR(COALESCE(Pitching_InningsPitched, 0))) * 10) AS INTEGER)\n ) AS TotalOuts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_team_stats_by_game\n WHERE IsClemson = 1 AND SeasonType IN ${inputs.season.value}\n GROUP BY Season\n ),\n Calculated AS (\n SELECT\n Season,\n GameID,\n link,\n GamesPlayed,\n Wins,\n Losses,\n EarnedRuns,\n FLOOR(TotalOuts / 3.0) + (MOD(TotalOuts, 3) / 10.0) AS InningsPitched,\n ROUND(EarnedRuns * 7.0 / NULLIF(TotalOuts / 3.0, 0), 2) AS ERA\n FROM Base\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY ERA ASC NULLS LAST) AS Rank,\n Season,\n GameID,\n link,\n GamesPlayed,\n Wins,\n Losses,\n EarnedRuns,\n InningsPitched,\n ERA,\n ROUND(ERA * 1.0 / NULLIF(GamesPlayed, 0), 1) AS AvgPerGame\n FROM Calculated\n )\n SELECT\n *,\n CAST(Wins AS VARCHAR) || '-' || CAST(Losses AS VARCHAR) AS WinLossRecord\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, Season DESC\n) AS team_pitching_era\n\nUNION ALL BY NAME\n\nSELECT 'team_pitching_walks_allowed' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n Season,\n CAST(NULL AS VARCHAR) AS GameID,\n CAST(NULL AS VARCHAR) AS link,\n COUNT(*) AS GamesPlayed,\n SUM(CASE WHEN WinLoss = 'W' THEN 1 ELSE 0 END) AS Wins,\n SUM(CASE WHEN WinLoss = 'L' THEN 1 ELSE 0 END) AS Losses,\n SUM(COALESCE(Pitching_BaseOnBalls, 0)) AS WalksAllowed\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_team_stats_by_game\n WHERE IsClemson = 1 AND SeasonType IN ${inputs.season.value}\n GROUP BY Season\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY WalksAllowed ASC) AS Rank,\n Season,\n GameID,\n link,\n GamesPlayed,\n Wins,\n Losses,\n WalksAllowed,\n ROUND(WalksAllowed * 1.0 / NULLIF(GamesPlayed, 0), 1) AS AvgPerGame\n FROM Base\n )\n SELECT\n *,\n CAST(Wins AS VARCHAR) || '-' || CAST(Losses AS VARCHAR) AS WinLossRecord\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, Season DESC\n) AS team_pitching_walks_allowed\n\nUNION ALL BY NAME\n\nSELECT 'team_pitching_hits_allowed' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n Season,\n CAST(NULL AS VARCHAR) AS GameID,\n CAST(NULL AS VARCHAR) AS link,\n COUNT(*) AS GamesPlayed,\n SUM(CASE WHEN WinLoss = 'W' THEN 1 ELSE 0 END) AS Wins,\n SUM(CASE WHEN WinLoss = 'L' THEN 1 ELSE 0 END) AS Losses,\n SUM(COALESCE(Pitching_Hits, 0)) AS HitsAllowed\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_team_stats_by_game\n WHERE IsClemson = 1 AND SeasonType IN ${inputs.season.value}\n GROUP BY Season\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY HitsAllowed ASC) AS Rank,\n Season,\n GameID,\n link,\n GamesPlayed,\n Wins,\n Losses,\n HitsAllowed,\n ROUND(HitsAllowed * 1.0 / NULLIF(GamesPlayed, 0), 1) AS AvgPerGame\n FROM Base\n )\n SELECT\n *,\n CAST(Wins AS VARCHAR) || '-' || CAST(Losses AS VARCHAR) AS WinLossRecord\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, Season DESC\n) AS team_pitching_hits_allowed\n\nUNION ALL BY NAME\n\nSELECT 'team_pitching_runs_allowed' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n Season,\n CAST(NULL AS VARCHAR) AS GameID,\n CAST(NULL AS VARCHAR) AS link,\n COUNT(*) AS GamesPlayed,\n SUM(CASE WHEN WinLoss = 'W' THEN 1 ELSE 0 END) AS Wins,\n SUM(CASE WHEN WinLoss = 'L' THEN 1 ELSE 0 END) AS Losses,\n SUM(COALESCE(Pitching_Runs, 0)) AS RunsAllowed\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_team_stats_by_game\n WHERE IsClemson = 1 AND SeasonType IN ${inputs.season.value}\n GROUP BY Season\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY RunsAllowed ASC) AS Rank,\n Season,\n GameID,\n link,\n GamesPlayed,\n Wins,\n Losses,\n RunsAllowed,\n ROUND(RunsAllowed * 1.0 / NULLIF(GamesPlayed, 0), 1) AS AvgPerGame\n FROM Base\n )\n SELECT\n *,\n CAST(Wins AS VARCHAR) || '-' || CAST(Losses AS VARCHAR) AS WinLossRecord\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, Season DESC\n) AS team_pitching_runs_allowed\n\nUNION ALL BY NAME\n\nSELECT 'team_pitching_saves' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n Season,\n CAST(NULL AS VARCHAR) AS GameID,\n CAST(NULL AS VARCHAR) AS link,\n COUNT(*) AS GamesPlayed,\n SUM(CASE WHEN WinLoss = 'W' THEN 1 ELSE 0 END) AS Wins,\n SUM(CASE WHEN WinLoss = 'L' THEN 1 ELSE 0 END) AS Losses,\n SUM(COALESCE(Pitching_Save, 0)) AS Saves\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_team_stats_by_game\n WHERE IsClemson = 1 AND SeasonType IN ${inputs.season.value}\n GROUP BY Season\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY Saves DESC) AS Rank,\n Season,\n GameID,\n link,\n GamesPlayed,\n Wins,\n Losses,\n Saves,\n ROUND(Saves * 1.0 / NULLIF(GamesPlayed, 0), 1) AS AvgPerGame\n FROM Base\n )\n SELECT\n *,\n CAST(Wins AS VARCHAR) || '-' || CAST(Losses AS VARCHAR) AS WinLossRecord\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, Season DESC\n) AS team_pitching_saves\n\nUNION ALL BY NAME\n\nSELECT 'team_pitching_shutouts' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n Season,\n CAST(NULL AS VARCHAR) AS GameID,\n CAST(NULL AS VARCHAR) AS link,\n COUNT(*) AS GamesPlayed,\n SUM(CASE WHEN WinLoss = 'W' THEN 1 ELSE 0 END) AS Wins,\n SUM(CASE WHEN WinLoss = 'L' THEN 1 ELSE 0 END) AS Losses,\n SUM(COALESCE(Pitching_ShutOut, 0)) AS Shutouts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_team_stats_by_game\n WHERE IsClemson = 1 AND SeasonType IN ${inputs.season.value}\n GROUP BY Season\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY Shutouts DESC) AS Rank,\n Season,\n GameID,\n link,\n GamesPlayed,\n Wins,\n Losses,\n Shutouts,\n ROUND(Shutouts * 1.0 / NULLIF(GamesPlayed, 0), 1) AS AvgPerGame\n FROM Base\n )\n SELECT\n *,\n CAST(Wins AS VARCHAR) || '-' || CAST(Losses AS VARCHAR) AS WinLossRecord\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, Season DESC\n) AS team_pitching_shutouts\n\nUNION ALL BY NAME\n\nSELECT 'team_pitching_shutout_streak' AS RecordKey, *\nFROM (\n WITH GameShutouts AS (\n SELECT\n GameID,\n GameDate,\n Season,\n Opponent,\n CASE WHEN OpponentRuns = 0 THEN 1 ELSE 0 END AS IsShutout\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_team_stats_by_game\n WHERE IsClemson = 1 AND SeasonType IN ${inputs.season.value}\n ),\n SI AS (\n SELECT\n GameID,\n GameDate,\n Season,\n Opponent,\n IsShutout,\n (ROW_NUMBER() OVER (ORDER BY GameDate, GameID)) -\n (ROW_NUMBER() OVER (PARTITION BY IsShutout ORDER BY GameDate, GameID)) AS StreakID\n FROM GameShutouts\n ),\n SL AS (\n SELECT\n IsShutout,\n COUNT(*) AS StreakLength,\n MIN(GameDate) AS StreakStart,\n MAX(GameDate) AS StreakEnd,\n CAST(NULL AS VARCHAR) AS GameID,\n CAST(NULL AS VARCHAR) AS link\n FROM SI\n GROUP BY IsShutout, StreakID\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY StreakLength DESC) AS Rank,\n StreakLength,\n StreakStart,\n StreakEnd,\n GameID,\n link\n FROM SL\n WHERE IsShutout = 1\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, StreakStart DESC\n) AS team_pitching_shutout_streak\n\nUNION ALL BY NAME\n\nSELECT 'team_pitching_home_runs_allowed' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n Season,\n CAST(NULL AS VARCHAR) AS GameID,\n CAST(NULL AS VARCHAR) AS link,\n COUNT(*) AS GamesPlayed,\n SUM(CASE WHEN WinLoss = 'W' THEN 1 ELSE 0 END) AS Wins,\n SUM(CASE WHEN WinLoss = 'L' THEN 1 ELSE 0 END) AS Losses,\n SUM(COALESCE(Pitching_HomeRuns, 0)) AS HomeRunsAllowed\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_team_stats_by_game\n WHERE IsClemson = 1 AND SeasonType IN ${inputs.season.value}\n GROUP BY Season\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY HomeRunsAllowed ASC) AS Rank,\n Season,\n GameID,\n link,\n GamesPlayed,\n Wins,\n Losses,\n HomeRunsAllowed,\n ROUND(HomeRunsAllowed * 1.0 / NULLIF(GamesPlayed, 0), 1) AS AvgPerGame\n FROM Base\n )\n SELECT\n *,\n CAST(Wins AS VARCHAR) || '-' || CAST(Losses AS VARCHAR) AS WinLossRecord\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, Season DESC\n) AS team_pitching_home_runs_allowed","compiled":false,"inline":false}]}

Team Pitching Records

Team Single Game Pitching Records

Team Pitching Records