{"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":"individual_pitching_achievement_records","compiledQueryString":"-- Builds individual Clemson pitching achievement records such as no-hitters and perfect games.\n-- Split page-local SQL for pages/individual-records/pitching/index.md.\n-- Filter this query in the page with RecordKey to retrieve each record table.\n\nSELECT 'pitching_no_hitter_events' AS RecordKey, *\nFROM (\n SELECT\n PlayerName,\n GameDate,\n Opponent,\n CASE WHEN PitcherCount > 1 THEN 'combined' ELSE 'solo' END AS NoHitterType,\n GameID,\n link\n FROM (\n WITH team_context AS (\n SELECT\n GameID,\n MAX(GameDate) AS GameDate,\n MAX(Opponent) AS Opponent,\n MAX(Pitching_Hits) AS TeamHitsAllowed,\n MAX(TeamErrors) AS TeamErrors\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_team_stats_by_game\n WHERE IsClemson = 1\n GROUP BY GameID\n ),\n pitcher_counts AS (\n SELECT\n GameID,\n COUNT(DISTINCT PlayerName) AS PitcherCount\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1\n AND Pitcher_Appearances > 0\n GROUP BY GameID\n ),\n pitcher_games AS (\n SELECT\n p.PlayerName,\n p.Season,\n p.SeasonType,\n p.GameID,\n COALESCE(t.GameDate, p.GameDate) AS GameDate,\n t.Opponent,\n COALESCE(t.TeamHitsAllowed, 999999) AS TeamHitsAllowed,\n COALESCE(t.TeamErrors, 0) AS TeamErrors,\n COALESCE(pc.PitcherCount, 1) AS PitcherCount,\n COALESCE(p.Pitcher_CompleteGames, 0) AS CompleteGames,\n COALESCE(p.Pitcher_Hits, 0) AS HitsAllowed,\n COALESCE(p.Pitcher_Runs, 0) AS RunsAllowed,\n COALESCE(p.Pitcher_BaseOnBalls, 0) AS WalksAllowed,\n COALESCE(p.Pitcher_HitByPitch, 0) AS HitByPitchAllowed,\n COALESCE(p.Pitcher_BattersFaced, 0) AS BattersFaced,\n CAST(FLOOR(COALESCE(p.Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(p.Pitcher_InningsPitched, 0) - FLOOR(COALESCE(p.Pitcher_InningsPitched, 0))) * 10) AS INTEGER) AS TotalOuts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game AS p\n LEFT JOIN team_context AS t\n ON p.GameID = t.GameID\n LEFT JOIN pitcher_counts AS pc\n ON p.GameID = pc.GameID\n WHERE p.IsClemson = 1\n AND p.Pitcher_Appearances > 0\n )\n SELECT\n PlayerName,\n Season,\n SeasonType,\n GameID,\n GameDate,\n Opponent,\n PitcherCount,\n CASE WHEN GameID IS NOT NULL THEN CONCAT('/game-snapshot/', CAST(GameID AS VARCHAR)) ELSE NULL END AS link,\n CASE\n WHEN CompleteGames >= 1\n AND HitsAllowed = 0\n AND TeamHitsAllowed = 0\n THEN 1 ELSE 0\n END AS NoHitter,\n CASE\n WHEN (CompleteGames >= 1\n AND HitsAllowed = 0\n AND TeamHitsAllowed = 0)\n OR (PitcherCount > 1\n AND TeamHitsAllowed = 0)\n THEN 1 ELSE 0\n END AS CombinedNoHitter,\n CASE\n WHEN PitcherCount = 1\n AND CompleteGames >= 1\n AND TeamHitsAllowed = 0\n AND HitsAllowed = 0\n AND RunsAllowed = 0\n AND WalksAllowed = 0\n AND HitByPitchAllowed = 0\n AND TeamErrors = 0\n AND BattersFaced = TotalOuts\n THEN 1 ELSE 0\n END AS PerfectGame\n FROM pitcher_games\n )\n WHERE SeasonType IN ${inputs.achievement.value}\n AND CombinedNoHitter = 1\n ORDER BY GameDate DESC, GameID DESC, PlayerName\n) AS pitching_no_hitter_events\n\nUNION ALL BY NAME\n\nSELECT 'pitching_perfect_game_events' AS RecordKey, *\nFROM (\n SELECT\n PlayerName,\n GameDate,\n Opponent,\n GameID,\n link\n FROM (\n WITH team_context AS (\n SELECT\n GameID,\n MAX(GameDate) AS GameDate,\n MAX(Opponent) AS Opponent,\n MAX(Pitching_Hits) AS TeamHitsAllowed,\n MAX(TeamErrors) AS TeamErrors\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_team_stats_by_game\n WHERE IsClemson = 1\n GROUP BY GameID\n ),\n pitcher_counts AS (\n SELECT\n GameID,\n COUNT(DISTINCT PlayerName) AS PitcherCount\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1\n AND Pitcher_Appearances > 0\n GROUP BY GameID\n ),\n pitcher_games AS (\n SELECT\n p.PlayerName,\n p.Season,\n p.SeasonType,\n p.GameID,\n COALESCE(t.GameDate, p.GameDate) AS GameDate,\n t.Opponent,\n COALESCE(t.TeamHitsAllowed, 999999) AS TeamHitsAllowed,\n COALESCE(t.TeamErrors, 0) AS TeamErrors,\n COALESCE(pc.PitcherCount, 1) AS PitcherCount,\n COALESCE(p.Pitcher_CompleteGames, 0) AS CompleteGames,\n COALESCE(p.Pitcher_Hits, 0) AS HitsAllowed,\n COALESCE(p.Pitcher_Runs, 0) AS RunsAllowed,\n COALESCE(p.Pitcher_BaseOnBalls, 0) AS WalksAllowed,\n COALESCE(p.Pitcher_HitByPitch, 0) AS HitByPitchAllowed,\n COALESCE(p.Pitcher_BattersFaced, 0) AS BattersFaced,\n CAST(FLOOR(COALESCE(p.Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(p.Pitcher_InningsPitched, 0) - FLOOR(COALESCE(p.Pitcher_InningsPitched, 0))) * 10) AS INTEGER) AS TotalOuts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game AS p\n LEFT JOIN team_context AS t\n ON p.GameID = t.GameID\n LEFT JOIN pitcher_counts AS pc\n ON p.GameID = pc.GameID\n WHERE p.IsClemson = 1\n AND p.Pitcher_Appearances > 0\n )\n SELECT\n PlayerName,\n Season,\n SeasonType,\n GameID,\n GameDate,\n Opponent,\n PitcherCount,\n CASE WHEN GameID IS NOT NULL THEN CONCAT('/game-snapshot/', CAST(GameID AS VARCHAR)) ELSE NULL END AS link,\n CASE\n WHEN CompleteGames >= 1\n AND HitsAllowed = 0\n AND TeamHitsAllowed = 0\n THEN 1 ELSE 0\n END AS NoHitter,\n CASE\n WHEN (CompleteGames >= 1\n AND HitsAllowed = 0\n AND TeamHitsAllowed = 0)\n OR (PitcherCount > 1\n AND TeamHitsAllowed = 0)\n THEN 1 ELSE 0\n END AS CombinedNoHitter,\n CASE\n WHEN PitcherCount = 1\n AND CompleteGames >= 1\n AND TeamHitsAllowed = 0\n AND HitsAllowed = 0\n AND RunsAllowed = 0\n AND WalksAllowed = 0\n AND HitByPitchAllowed = 0\n AND TeamErrors = 0\n AND BattersFaced = TotalOuts\n THEN 1 ELSE 0\n END AS PerfectGame\n FROM pitcher_games\n )\n WHERE SeasonType IN ${inputs.achievement.value}\n AND PerfectGame = 1\n ORDER BY GameDate DESC, GameID DESC, PlayerName\n) AS pitching_perfect_game_events","inputQueryString":"-- Builds individual Clemson pitching achievement records such as no-hitters and perfect games.\n-- Split page-local SQL for pages/individual-records/pitching/index.md.\n-- Filter this query in the page with RecordKey to retrieve each record table.\n\nSELECT 'pitching_no_hitter_events' AS RecordKey, *\nFROM (\n SELECT\n PlayerName,\n GameDate,\n Opponent,\n CASE WHEN PitcherCount > 1 THEN 'combined' ELSE 'solo' END AS NoHitterType,\n GameID,\n link\n FROM (\n WITH team_context AS (\n SELECT\n GameID,\n MAX(GameDate) AS GameDate,\n MAX(Opponent) AS Opponent,\n MAX(Pitching_Hits) AS TeamHitsAllowed,\n MAX(TeamErrors) AS TeamErrors\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_team_stats_by_game\n WHERE IsClemson = 1\n GROUP BY GameID\n ),\n pitcher_counts AS (\n SELECT\n GameID,\n COUNT(DISTINCT PlayerName) AS PitcherCount\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1\n AND Pitcher_Appearances > 0\n GROUP BY GameID\n ),\n pitcher_games AS (\n SELECT\n p.PlayerName,\n p.Season,\n p.SeasonType,\n p.GameID,\n COALESCE(t.GameDate, p.GameDate) AS GameDate,\n t.Opponent,\n COALESCE(t.TeamHitsAllowed, 999999) AS TeamHitsAllowed,\n COALESCE(t.TeamErrors, 0) AS TeamErrors,\n COALESCE(pc.PitcherCount, 1) AS PitcherCount,\n COALESCE(p.Pitcher_CompleteGames, 0) AS CompleteGames,\n COALESCE(p.Pitcher_Hits, 0) AS HitsAllowed,\n COALESCE(p.Pitcher_Runs, 0) AS RunsAllowed,\n COALESCE(p.Pitcher_BaseOnBalls, 0) AS WalksAllowed,\n COALESCE(p.Pitcher_HitByPitch, 0) AS HitByPitchAllowed,\n COALESCE(p.Pitcher_BattersFaced, 0) AS BattersFaced,\n CAST(FLOOR(COALESCE(p.Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(p.Pitcher_InningsPitched, 0) - FLOOR(COALESCE(p.Pitcher_InningsPitched, 0))) * 10) AS INTEGER) AS TotalOuts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game AS p\n LEFT JOIN team_context AS t\n ON p.GameID = t.GameID\n LEFT JOIN pitcher_counts AS pc\n ON p.GameID = pc.GameID\n WHERE p.IsClemson = 1\n AND p.Pitcher_Appearances > 0\n )\n SELECT\n PlayerName,\n Season,\n SeasonType,\n GameID,\n GameDate,\n Opponent,\n PitcherCount,\n CASE WHEN GameID IS NOT NULL THEN CONCAT('/game-snapshot/', CAST(GameID AS VARCHAR)) ELSE NULL END AS link,\n CASE\n WHEN CompleteGames >= 1\n AND HitsAllowed = 0\n AND TeamHitsAllowed = 0\n THEN 1 ELSE 0\n END AS NoHitter,\n CASE\n WHEN (CompleteGames >= 1\n AND HitsAllowed = 0\n AND TeamHitsAllowed = 0)\n OR (PitcherCount > 1\n AND TeamHitsAllowed = 0)\n THEN 1 ELSE 0\n END AS CombinedNoHitter,\n CASE\n WHEN PitcherCount = 1\n AND CompleteGames >= 1\n AND TeamHitsAllowed = 0\n AND HitsAllowed = 0\n AND RunsAllowed = 0\n AND WalksAllowed = 0\n AND HitByPitchAllowed = 0\n AND TeamErrors = 0\n AND BattersFaced = TotalOuts\n THEN 1 ELSE 0\n END AS PerfectGame\n FROM pitcher_games\n )\n WHERE SeasonType IN ${inputs.achievement.value}\n AND CombinedNoHitter = 1\n ORDER BY GameDate DESC, GameID DESC, PlayerName\n) AS pitching_no_hitter_events\n\nUNION ALL BY NAME\n\nSELECT 'pitching_perfect_game_events' AS RecordKey, *\nFROM (\n SELECT\n PlayerName,\n GameDate,\n Opponent,\n GameID,\n link\n FROM (\n WITH team_context AS (\n SELECT\n GameID,\n MAX(GameDate) AS GameDate,\n MAX(Opponent) AS Opponent,\n MAX(Pitching_Hits) AS TeamHitsAllowed,\n MAX(TeamErrors) AS TeamErrors\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_team_stats_by_game\n WHERE IsClemson = 1\n GROUP BY GameID\n ),\n pitcher_counts AS (\n SELECT\n GameID,\n COUNT(DISTINCT PlayerName) AS PitcherCount\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1\n AND Pitcher_Appearances > 0\n GROUP BY GameID\n ),\n pitcher_games AS (\n SELECT\n p.PlayerName,\n p.Season,\n p.SeasonType,\n p.GameID,\n COALESCE(t.GameDate, p.GameDate) AS GameDate,\n t.Opponent,\n COALESCE(t.TeamHitsAllowed, 999999) AS TeamHitsAllowed,\n COALESCE(t.TeamErrors, 0) AS TeamErrors,\n COALESCE(pc.PitcherCount, 1) AS PitcherCount,\n COALESCE(p.Pitcher_CompleteGames, 0) AS CompleteGames,\n COALESCE(p.Pitcher_Hits, 0) AS HitsAllowed,\n COALESCE(p.Pitcher_Runs, 0) AS RunsAllowed,\n COALESCE(p.Pitcher_BaseOnBalls, 0) AS WalksAllowed,\n COALESCE(p.Pitcher_HitByPitch, 0) AS HitByPitchAllowed,\n COALESCE(p.Pitcher_BattersFaced, 0) AS BattersFaced,\n CAST(FLOOR(COALESCE(p.Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(p.Pitcher_InningsPitched, 0) - FLOOR(COALESCE(p.Pitcher_InningsPitched, 0))) * 10) AS INTEGER) AS TotalOuts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game AS p\n LEFT JOIN team_context AS t\n ON p.GameID = t.GameID\n LEFT JOIN pitcher_counts AS pc\n ON p.GameID = pc.GameID\n WHERE p.IsClemson = 1\n AND p.Pitcher_Appearances > 0\n )\n SELECT\n PlayerName,\n Season,\n SeasonType,\n GameID,\n GameDate,\n Opponent,\n PitcherCount,\n CASE WHEN GameID IS NOT NULL THEN CONCAT('/game-snapshot/', CAST(GameID AS VARCHAR)) ELSE NULL END AS link,\n CASE\n WHEN CompleteGames >= 1\n AND HitsAllowed = 0\n AND TeamHitsAllowed = 0\n THEN 1 ELSE 0\n END AS NoHitter,\n CASE\n WHEN (CompleteGames >= 1\n AND HitsAllowed = 0\n AND TeamHitsAllowed = 0)\n OR (PitcherCount > 1\n AND TeamHitsAllowed = 0)\n THEN 1 ELSE 0\n END AS CombinedNoHitter,\n CASE\n WHEN PitcherCount = 1\n AND CompleteGames >= 1\n AND TeamHitsAllowed = 0\n AND HitsAllowed = 0\n AND RunsAllowed = 0\n AND WalksAllowed = 0\n AND HitByPitchAllowed = 0\n AND TeamErrors = 0\n AND BattersFaced = TotalOuts\n THEN 1 ELSE 0\n END AS PerfectGame\n FROM pitcher_games\n )\n WHERE SeasonType IN ${inputs.achievement.value}\n AND PerfectGame = 1\n ORDER BY GameDate DESC, GameID DESC, PlayerName\n) AS pitching_perfect_game_events","compiled":false,"inline":false},{"id":"individual_pitching_single_game_records","compiledQueryString":"-- Builds individual Clemson pitching single-game record tables.\n-- Split page-local SQL for pages/individual-records/pitching/index.md.\n-- Filter this query in the page with RecordKey to retrieve each record table.\n\nSELECT 'top_pitching_ip_single_game' AS RecordKey, *\nFROM (\n WITH Ranked AS (\n SELECT RANK() OVER (ORDER BY TotalOuts DESC) AS Rank, *\n FROM (\n WITH game_context AS (\n SELECT\n GameID,\n MAX(GameDate) AS GameDate,\n MAX(Season) AS Season,\n MAX(Opponent) AS Opponent,\n CONCAT(MAX(WinLoss), ' ', CAST(MAX(TeamRuns) AS INT), '-', CAST(MAX(OpponentRuns) AS INT)) AS Score\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_team_stats_by_game\n WHERE IsClemson = 1\n GROUP BY GameID\n ),\n stats AS (\n SELECT\n p.PlayerName,\n p.GameID,\n MAX(COALESCE(g.GameDate, p.GameDate)) AS GameDate,\n MAX(COALESCE(g.Season, p.Season)) AS Season,\n MAX(g.Opponent) AS Opponent,\n MAX(g.Score) AS Score,\n CASE WHEN p.GameID IS NOT NULL THEN CONCAT('/game-snapshot/', CAST(p.GameID AS VARCHAR)) ELSE NULL END AS link,\n SUM(\n CAST(FLOOR(COALESCE(p.Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(p.Pitcher_InningsPitched, 0) - FLOOR(COALESCE(p.Pitcher_InningsPitched, 0))) * 10) AS INTEGER)\n ) AS TotalOuts,\n SUM(COALESCE(p.Pitcher_StrikeOuts, 0)) AS Strikeouts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game AS p\n LEFT JOIN game_context AS g\n ON p.GameID = g.GameID\n WHERE p.IsClemson = 1\n AND p.Pitcher_Appearances > 0\n AND p.SeasonType IN ${inputs.single_game.value}\n GROUP BY p.PlayerName, p.GameID\n )\n SELECT\n *,\n FLOOR(TotalOuts / 3.0) + (MOD(TotalOuts, 3) / 10.0) AS InningsPitched\n FROM stats\n )\n WHERE TotalOuts > 0\n )\n SELECT Rank, PlayerName, Season, GameDate, Opponent, Score, InningsPitched, TotalOuts, GameID, link\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName, GameDate DESC, GameID DESC\n) AS top_pitching_ip_single_game\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_strikeouts_single_game' AS RecordKey, *\nFROM (\n WITH Ranked AS (\n SELECT RANK() OVER (ORDER BY Strikeouts DESC) AS Rank, *\n FROM (\n WITH game_context AS (\n SELECT\n GameID,\n MAX(GameDate) AS GameDate,\n MAX(Season) AS Season,\n MAX(Opponent) AS Opponent,\n CONCAT(MAX(WinLoss), ' ', CAST(MAX(TeamRuns) AS INT), '-', CAST(MAX(OpponentRuns) AS INT)) AS Score\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_team_stats_by_game\n WHERE IsClemson = 1\n GROUP BY GameID\n ),\n stats AS (\n SELECT\n p.PlayerName,\n p.GameID,\n MAX(COALESCE(g.GameDate, p.GameDate)) AS GameDate,\n MAX(COALESCE(g.Season, p.Season)) AS Season,\n MAX(g.Opponent) AS Opponent,\n MAX(g.Score) AS Score,\n CASE WHEN p.GameID IS NOT NULL THEN CONCAT('/game-snapshot/', CAST(p.GameID AS VARCHAR)) ELSE NULL END AS link,\n SUM(\n CAST(FLOOR(COALESCE(p.Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(p.Pitcher_InningsPitched, 0) - FLOOR(COALESCE(p.Pitcher_InningsPitched, 0))) * 10) AS INTEGER)\n ) AS TotalOuts,\n SUM(COALESCE(p.Pitcher_StrikeOuts, 0)) AS Strikeouts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game AS p\n LEFT JOIN game_context AS g\n ON p.GameID = g.GameID\n WHERE p.IsClemson = 1\n AND p.Pitcher_Appearances > 0\n AND p.SeasonType IN ${inputs.single_game.value}\n GROUP BY p.PlayerName, p.GameID\n )\n SELECT\n *,\n FLOOR(TotalOuts / 3.0) + (MOD(TotalOuts, 3) / 10.0) AS InningsPitched\n FROM stats\n )\n WHERE Strikeouts > 0\n )\n SELECT Rank, PlayerName, Season, GameDate, Opponent, Score, Strikeouts, GameID, link\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName, GameDate DESC, GameID DESC\n) AS top_pitching_strikeouts_single_game","inputQueryString":"-- Builds individual Clemson pitching single-game record tables.\n-- Split page-local SQL for pages/individual-records/pitching/index.md.\n-- Filter this query in the page with RecordKey to retrieve each record table.\n\nSELECT 'top_pitching_ip_single_game' AS RecordKey, *\nFROM (\n WITH Ranked AS (\n SELECT RANK() OVER (ORDER BY TotalOuts DESC) AS Rank, *\n FROM (\n WITH game_context AS (\n SELECT\n GameID,\n MAX(GameDate) AS GameDate,\n MAX(Season) AS Season,\n MAX(Opponent) AS Opponent,\n CONCAT(MAX(WinLoss), ' ', CAST(MAX(TeamRuns) AS INT), '-', CAST(MAX(OpponentRuns) AS INT)) AS Score\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_team_stats_by_game\n WHERE IsClemson = 1\n GROUP BY GameID\n ),\n stats AS (\n SELECT\n p.PlayerName,\n p.GameID,\n MAX(COALESCE(g.GameDate, p.GameDate)) AS GameDate,\n MAX(COALESCE(g.Season, p.Season)) AS Season,\n MAX(g.Opponent) AS Opponent,\n MAX(g.Score) AS Score,\n CASE WHEN p.GameID IS NOT NULL THEN CONCAT('/game-snapshot/', CAST(p.GameID AS VARCHAR)) ELSE NULL END AS link,\n SUM(\n CAST(FLOOR(COALESCE(p.Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(p.Pitcher_InningsPitched, 0) - FLOOR(COALESCE(p.Pitcher_InningsPitched, 0))) * 10) AS INTEGER)\n ) AS TotalOuts,\n SUM(COALESCE(p.Pitcher_StrikeOuts, 0)) AS Strikeouts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game AS p\n LEFT JOIN game_context AS g\n ON p.GameID = g.GameID\n WHERE p.IsClemson = 1\n AND p.Pitcher_Appearances > 0\n AND p.SeasonType IN ${inputs.single_game.value}\n GROUP BY p.PlayerName, p.GameID\n )\n SELECT\n *,\n FLOOR(TotalOuts / 3.0) + (MOD(TotalOuts, 3) / 10.0) AS InningsPitched\n FROM stats\n )\n WHERE TotalOuts > 0\n )\n SELECT Rank, PlayerName, Season, GameDate, Opponent, Score, InningsPitched, TotalOuts, GameID, link\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName, GameDate DESC, GameID DESC\n) AS top_pitching_ip_single_game\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_strikeouts_single_game' AS RecordKey, *\nFROM (\n WITH Ranked AS (\n SELECT RANK() OVER (ORDER BY Strikeouts DESC) AS Rank, *\n FROM (\n WITH game_context AS (\n SELECT\n GameID,\n MAX(GameDate) AS GameDate,\n MAX(Season) AS Season,\n MAX(Opponent) AS Opponent,\n CONCAT(MAX(WinLoss), ' ', CAST(MAX(TeamRuns) AS INT), '-', CAST(MAX(OpponentRuns) AS INT)) AS Score\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_team_stats_by_game\n WHERE IsClemson = 1\n GROUP BY GameID\n ),\n stats AS (\n SELECT\n p.PlayerName,\n p.GameID,\n MAX(COALESCE(g.GameDate, p.GameDate)) AS GameDate,\n MAX(COALESCE(g.Season, p.Season)) AS Season,\n MAX(g.Opponent) AS Opponent,\n MAX(g.Score) AS Score,\n CASE WHEN p.GameID IS NOT NULL THEN CONCAT('/game-snapshot/', CAST(p.GameID AS VARCHAR)) ELSE NULL END AS link,\n SUM(\n CAST(FLOOR(COALESCE(p.Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(p.Pitcher_InningsPitched, 0) - FLOOR(COALESCE(p.Pitcher_InningsPitched, 0))) * 10) AS INTEGER)\n ) AS TotalOuts,\n SUM(COALESCE(p.Pitcher_StrikeOuts, 0)) AS Strikeouts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game AS p\n LEFT JOIN game_context AS g\n ON p.GameID = g.GameID\n WHERE p.IsClemson = 1\n AND p.Pitcher_Appearances > 0\n AND p.SeasonType IN ${inputs.single_game.value}\n GROUP BY p.PlayerName, p.GameID\n )\n SELECT\n *,\n FLOOR(TotalOuts / 3.0) + (MOD(TotalOuts, 3) / 10.0) AS InningsPitched\n FROM stats\n )\n WHERE Strikeouts > 0\n )\n SELECT Rank, PlayerName, Season, GameDate, Opponent, Score, Strikeouts, GameID, link\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName, GameDate DESC, GameID DESC\n) AS top_pitching_strikeouts_single_game","compiled":false,"inline":false},{"id":"individual_pitching_season_records","compiledQueryString":"-- Builds individual Clemson pitching season record tables.\n-- Split page-local SQL for pages/individual-records/pitching/index.md.\n-- Filter this query in the page with RecordKey to retrieve each record table.\n\nSELECT *, '/player-profiles/' || PlayerName AS link\nFROM (\nSELECT 'top_pitching_season_ip_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n Season,\n SUM(\n CAST(FLOOR(COALESCE(Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(Pitcher_InningsPitched, 0) - FLOOR(COALESCE(Pitcher_InningsPitched, 0))) * 10) AS INTEGER)\n ) AS TotalOuts,\n\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.season.value}\n GROUP BY PlayerName, Season\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY TotalOuts DESC) AS Rank,\n PlayerName,\n Season,\n FLOOR(TotalOuts / 3.0) + (MOD(TotalOuts, 3) / 10.0) AS InningsPitched,\n TotalOuts\n FROM Base\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName, Season\n) AS top_pitching_season_ip_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_season_gs_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n Season,\n SUM(CASE WHEN COALESCE(Pitcher_GameStarted, 0) = 1 THEN 1 ELSE 0 END) AS GamesStarted,\n\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.season.value}\n GROUP BY PlayerName, Season\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY GamesStarted DESC) AS Rank,\n PlayerName,\n Season,\n GamesStarted\n FROM Base\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName, Season\n) AS top_pitching_season_gs_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_season_victories_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n Season,\n SUM(CASE\n WHEN NULLIF(TRIM(CAST(Pitcher_Win AS VARCHAR)), '') IS NOT NULL THEN 1\n ELSE 0\n END) AS Victories\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.season.value}\n GROUP BY PlayerName, Season\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY Victories DESC) AS Rank,\n PlayerName,\n Season,\n Victories\n FROM Base\n WHERE Victories > 0\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName, Season\n) AS top_pitching_season_victories_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_season_so_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n Season,\n SUM(COALESCE(Pitcher_StrikeOuts, 0)) AS Strikeouts,\n\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.season.value}\n GROUP BY PlayerName, Season\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY Strikeouts DESC) AS Rank,\n PlayerName,\n Season,\n Strikeouts\n FROM Base\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName, Season\n) AS top_pitching_season_so_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_season_p_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n Season,\n SUM(COALESCE(Pitcher_Pitches, 0)) AS Pitches,\n\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.season.value}\n GROUP BY PlayerName, Season\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY Pitches DESC) AS Rank,\n PlayerName,\n Season,\n Pitches\n FROM Base\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName, Season\n) AS top_pitching_season_p_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_season_s_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n Season,\n SUM(COALESCE(Pitcher_Strikes, 0)) AS Strikes\n\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.season.value}\n GROUP BY PlayerName, Season\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY Strikes DESC) AS Rank,\n PlayerName,\n Season,\n Strikes\n FROM Base\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName, Season\n) AS top_pitching_season_s_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_season_app_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n Season,\n SUM(CASE WHEN COALESCE(Pitcher_Appearances, 0) >= 1 THEN 1 ELSE 0 END) AS Appearances\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.season.value}\n GROUP BY PlayerName, Season\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY Appearances DESC) AS Rank,\n PlayerName,\n Season,\n Appearances\n FROM Base\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName, Season\n) AS top_pitching_season_app_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_season_era_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n Season,\n SUM(COALESCE(Pitcher_EarnedRuns, 0)) AS EarnedRuns,\n SUM(\n CAST(FLOOR(COALESCE(Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(Pitcher_InningsPitched, 0) - FLOOR(COALESCE(Pitcher_InningsPitched, 0))) * 10) AS INTEGER)\n ) AS TotalOuts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.season.value}\n GROUP BY PlayerName, Season\n HAVING FLOOR(TotalOuts / 3.0) + (MOD(TotalOuts, 3) / 10.0) > 30\n ),\n WithEra AS (\n SELECT\n PlayerName,\n Season,\n EarnedRuns,\n FLOOR(TotalOuts / 3.0) + (MOD(TotalOuts, 3) / 10.0) AS InningsPitched,\n CAST(EarnedRuns * 7.0 / NULLIF(TotalOuts / 3.0, 0) AS DECIMAL(10,2)) AS ERA\n FROM Base\n WHERE TotalOuts > 0\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY ERA ASC NULLS LAST) AS Rank,\n PlayerName,\n Season,\n EarnedRuns,\n InningsPitched,\n ERA\n FROM WithEra\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName, Season\n) AS top_pitching_season_era_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_season_opp_ba_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n Season,\n SUM(COALESCE(Pitcher_Hits, 0)) AS HitsAllowed,\n SUM(COALESCE(Pitcher_AtBats, 0)) AS AtBatsAgainst,\n SUM(\n CAST(FLOOR(COALESCE(Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(Pitcher_InningsPitched, 0) - FLOOR(COALESCE(Pitcher_InningsPitched, 0))) * 10) AS INTEGER)\n ) AS TotalOuts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.season.value}\n GROUP BY PlayerName, Season\n HAVING FLOOR(TotalOuts / 3.0) + (MOD(TotalOuts, 3) / 10.0) > 30\n ),\n WithOppBA AS (\n SELECT\n PlayerName,\n Season,\n HitsAllowed,\n AtBatsAgainst,\n FLOOR(TotalOuts / 3.0) + (MOD(TotalOuts, 3) / 10.0) AS InningsPitched,\n ROUND(HitsAllowed * 1.0 / NULLIF(AtBatsAgainst, 0), 3) AS OppBA\n FROM Base\n WHERE AtBatsAgainst > 0\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY OppBA ASC NULLS LAST) AS Rank,\n PlayerName,\n Season,\n OppBA,\n HitsAllowed,\n AtBatsAgainst,\n InningsPitched\n FROM WithOppBA\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName, Season\n) AS top_pitching_season_opp_ba_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_season_cg_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n Season,\n SUM(COALESCE(Pitcher_CompleteGames, 0)) AS CompleteGames\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.season.value}\n GROUP BY PlayerName, Season\n HAVING SUM(COALESCE(Pitcher_CompleteGames, 0)) > 0\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY CompleteGames DESC) AS Rank,\n PlayerName,\n Season,\n CompleteGames\n FROM Base\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName, Season\n) AS top_pitching_season_cg_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_season_save_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n Season,\n SUM(CASE WHEN COALESCE(Pitcher_Save, 0) >= 1 THEN 1 ELSE 0 END) AS Saves\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.season.value}\n GROUP BY PlayerName, Season\n HAVING SUM(CASE WHEN COALESCE(Pitcher_Save, 0) >= 1 THEN 1 ELSE 0 END) > 0\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY Saves DESC) AS Rank,\n PlayerName,\n Season,\n Saves\n FROM Base\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName, Season\n) AS top_pitching_season_save_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_season_shutout_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n Season,\n SUM(COALESCE(Pitcher_Shutout, 0)) AS SoloShutouts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.season.value}\n GROUP BY PlayerName, Season\n HAVING SUM(COALESCE(Pitcher_Shutout, 0)) > 0\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY SoloShutouts DESC) AS Rank,\n PlayerName,\n Season,\n SoloShutouts\n FROM Base\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName, Season\n) AS top_pitching_season_shutout_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_season_combined_shutout_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n Season,\n SUM(\n CASE\n WHEN COALESCE(Pitcher_Shutout, 0) >= 1 OR COALESCE(Pitcher_CombinedShutout, 0) >= 1 THEN 1\n ELSE 0\n END\n ) AS CombinedShutouts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.season.value}\n GROUP BY PlayerName, Season\n HAVING SUM(\n CASE\n WHEN COALESCE(Pitcher_Shutout, 0) >= 1 OR COALESCE(Pitcher_CombinedShutout, 0) >= 1 THEN 1\n ELSE 0\n END\n ) > 0\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY CombinedShutouts DESC) AS Rank,\n PlayerName,\n Season,\n CombinedShutouts\n FROM Base\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName, Season\n) AS top_pitching_season_combined_shutout_full\n) AS player_records","inputQueryString":"-- Builds individual Clemson pitching season record tables.\n-- Split page-local SQL for pages/individual-records/pitching/index.md.\n-- Filter this query in the page with RecordKey to retrieve each record table.\n\nSELECT *, '/player-profiles/' || PlayerName AS link\nFROM (\nSELECT 'top_pitching_season_ip_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n Season,\n SUM(\n CAST(FLOOR(COALESCE(Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(Pitcher_InningsPitched, 0) - FLOOR(COALESCE(Pitcher_InningsPitched, 0))) * 10) AS INTEGER)\n ) AS TotalOuts,\n\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.season.value}\n GROUP BY PlayerName, Season\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY TotalOuts DESC) AS Rank,\n PlayerName,\n Season,\n FLOOR(TotalOuts / 3.0) + (MOD(TotalOuts, 3) / 10.0) AS InningsPitched,\n TotalOuts\n FROM Base\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName, Season\n) AS top_pitching_season_ip_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_season_gs_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n Season,\n SUM(CASE WHEN COALESCE(Pitcher_GameStarted, 0) = 1 THEN 1 ELSE 0 END) AS GamesStarted,\n\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.season.value}\n GROUP BY PlayerName, Season\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY GamesStarted DESC) AS Rank,\n PlayerName,\n Season,\n GamesStarted\n FROM Base\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName, Season\n) AS top_pitching_season_gs_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_season_victories_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n Season,\n SUM(CASE\n WHEN NULLIF(TRIM(CAST(Pitcher_Win AS VARCHAR)), '') IS NOT NULL THEN 1\n ELSE 0\n END) AS Victories\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.season.value}\n GROUP BY PlayerName, Season\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY Victories DESC) AS Rank,\n PlayerName,\n Season,\n Victories\n FROM Base\n WHERE Victories > 0\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName, Season\n) AS top_pitching_season_victories_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_season_so_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n Season,\n SUM(COALESCE(Pitcher_StrikeOuts, 0)) AS Strikeouts,\n\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.season.value}\n GROUP BY PlayerName, Season\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY Strikeouts DESC) AS Rank,\n PlayerName,\n Season,\n Strikeouts\n FROM Base\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName, Season\n) AS top_pitching_season_so_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_season_p_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n Season,\n SUM(COALESCE(Pitcher_Pitches, 0)) AS Pitches,\n\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.season.value}\n GROUP BY PlayerName, Season\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY Pitches DESC) AS Rank,\n PlayerName,\n Season,\n Pitches\n FROM Base\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName, Season\n) AS top_pitching_season_p_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_season_s_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n Season,\n SUM(COALESCE(Pitcher_Strikes, 0)) AS Strikes\n\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.season.value}\n GROUP BY PlayerName, Season\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY Strikes DESC) AS Rank,\n PlayerName,\n Season,\n Strikes\n FROM Base\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName, Season\n) AS top_pitching_season_s_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_season_app_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n Season,\n SUM(CASE WHEN COALESCE(Pitcher_Appearances, 0) >= 1 THEN 1 ELSE 0 END) AS Appearances\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.season.value}\n GROUP BY PlayerName, Season\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY Appearances DESC) AS Rank,\n PlayerName,\n Season,\n Appearances\n FROM Base\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName, Season\n) AS top_pitching_season_app_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_season_era_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n Season,\n SUM(COALESCE(Pitcher_EarnedRuns, 0)) AS EarnedRuns,\n SUM(\n CAST(FLOOR(COALESCE(Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(Pitcher_InningsPitched, 0) - FLOOR(COALESCE(Pitcher_InningsPitched, 0))) * 10) AS INTEGER)\n ) AS TotalOuts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.season.value}\n GROUP BY PlayerName, Season\n HAVING FLOOR(TotalOuts / 3.0) + (MOD(TotalOuts, 3) / 10.0) > 30\n ),\n WithEra AS (\n SELECT\n PlayerName,\n Season,\n EarnedRuns,\n FLOOR(TotalOuts / 3.0) + (MOD(TotalOuts, 3) / 10.0) AS InningsPitched,\n CAST(EarnedRuns * 7.0 / NULLIF(TotalOuts / 3.0, 0) AS DECIMAL(10,2)) AS ERA\n FROM Base\n WHERE TotalOuts > 0\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY ERA ASC NULLS LAST) AS Rank,\n PlayerName,\n Season,\n EarnedRuns,\n InningsPitched,\n ERA\n FROM WithEra\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName, Season\n) AS top_pitching_season_era_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_season_opp_ba_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n Season,\n SUM(COALESCE(Pitcher_Hits, 0)) AS HitsAllowed,\n SUM(COALESCE(Pitcher_AtBats, 0)) AS AtBatsAgainst,\n SUM(\n CAST(FLOOR(COALESCE(Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(Pitcher_InningsPitched, 0) - FLOOR(COALESCE(Pitcher_InningsPitched, 0))) * 10) AS INTEGER)\n ) AS TotalOuts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.season.value}\n GROUP BY PlayerName, Season\n HAVING FLOOR(TotalOuts / 3.0) + (MOD(TotalOuts, 3) / 10.0) > 30\n ),\n WithOppBA AS (\n SELECT\n PlayerName,\n Season,\n HitsAllowed,\n AtBatsAgainst,\n FLOOR(TotalOuts / 3.0) + (MOD(TotalOuts, 3) / 10.0) AS InningsPitched,\n ROUND(HitsAllowed * 1.0 / NULLIF(AtBatsAgainst, 0), 3) AS OppBA\n FROM Base\n WHERE AtBatsAgainst > 0\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY OppBA ASC NULLS LAST) AS Rank,\n PlayerName,\n Season,\n OppBA,\n HitsAllowed,\n AtBatsAgainst,\n InningsPitched\n FROM WithOppBA\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName, Season\n) AS top_pitching_season_opp_ba_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_season_cg_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n Season,\n SUM(COALESCE(Pitcher_CompleteGames, 0)) AS CompleteGames\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.season.value}\n GROUP BY PlayerName, Season\n HAVING SUM(COALESCE(Pitcher_CompleteGames, 0)) > 0\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY CompleteGames DESC) AS Rank,\n PlayerName,\n Season,\n CompleteGames\n FROM Base\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName, Season\n) AS top_pitching_season_cg_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_season_save_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n Season,\n SUM(CASE WHEN COALESCE(Pitcher_Save, 0) >= 1 THEN 1 ELSE 0 END) AS Saves\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.season.value}\n GROUP BY PlayerName, Season\n HAVING SUM(CASE WHEN COALESCE(Pitcher_Save, 0) >= 1 THEN 1 ELSE 0 END) > 0\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY Saves DESC) AS Rank,\n PlayerName,\n Season,\n Saves\n FROM Base\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName, Season\n) AS top_pitching_season_save_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_season_shutout_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n Season,\n SUM(COALESCE(Pitcher_Shutout, 0)) AS SoloShutouts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.season.value}\n GROUP BY PlayerName, Season\n HAVING SUM(COALESCE(Pitcher_Shutout, 0)) > 0\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY SoloShutouts DESC) AS Rank,\n PlayerName,\n Season,\n SoloShutouts\n FROM Base\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName, Season\n) AS top_pitching_season_shutout_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_season_combined_shutout_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n Season,\n SUM(\n CASE\n WHEN COALESCE(Pitcher_Shutout, 0) >= 1 OR COALESCE(Pitcher_CombinedShutout, 0) >= 1 THEN 1\n ELSE 0\n END\n ) AS CombinedShutouts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.season.value}\n GROUP BY PlayerName, Season\n HAVING SUM(\n CASE\n WHEN COALESCE(Pitcher_Shutout, 0) >= 1 OR COALESCE(Pitcher_CombinedShutout, 0) >= 1 THEN 1\n ELSE 0\n END\n ) > 0\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY CombinedShutouts DESC) AS Rank,\n PlayerName,\n Season,\n CombinedShutouts\n FROM Base\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName, Season\n) AS top_pitching_season_combined_shutout_full\n) AS player_records","compiled":false,"inline":false},{"id":"individual_pitching_career_records","compiledQueryString":"-- Builds individual Clemson pitching career record tables.\n-- Split page-local SQL for pages/individual-records/pitching/index.md.\n-- Filter this query in the page with RecordKey to retrieve each record table.\n\nSELECT *, '/player-profiles/' || PlayerName AS link\nFROM (\nSELECT 'top_pitching_career_gs_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n SUM(CASE WHEN COALESCE(Pitcher_GameStarted, 0) = 1 THEN 1 ELSE 0 END) AS GamesStarted,\n\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.career.value}\n GROUP BY PlayerName\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY GamesStarted DESC) AS Rank,\n PlayerName,\n GamesStarted\n FROM Base\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName\n) AS top_pitching_career_gs_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_career_victories_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n SUM(CASE\n WHEN NULLIF(TRIM(CAST(Pitcher_Win AS VARCHAR)), '') IS NOT NULL THEN 1\n ELSE 0\n END) AS Victories\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.career.value}\n GROUP BY PlayerName\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY Victories DESC) AS Rank,\n PlayerName,\n Victories\n FROM Base\n WHERE Victories > 0\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName\n) AS top_pitching_career_victories_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_career_so_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n SUM(COALESCE(Pitcher_StrikeOuts, 0)) AS Strikeouts,\n\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.career.value}\n GROUP BY PlayerName\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY Strikeouts DESC) AS Rank,\n PlayerName,\n Strikeouts\n FROM Base\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName\n) AS top_pitching_career_so_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_career_p_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n SUM(COALESCE(Pitcher_Pitches, 0)) AS Pitches,\n\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.career.value}\n GROUP BY PlayerName\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY Pitches DESC) AS Rank,\n PlayerName,\n Pitches\n FROM Base\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName\n) AS top_pitching_career_p_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_career_s_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n SUM(COALESCE(Pitcher_Strikes, 0)) AS Strikes\n\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.career.value}\n GROUP BY PlayerName\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY Strikes DESC) AS Rank,\n PlayerName,\n Strikes\n FROM Base\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName\n) AS top_pitching_career_s_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_career_app_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n SUM(CASE WHEN COALESCE(Pitcher_Appearances, 0) >= 1 THEN 1 ELSE 0 END) AS Appearances\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.career.value}\n GROUP BY PlayerName\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY Appearances DESC) AS Rank,\n PlayerName,\n Appearances\n FROM Base\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName\n) AS top_pitching_career_app_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_career_era_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n SUM(COALESCE(Pitcher_EarnedRuns, 0)) AS EarnedRuns,\n SUM(\n CAST(FLOOR(COALESCE(Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(Pitcher_InningsPitched, 0) - FLOOR(COALESCE(Pitcher_InningsPitched, 0))) * 10) AS INTEGER)\n ) AS TotalOuts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.career.value}\n GROUP BY PlayerName\n HAVING FLOOR(TotalOuts / 3.0) + (MOD(TotalOuts, 3) / 10.0) > 50\n ),\n WithEra AS (\n SELECT\n PlayerName,\n EarnedRuns,\n FLOOR(TotalOuts / 3.0) + (MOD(TotalOuts, 3) / 10.0) AS InningsPitched,\n CAST(EarnedRuns * 7.0 / NULLIF(TotalOuts / 3.0, 0) AS DECIMAL(10,2)) AS ERA\n FROM Base\n WHERE TotalOuts > 0\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY ERA ASC NULLS LAST) AS Rank,\n PlayerName,\n EarnedRuns,\n InningsPitched,\n ERA\n FROM WithEra\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName\n) AS top_pitching_career_era_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_career_opp_ba_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n SUM(COALESCE(Pitcher_Hits, 0)) AS HitsAllowed,\n SUM(COALESCE(Pitcher_AtBats, 0)) AS AtBatsAgainst,\n SUM(\n CAST(FLOOR(COALESCE(Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(Pitcher_InningsPitched, 0) - FLOOR(COALESCE(Pitcher_InningsPitched, 0))) * 10) AS INTEGER)\n ) AS TotalOuts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.career.value}\n GROUP BY PlayerName\n HAVING FLOOR(TotalOuts / 3.0) + (MOD(TotalOuts, 3) / 10.0) > 50\n ),\n WithOppBA AS (\n SELECT\n PlayerName,\n HitsAllowed,\n AtBatsAgainst,\n FLOOR(TotalOuts / 3.0) + (MOD(TotalOuts, 3) / 10.0) AS InningsPitched,\n ROUND(HitsAllowed * 1.0 / NULLIF(AtBatsAgainst, 0), 3) AS OppBA\n FROM Base\n WHERE AtBatsAgainst > 0\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY OppBA ASC NULLS LAST) AS Rank,\n PlayerName,\n OppBA,\n HitsAllowed,\n AtBatsAgainst,\n InningsPitched\n FROM WithOppBA\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName\n) AS top_pitching_career_opp_ba_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_career_cg_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n SUM(COALESCE(Pitcher_CompleteGames, 0)) AS CompleteGames\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.career.value}\n GROUP BY PlayerName\n HAVING SUM(COALESCE(Pitcher_CompleteGames, 0)) > 0\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY CompleteGames DESC) AS Rank,\n PlayerName,\n CompleteGames\n FROM Base\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName\n) AS top_pitching_career_cg_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_career_save_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n SUM(CASE WHEN COALESCE(Pitcher_Save, 0) >= 1 THEN 1 ELSE 0 END) AS Saves\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.career.value}\n GROUP BY PlayerName\n HAVING SUM(CASE WHEN COALESCE(Pitcher_Save, 0) >= 1 THEN 1 ELSE 0 END) > 0\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY Saves DESC) AS Rank,\n PlayerName,\n Saves\n FROM Base\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName\n) AS top_pitching_career_save_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_career_shutout_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n SUM(COALESCE(Pitcher_Shutout, 0)) AS SoloShutouts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.career.value}\n GROUP BY PlayerName\n HAVING SUM(COALESCE(Pitcher_Shutout, 0)) > 0\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY SoloShutouts DESC) AS Rank,\n PlayerName,\n SoloShutouts\n FROM Base\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName\n) AS top_pitching_career_shutout_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_career_combined_shutout_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n SUM(\n CASE\n WHEN COALESCE(Pitcher_Shutout, 0) >= 1 OR COALESCE(Pitcher_CombinedShutout, 0) >= 1 THEN 1\n ELSE 0\n END\n ) AS CombinedShutouts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.career.value}\n GROUP BY PlayerName\n HAVING SUM(\n CASE\n WHEN COALESCE(Pitcher_Shutout, 0) >= 1 OR COALESCE(Pitcher_CombinedShutout, 0) >= 1 THEN 1\n ELSE 0\n END\n ) > 0\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY CombinedShutouts DESC) AS Rank,\n PlayerName,\n CombinedShutouts\n FROM Base\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName\n) AS top_pitching_career_combined_shutout_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_career_ip_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n SUM(\n CAST(FLOOR(COALESCE(Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(Pitcher_InningsPitched, 0) - FLOOR(COALESCE(Pitcher_InningsPitched, 0))) * 10) AS INTEGER)\n ) AS TotalOuts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.career.value}\n GROUP BY PlayerName\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY TotalOuts DESC) AS Rank,\n PlayerName,\n FLOOR(TotalOuts / 3.0) + (MOD(TotalOuts, 3) / 10.0) AS InningsPitched,\n TotalOuts\n FROM Base\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName\n) AS top_pitching_career_ip_full\n) AS player_records","inputQueryString":"-- Builds individual Clemson pitching career record tables.\n-- Split page-local SQL for pages/individual-records/pitching/index.md.\n-- Filter this query in the page with RecordKey to retrieve each record table.\n\nSELECT *, '/player-profiles/' || PlayerName AS link\nFROM (\nSELECT 'top_pitching_career_gs_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n SUM(CASE WHEN COALESCE(Pitcher_GameStarted, 0) = 1 THEN 1 ELSE 0 END) AS GamesStarted,\n\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.career.value}\n GROUP BY PlayerName\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY GamesStarted DESC) AS Rank,\n PlayerName,\n GamesStarted\n FROM Base\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName\n) AS top_pitching_career_gs_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_career_victories_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n SUM(CASE\n WHEN NULLIF(TRIM(CAST(Pitcher_Win AS VARCHAR)), '') IS NOT NULL THEN 1\n ELSE 0\n END) AS Victories\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.career.value}\n GROUP BY PlayerName\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY Victories DESC) AS Rank,\n PlayerName,\n Victories\n FROM Base\n WHERE Victories > 0\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName\n) AS top_pitching_career_victories_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_career_so_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n SUM(COALESCE(Pitcher_StrikeOuts, 0)) AS Strikeouts,\n\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.career.value}\n GROUP BY PlayerName\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY Strikeouts DESC) AS Rank,\n PlayerName,\n Strikeouts\n FROM Base\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName\n) AS top_pitching_career_so_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_career_p_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n SUM(COALESCE(Pitcher_Pitches, 0)) AS Pitches,\n\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.career.value}\n GROUP BY PlayerName\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY Pitches DESC) AS Rank,\n PlayerName,\n Pitches\n FROM Base\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName\n) AS top_pitching_career_p_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_career_s_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n SUM(COALESCE(Pitcher_Strikes, 0)) AS Strikes\n\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.career.value}\n GROUP BY PlayerName\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY Strikes DESC) AS Rank,\n PlayerName,\n Strikes\n FROM Base\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName\n) AS top_pitching_career_s_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_career_app_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n SUM(CASE WHEN COALESCE(Pitcher_Appearances, 0) >= 1 THEN 1 ELSE 0 END) AS Appearances\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.career.value}\n GROUP BY PlayerName\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY Appearances DESC) AS Rank,\n PlayerName,\n Appearances\n FROM Base\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName\n) AS top_pitching_career_app_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_career_era_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n SUM(COALESCE(Pitcher_EarnedRuns, 0)) AS EarnedRuns,\n SUM(\n CAST(FLOOR(COALESCE(Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(Pitcher_InningsPitched, 0) - FLOOR(COALESCE(Pitcher_InningsPitched, 0))) * 10) AS INTEGER)\n ) AS TotalOuts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.career.value}\n GROUP BY PlayerName\n HAVING FLOOR(TotalOuts / 3.0) + (MOD(TotalOuts, 3) / 10.0) > 50\n ),\n WithEra AS (\n SELECT\n PlayerName,\n EarnedRuns,\n FLOOR(TotalOuts / 3.0) + (MOD(TotalOuts, 3) / 10.0) AS InningsPitched,\n CAST(EarnedRuns * 7.0 / NULLIF(TotalOuts / 3.0, 0) AS DECIMAL(10,2)) AS ERA\n FROM Base\n WHERE TotalOuts > 0\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY ERA ASC NULLS LAST) AS Rank,\n PlayerName,\n EarnedRuns,\n InningsPitched,\n ERA\n FROM WithEra\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName\n) AS top_pitching_career_era_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_career_opp_ba_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n SUM(COALESCE(Pitcher_Hits, 0)) AS HitsAllowed,\n SUM(COALESCE(Pitcher_AtBats, 0)) AS AtBatsAgainst,\n SUM(\n CAST(FLOOR(COALESCE(Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(Pitcher_InningsPitched, 0) - FLOOR(COALESCE(Pitcher_InningsPitched, 0))) * 10) AS INTEGER)\n ) AS TotalOuts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.career.value}\n GROUP BY PlayerName\n HAVING FLOOR(TotalOuts / 3.0) + (MOD(TotalOuts, 3) / 10.0) > 50\n ),\n WithOppBA AS (\n SELECT\n PlayerName,\n HitsAllowed,\n AtBatsAgainst,\n FLOOR(TotalOuts / 3.0) + (MOD(TotalOuts, 3) / 10.0) AS InningsPitched,\n ROUND(HitsAllowed * 1.0 / NULLIF(AtBatsAgainst, 0), 3) AS OppBA\n FROM Base\n WHERE AtBatsAgainst > 0\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY OppBA ASC NULLS LAST) AS Rank,\n PlayerName,\n OppBA,\n HitsAllowed,\n AtBatsAgainst,\n InningsPitched\n FROM WithOppBA\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName\n) AS top_pitching_career_opp_ba_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_career_cg_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n SUM(COALESCE(Pitcher_CompleteGames, 0)) AS CompleteGames\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.career.value}\n GROUP BY PlayerName\n HAVING SUM(COALESCE(Pitcher_CompleteGames, 0)) > 0\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY CompleteGames DESC) AS Rank,\n PlayerName,\n CompleteGames\n FROM Base\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName\n) AS top_pitching_career_cg_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_career_save_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n SUM(CASE WHEN COALESCE(Pitcher_Save, 0) >= 1 THEN 1 ELSE 0 END) AS Saves\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.career.value}\n GROUP BY PlayerName\n HAVING SUM(CASE WHEN COALESCE(Pitcher_Save, 0) >= 1 THEN 1 ELSE 0 END) > 0\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY Saves DESC) AS Rank,\n PlayerName,\n Saves\n FROM Base\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName\n) AS top_pitching_career_save_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_career_shutout_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n SUM(COALESCE(Pitcher_Shutout, 0)) AS SoloShutouts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.career.value}\n GROUP BY PlayerName\n HAVING SUM(COALESCE(Pitcher_Shutout, 0)) > 0\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY SoloShutouts DESC) AS Rank,\n PlayerName,\n SoloShutouts\n FROM Base\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName\n) AS top_pitching_career_shutout_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_career_combined_shutout_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n SUM(\n CASE\n WHEN COALESCE(Pitcher_Shutout, 0) >= 1 OR COALESCE(Pitcher_CombinedShutout, 0) >= 1 THEN 1\n ELSE 0\n END\n ) AS CombinedShutouts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.career.value}\n GROUP BY PlayerName\n HAVING SUM(\n CASE\n WHEN COALESCE(Pitcher_Shutout, 0) >= 1 OR COALESCE(Pitcher_CombinedShutout, 0) >= 1 THEN 1\n ELSE 0\n END\n ) > 0\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY CombinedShutouts DESC) AS Rank,\n PlayerName,\n CombinedShutouts\n FROM Base\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName\n) AS top_pitching_career_combined_shutout_full\n\nUNION ALL BY NAME\n\nSELECT 'top_pitching_career_ip_full' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n SUM(\n CAST(FLOOR(COALESCE(Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(Pitcher_InningsPitched, 0) - FLOOR(COALESCE(Pitcher_InningsPitched, 0))) * 10) AS INTEGER)\n ) AS TotalOuts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.career.value}\n GROUP BY PlayerName\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY TotalOuts DESC) AS Rank,\n PlayerName,\n FLOOR(TotalOuts / 3.0) + (MOD(TotalOuts, 3) / 10.0) AS InningsPitched,\n TotalOuts\n FROM Base\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName\n) AS top_pitching_career_ip_full\n) AS player_records","compiled":false,"inline":false},{"id":"individual_pitching_streak_records","compiledQueryString":"-- Builds individual Clemson pitching streak record tables.\n-- Split page-local SQL for pages/individual-records/pitching/index.md.\n-- Filter this query in the page with RecordKey to retrieve each record table.\n\nSELECT *, '/player-profiles/' || PlayerName AS link\nFROM (\nSELECT 'pitcher_consecutive_wins' AS RecordKey, *\nFROM (\n WITH FilteredGames AS (\n SELECT PlayerName, GameID, GameDate, Pitcher_Win\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.streak.value}\n ),\n PlayerWinLog AS (\n SELECT PlayerName, GameID, GameDate, CASE WHEN Pitcher_Win <> '' THEN 1 ELSE 0 END AS DidWin\n FROM FilteredGames\n ),\n StreakIdentifier AS (\n SELECT PlayerName, GameID, GameDate, DidWin,\n (ROW_NUMBER() OVER (PARTITION BY PlayerName ORDER BY GameDate, GameID)) -\n (ROW_NUMBER() OVER (PARTITION BY PlayerName, DidWin ORDER BY GameDate, GameID)) AS StreakID\n FROM PlayerWinLog\n ),\n StreakLengths AS (\n SELECT PlayerName, DidWin, COUNT(*) AS StreakLength,\n MIN(GameDate) AS StreakStart, MAX(GameDate) AS StreakEnd\n FROM StreakIdentifier GROUP BY PlayerName, DidWin, StreakID\n ),\n ranked AS (\n SELECT PlayerName, StreakLength, StreakStart, StreakEnd,\n RANK() OVER (ORDER BY StreakLength DESC) AS Rank\n FROM StreakLengths WHERE DidWin = 1\n )\n SELECT *,\n CASE WHEN Rank = LAG(Rank) OVER (ORDER BY Rank ASC, PlayerName, StreakStart DESC) THEN '-' ELSE CAST(Rank AS VARCHAR) END AS DisplayRank\n FROM ranked\n WHERE Rank <= 10\n ORDER BY Rank ASC, PlayerName, StreakStart DESC\n) AS pitcher_consecutive_wins\n\nUNION ALL BY NAME\n\nSELECT 'pitcher_consecutive_low_runs' AS RecordKey, *\nFROM (\n WITH FilteredGames AS (\n SELECT\n PlayerName,\n GameID,\n GameDate,\n Pitcher_Runs,\n CAST(FLOOR(COALESCE(Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(Pitcher_InningsPitched, 0) - FLOOR(COALESCE(Pitcher_InningsPitched, 0))) * 10) AS INTEGER) AS TotalOuts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.streak.value}\n ),\n PlayerLog AS (\n SELECT PlayerName, GameID, GameDate, TotalOuts, CASE WHEN Pitcher_Runs < 2 THEN 1 ELSE 0 END AS LowRuns\n FROM FilteredGames\n ),\n StreakIdentifier AS (\n SELECT PlayerName, GameID, GameDate, TotalOuts, LowRuns,\n (ROW_NUMBER() OVER (PARTITION BY PlayerName ORDER BY GameDate, GameID)) -\n (ROW_NUMBER() OVER (PARTITION BY PlayerName, LowRuns ORDER BY GameDate, GameID)) AS StreakID\n FROM PlayerLog\n ),\n StreakLengths AS (\n SELECT PlayerName, LowRuns, COUNT(*) AS StreakLength,\n MIN(GameDate) AS StreakStart, MAX(GameDate) AS StreakEnd,\n SUM(TotalOuts) AS TotalOuts\n FROM StreakIdentifier GROUP BY PlayerName, LowRuns, StreakID\n ),\n ranked AS (\n SELECT PlayerName, StreakLength, StreakStart, StreakEnd,\n FLOOR(TotalOuts / 3.0) + (MOD(TotalOuts, 3) / 10.0) AS InningsPitched,\n RANK() OVER (ORDER BY StreakLength DESC) AS Rank\n FROM StreakLengths WHERE LowRuns = 1\n )\n SELECT *,\n CASE WHEN Rank = LAG(Rank) OVER (ORDER BY Rank ASC, PlayerName, StreakStart DESC) THEN '-' ELSE CAST(Rank AS VARCHAR) END AS DisplayRank\n FROM ranked\n WHERE Rank <= 10\n ORDER BY Rank ASC, PlayerName, StreakStart DESC\n) AS pitcher_consecutive_low_runs\n\nUNION ALL BY NAME\n\nSELECT 'pitcher_consecutive_shutout_appearances' AS RecordKey, *\nFROM (\n WITH FilteredGames AS (\n SELECT\n PlayerName,\n GameID,\n GameDate,\n Pitcher_Runs,\n CAST(FLOOR(COALESCE(Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(Pitcher_InningsPitched, 0) - FLOOR(COALESCE(Pitcher_InningsPitched, 0))) * 10) AS INTEGER) AS TotalOuts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.streak.value}\n ),\n PlayerLog AS (\n SELECT PlayerName, GameID, GameDate, TotalOuts, CASE WHEN Pitcher_Runs = 0 THEN 1 ELSE 0 END AS NoRuns\n FROM FilteredGames\n ),\n StreakIdentifier AS (\n SELECT PlayerName, GameID, GameDate, TotalOuts, NoRuns,\n (ROW_NUMBER() OVER (PARTITION BY PlayerName ORDER BY GameDate, GameID)) -\n (ROW_NUMBER() OVER (PARTITION BY PlayerName, NoRuns ORDER BY GameDate, GameID)) AS StreakID\n FROM PlayerLog\n ),\n StreakLengths AS (\n SELECT PlayerName, NoRuns, COUNT(*) AS StreakLength,\n MIN(GameDate) AS StreakStart, MAX(GameDate) AS StreakEnd,\n SUM(TotalOuts) AS TotalOuts\n FROM StreakIdentifier GROUP BY PlayerName, NoRuns, StreakID\n ),\n ranked AS (\n SELECT PlayerName, StreakLength, StreakStart, StreakEnd,\n FLOOR(TotalOuts / 3.0) + (MOD(TotalOuts, 3) / 10.0) AS InningsPitched,\n RANK() OVER (ORDER BY StreakLength DESC) AS Rank\n FROM StreakLengths WHERE NoRuns = 1\n )\n SELECT *,\n CASE WHEN Rank = LAG(Rank) OVER (ORDER BY Rank ASC, PlayerName, StreakStart DESC) THEN '-' ELSE CAST(Rank AS VARCHAR) END AS DisplayRank\n FROM ranked\n WHERE Rank <= 10\n ORDER BY Rank ASC, PlayerName, StreakStart DESC\n) AS pitcher_consecutive_shutout_appearances\n\nUNION ALL BY NAME\n\nSELECT 'pitcher_consecutive_strikeout_games' AS RecordKey, *\nFROM (\n WITH FilteredGames AS (\n SELECT PlayerName, GameID, GameDate, Pitcher_StrikeOuts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.streak.value}\n ),\n PlayerLog AS (\n SELECT PlayerName, GameID, GameDate, CASE WHEN Pitcher_StrikeOuts >= 5 THEN 1 ELSE 0 END AS HighK\n FROM FilteredGames\n ),\n StreakIdentifier AS (\n SELECT PlayerName, GameID, GameDate, HighK,\n (ROW_NUMBER() OVER (PARTITION BY PlayerName ORDER BY GameDate, GameID)) -\n (ROW_NUMBER() OVER (PARTITION BY PlayerName, HighK ORDER BY GameDate, GameID)) AS StreakID\n FROM PlayerLog\n ),\n StreakLengths AS (\n SELECT PlayerName, HighK, COUNT(*) AS StreakLength,\n MIN(GameDate) AS StreakStart, MAX(GameDate) AS StreakEnd\n FROM StreakIdentifier GROUP BY PlayerName, HighK, StreakID\n ),\n ranked AS (\n SELECT PlayerName, StreakLength, StreakStart, StreakEnd,\n RANK() OVER (ORDER BY StreakLength DESC) AS Rank\n FROM StreakLengths WHERE HighK = 1\n )\n SELECT *,\n CASE WHEN Rank = LAG(Rank) OVER (ORDER BY Rank ASC, PlayerName, StreakStart DESC) THEN '-' ELSE CAST(Rank AS VARCHAR) END AS DisplayRank\n FROM ranked\n WHERE Rank <= 10\n ORDER BY Rank ASC, PlayerName, StreakStart DESC\n) AS pitcher_consecutive_strikeout_games\n) AS player_records","inputQueryString":"-- Builds individual Clemson pitching streak record tables.\n-- Split page-local SQL for pages/individual-records/pitching/index.md.\n-- Filter this query in the page with RecordKey to retrieve each record table.\n\nSELECT *, '/player-profiles/' || PlayerName AS link\nFROM (\nSELECT 'pitcher_consecutive_wins' AS RecordKey, *\nFROM (\n WITH FilteredGames AS (\n SELECT PlayerName, GameID, GameDate, Pitcher_Win\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.streak.value}\n ),\n PlayerWinLog AS (\n SELECT PlayerName, GameID, GameDate, CASE WHEN Pitcher_Win <> '' THEN 1 ELSE 0 END AS DidWin\n FROM FilteredGames\n ),\n StreakIdentifier AS (\n SELECT PlayerName, GameID, GameDate, DidWin,\n (ROW_NUMBER() OVER (PARTITION BY PlayerName ORDER BY GameDate, GameID)) -\n (ROW_NUMBER() OVER (PARTITION BY PlayerName, DidWin ORDER BY GameDate, GameID)) AS StreakID\n FROM PlayerWinLog\n ),\n StreakLengths AS (\n SELECT PlayerName, DidWin, COUNT(*) AS StreakLength,\n MIN(GameDate) AS StreakStart, MAX(GameDate) AS StreakEnd\n FROM StreakIdentifier GROUP BY PlayerName, DidWin, StreakID\n ),\n ranked AS (\n SELECT PlayerName, StreakLength, StreakStart, StreakEnd,\n RANK() OVER (ORDER BY StreakLength DESC) AS Rank\n FROM StreakLengths WHERE DidWin = 1\n )\n SELECT *,\n CASE WHEN Rank = LAG(Rank) OVER (ORDER BY Rank ASC, PlayerName, StreakStart DESC) THEN '-' ELSE CAST(Rank AS VARCHAR) END AS DisplayRank\n FROM ranked\n WHERE Rank <= 10\n ORDER BY Rank ASC, PlayerName, StreakStart DESC\n) AS pitcher_consecutive_wins\n\nUNION ALL BY NAME\n\nSELECT 'pitcher_consecutive_low_runs' AS RecordKey, *\nFROM (\n WITH FilteredGames AS (\n SELECT\n PlayerName,\n GameID,\n GameDate,\n Pitcher_Runs,\n CAST(FLOOR(COALESCE(Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(Pitcher_InningsPitched, 0) - FLOOR(COALESCE(Pitcher_InningsPitched, 0))) * 10) AS INTEGER) AS TotalOuts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.streak.value}\n ),\n PlayerLog AS (\n SELECT PlayerName, GameID, GameDate, TotalOuts, CASE WHEN Pitcher_Runs < 2 THEN 1 ELSE 0 END AS LowRuns\n FROM FilteredGames\n ),\n StreakIdentifier AS (\n SELECT PlayerName, GameID, GameDate, TotalOuts, LowRuns,\n (ROW_NUMBER() OVER (PARTITION BY PlayerName ORDER BY GameDate, GameID)) -\n (ROW_NUMBER() OVER (PARTITION BY PlayerName, LowRuns ORDER BY GameDate, GameID)) AS StreakID\n FROM PlayerLog\n ),\n StreakLengths AS (\n SELECT PlayerName, LowRuns, COUNT(*) AS StreakLength,\n MIN(GameDate) AS StreakStart, MAX(GameDate) AS StreakEnd,\n SUM(TotalOuts) AS TotalOuts\n FROM StreakIdentifier GROUP BY PlayerName, LowRuns, StreakID\n ),\n ranked AS (\n SELECT PlayerName, StreakLength, StreakStart, StreakEnd,\n FLOOR(TotalOuts / 3.0) + (MOD(TotalOuts, 3) / 10.0) AS InningsPitched,\n RANK() OVER (ORDER BY StreakLength DESC) AS Rank\n FROM StreakLengths WHERE LowRuns = 1\n )\n SELECT *,\n CASE WHEN Rank = LAG(Rank) OVER (ORDER BY Rank ASC, PlayerName, StreakStart DESC) THEN '-' ELSE CAST(Rank AS VARCHAR) END AS DisplayRank\n FROM ranked\n WHERE Rank <= 10\n ORDER BY Rank ASC, PlayerName, StreakStart DESC\n) AS pitcher_consecutive_low_runs\n\nUNION ALL BY NAME\n\nSELECT 'pitcher_consecutive_shutout_appearances' AS RecordKey, *\nFROM (\n WITH FilteredGames AS (\n SELECT\n PlayerName,\n GameID,\n GameDate,\n Pitcher_Runs,\n CAST(FLOOR(COALESCE(Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(Pitcher_InningsPitched, 0) - FLOOR(COALESCE(Pitcher_InningsPitched, 0))) * 10) AS INTEGER) AS TotalOuts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.streak.value}\n ),\n PlayerLog AS (\n SELECT PlayerName, GameID, GameDate, TotalOuts, CASE WHEN Pitcher_Runs = 0 THEN 1 ELSE 0 END AS NoRuns\n FROM FilteredGames\n ),\n StreakIdentifier AS (\n SELECT PlayerName, GameID, GameDate, TotalOuts, NoRuns,\n (ROW_NUMBER() OVER (PARTITION BY PlayerName ORDER BY GameDate, GameID)) -\n (ROW_NUMBER() OVER (PARTITION BY PlayerName, NoRuns ORDER BY GameDate, GameID)) AS StreakID\n FROM PlayerLog\n ),\n StreakLengths AS (\n SELECT PlayerName, NoRuns, COUNT(*) AS StreakLength,\n MIN(GameDate) AS StreakStart, MAX(GameDate) AS StreakEnd,\n SUM(TotalOuts) AS TotalOuts\n FROM StreakIdentifier GROUP BY PlayerName, NoRuns, StreakID\n ),\n ranked AS (\n SELECT PlayerName, StreakLength, StreakStart, StreakEnd,\n FLOOR(TotalOuts / 3.0) + (MOD(TotalOuts, 3) / 10.0) AS InningsPitched,\n RANK() OVER (ORDER BY StreakLength DESC) AS Rank\n FROM StreakLengths WHERE NoRuns = 1\n )\n SELECT *,\n CASE WHEN Rank = LAG(Rank) OVER (ORDER BY Rank ASC, PlayerName, StreakStart DESC) THEN '-' ELSE CAST(Rank AS VARCHAR) END AS DisplayRank\n FROM ranked\n WHERE Rank <= 10\n ORDER BY Rank ASC, PlayerName, StreakStart DESC\n) AS pitcher_consecutive_shutout_appearances\n\nUNION ALL BY NAME\n\nSELECT 'pitcher_consecutive_strikeout_games' AS RecordKey, *\nFROM (\n WITH FilteredGames AS (\n SELECT PlayerName, GameID, GameDate, Pitcher_StrikeOuts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1 AND Pitcher_Appearances > 0 AND SeasonType IN ${inputs.streak.value}\n ),\n PlayerLog AS (\n SELECT PlayerName, GameID, GameDate, CASE WHEN Pitcher_StrikeOuts >= 5 THEN 1 ELSE 0 END AS HighK\n FROM FilteredGames\n ),\n StreakIdentifier AS (\n SELECT PlayerName, GameID, GameDate, HighK,\n (ROW_NUMBER() OVER (PARTITION BY PlayerName ORDER BY GameDate, GameID)) -\n (ROW_NUMBER() OVER (PARTITION BY PlayerName, HighK ORDER BY GameDate, GameID)) AS StreakID\n FROM PlayerLog\n ),\n StreakLengths AS (\n SELECT PlayerName, HighK, COUNT(*) AS StreakLength,\n MIN(GameDate) AS StreakStart, MAX(GameDate) AS StreakEnd\n FROM StreakIdentifier GROUP BY PlayerName, HighK, StreakID\n ),\n ranked AS (\n SELECT PlayerName, StreakLength, StreakStart, StreakEnd,\n RANK() OVER (ORDER BY StreakLength DESC) AS Rank\n FROM StreakLengths WHERE HighK = 1\n )\n SELECT *,\n CASE WHEN Rank = LAG(Rank) OVER (ORDER BY Rank ASC, PlayerName, StreakStart DESC) THEN '-' ELSE CAST(Rank AS VARCHAR) END AS DisplayRank\n FROM ranked\n WHERE Rank <= 10\n ORDER BY Rank ASC, PlayerName, StreakStart DESC\n) AS pitcher_consecutive_strikeout_games\n) AS player_records","compiled":false,"inline":false}]}

Pitching Records

Pitching Achievements

Single Game Records

Season Records

Career Records

Streaks