{"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_fielding_records","compiledQueryString":"-- Builds Clemson team fielding records, single-game marks, season totals, and streak tables.\n-- Combined page-local SQL for pages/team-records/fielding/index.md.\n-- Filter this query in the page with RecordKey to retrieve each record table.\n\nSELECT 'team_fielding_single_game_putouts' AS RecordKey, *\nFROM (\n WITH Ranked AS (\n SELECT RANK() OVER (ORDER BY Putouts 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 COALESCE(Fielding_PutOuts, 0) AS Putouts,\n COALESCE(Fielding_Assists, 0) AS Assists,\n COALESCE(Fielding_DoublePlays, 0) AS DoublePlays,\n COALESCE(Fielding_Errors, 0) AS Errors\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 Putouts > 0\n )\n SELECT Rank, Season, GameDate, Opponent, Score, Putouts, GameID, link\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, GameDate DESC, GameID DESC\n) AS team_fielding_single_game_putouts\n\nUNION ALL BY NAME\n\nSELECT 'team_fielding_single_game_assists' AS RecordKey, *\nFROM (\n WITH Ranked AS (\n SELECT RANK() OVER (ORDER BY Assists 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 COALESCE(Fielding_PutOuts, 0) AS Putouts,\n COALESCE(Fielding_Assists, 0) AS Assists,\n COALESCE(Fielding_DoublePlays, 0) AS DoublePlays,\n COALESCE(Fielding_Errors, 0) AS Errors\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 Assists > 0\n )\n SELECT Rank, Season, GameDate, Opponent, Score, Assists, GameID, link\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, GameDate DESC, GameID DESC\n) AS team_fielding_single_game_assists\n\nUNION ALL BY NAME\n\nSELECT 'team_fielding_single_game_double_plays' AS RecordKey, *\nFROM (\n WITH Ranked AS (\n SELECT RANK() OVER (ORDER BY DoublePlays 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 COALESCE(Fielding_PutOuts, 0) AS Putouts,\n COALESCE(Fielding_Assists, 0) AS Assists,\n COALESCE(Fielding_DoublePlays, 0) AS DoublePlays,\n COALESCE(Fielding_Errors, 0) AS Errors\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 DoublePlays > 0\n )\n SELECT Rank, Season, GameDate, Opponent, Score, DoublePlays, GameID, link\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, GameDate DESC, GameID DESC\n) AS team_fielding_single_game_double_plays\n\nUNION ALL BY NAME\n\nSELECT 'team_fielding_single_game_errors' AS RecordKey, *\nFROM (\n WITH Ranked AS (\n SELECT RANK() OVER (ORDER BY Errors 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 COALESCE(Fielding_PutOuts, 0) AS Putouts,\n COALESCE(Fielding_Assists, 0) AS Assists,\n COALESCE(Fielding_DoublePlays, 0) AS DoublePlays,\n COALESCE(Fielding_Errors, 0) AS Errors\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 Errors > 0\n )\n SELECT Rank, Season, GameDate, Opponent, Score, Errors, GameID, link\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, GameDate DESC, GameID DESC\n) AS team_fielding_single_game_errors\n\nUNION ALL BY NAME\n\nSELECT 'team_fielding_percentage' 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(Fielding_PutOuts, 0)) AS Putouts,\n SUM(COALESCE(Fielding_Assists, 0)) AS Assists,\n SUM(COALESCE(Fielding_Errors, 0)) AS Errors\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 ROUND((Putouts + Assists) * 1.0 / NULLIF(Putouts + Assists + Errors, 0), 3) AS FPCT,\n Putouts,\n Assists,\n Errors\n FROM Base\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY FPCT DESC NULLS LAST) AS Rank,\n Season,\n GameID,\n link,\n GamesPlayed,\n Wins,\n Losses,\n FPCT,\n Putouts,\n Assists,\n Errors\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_fielding_percentage\n\nUNION ALL BY NAME\n\nSELECT 'team_fielding_putouts' 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(Fielding_PutOuts, 0)) AS Putouts\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 Putouts DESC) AS Rank,\n Season,\n GameID,\n link,\n GamesPlayed,\n Wins,\n Losses,\n Putouts\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_fielding_putouts\n\nUNION ALL BY NAME\n\nSELECT 'team_fielding_assists' 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(Fielding_Assists, 0)) AS Assists\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 Assists DESC) AS Rank,\n Season,\n GameID,\n link,\n GamesPlayed,\n Wins,\n Losses,\n Assists\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_fielding_assists\n\nUNION ALL BY NAME\n\nSELECT 'team_fielding_double_plays' 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(Fielding_DoublePlays, 0)) AS DoublePlaysTurned\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 DoublePlaysTurned DESC) AS Rank,\n Season,\n GameID,\n link,\n GamesPlayed,\n Wins,\n Losses,\n DoublePlaysTurned\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_fielding_double_plays\n\nUNION ALL BY NAME\n\nSELECT 'team_fielding_errors' 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(Fielding_Errors, 0)) AS Errors\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 Errors ASC) AS Rank,\n Season,\n GameID,\n link,\n GamesPlayed,\n Wins,\n Losses,\n Errors\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_fielding_errors\n\nUNION ALL BY NAME\n\nSELECT 'win_streak' AS RecordKey, *\nFROM (\n WITH GameResults AS (\n SELECT\n GameID,\n GameDate,\n Season,\n Opponent,\n WinLoss,\n CASE WHEN WinLoss = 'W' THEN 1 ELSE 0 END AS IsWin\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 IsWin,\n (ROW_NUMBER() OVER (ORDER BY GameDate, GameID)) -\n (ROW_NUMBER() OVER (PARTITION BY IsWin ORDER BY GameDate, GameID)) AS StreakID\n FROM GameResults\n ),\n SL AS (\n SELECT\n IsWin,\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 IsWin, 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 IsWin = 1\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, StreakStart DESC\n) AS win_streak\n\nUNION ALL BY NAME\n\nSELECT 'errorless_streak' AS RecordKey, *\nFROM (\n WITH GameErrors AS (\n SELECT\n GameID,\n GameDate,\n Season,\n Opponent,\n Fielding_Errors,\n CASE WHEN Fielding_Errors = 0 THEN 1 ELSE 0 END AS NoErrors\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 NoErrors,\n (ROW_NUMBER() OVER (ORDER BY GameDate, GameID)) -\n (ROW_NUMBER() OVER (PARTITION BY NoErrors ORDER BY GameDate, GameID)) AS StreakID\n FROM GameErrors\n ),\n SL AS (\n SELECT\n NoErrors,\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 NoErrors, 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 NoErrors = 1\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, StreakStart DESC\n) AS errorless_streak\n\nUNION ALL BY NAME\n\nSELECT 'double_play_streak' AS RecordKey, *\nFROM (\n WITH GameDP AS (\n SELECT\n GameID,\n GameDate,\n Season,\n Opponent,\n Fielding_DoublePlays,\n CASE WHEN Fielding_DoublePlays > 0 THEN 1 ELSE 0 END AS HadDoublePlay\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 HadDoublePlay,\n (ROW_NUMBER() OVER (ORDER BY GameDate, GameID)) -\n (ROW_NUMBER() OVER (PARTITION BY HadDoublePlay ORDER BY GameDate, GameID)) AS StreakID\n FROM GameDP\n ),\n SL AS (\n SELECT\n HadDoublePlay,\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 HadDoublePlay, 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 HadDoublePlay = 1\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, StreakStart DESC\n) AS double_play_streak","inputQueryString":"-- Builds Clemson team fielding records, single-game marks, season totals, and streak tables.\n-- Combined page-local SQL for pages/team-records/fielding/index.md.\n-- Filter this query in the page with RecordKey to retrieve each record table.\n\nSELECT 'team_fielding_single_game_putouts' AS RecordKey, *\nFROM (\n WITH Ranked AS (\n SELECT RANK() OVER (ORDER BY Putouts 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 COALESCE(Fielding_PutOuts, 0) AS Putouts,\n COALESCE(Fielding_Assists, 0) AS Assists,\n COALESCE(Fielding_DoublePlays, 0) AS DoublePlays,\n COALESCE(Fielding_Errors, 0) AS Errors\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 Putouts > 0\n )\n SELECT Rank, Season, GameDate, Opponent, Score, Putouts, GameID, link\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, GameDate DESC, GameID DESC\n) AS team_fielding_single_game_putouts\n\nUNION ALL BY NAME\n\nSELECT 'team_fielding_single_game_assists' AS RecordKey, *\nFROM (\n WITH Ranked AS (\n SELECT RANK() OVER (ORDER BY Assists 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 COALESCE(Fielding_PutOuts, 0) AS Putouts,\n COALESCE(Fielding_Assists, 0) AS Assists,\n COALESCE(Fielding_DoublePlays, 0) AS DoublePlays,\n COALESCE(Fielding_Errors, 0) AS Errors\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 Assists > 0\n )\n SELECT Rank, Season, GameDate, Opponent, Score, Assists, GameID, link\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, GameDate DESC, GameID DESC\n) AS team_fielding_single_game_assists\n\nUNION ALL BY NAME\n\nSELECT 'team_fielding_single_game_double_plays' AS RecordKey, *\nFROM (\n WITH Ranked AS (\n SELECT RANK() OVER (ORDER BY DoublePlays 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 COALESCE(Fielding_PutOuts, 0) AS Putouts,\n COALESCE(Fielding_Assists, 0) AS Assists,\n COALESCE(Fielding_DoublePlays, 0) AS DoublePlays,\n COALESCE(Fielding_Errors, 0) AS Errors\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 DoublePlays > 0\n )\n SELECT Rank, Season, GameDate, Opponent, Score, DoublePlays, GameID, link\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, GameDate DESC, GameID DESC\n) AS team_fielding_single_game_double_plays\n\nUNION ALL BY NAME\n\nSELECT 'team_fielding_single_game_errors' AS RecordKey, *\nFROM (\n WITH Ranked AS (\n SELECT RANK() OVER (ORDER BY Errors 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 COALESCE(Fielding_PutOuts, 0) AS Putouts,\n COALESCE(Fielding_Assists, 0) AS Assists,\n COALESCE(Fielding_DoublePlays, 0) AS DoublePlays,\n COALESCE(Fielding_Errors, 0) AS Errors\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 Errors > 0\n )\n SELECT Rank, Season, GameDate, Opponent, Score, Errors, GameID, link\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, GameDate DESC, GameID DESC\n) AS team_fielding_single_game_errors\n\nUNION ALL BY NAME\n\nSELECT 'team_fielding_percentage' 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(Fielding_PutOuts, 0)) AS Putouts,\n SUM(COALESCE(Fielding_Assists, 0)) AS Assists,\n SUM(COALESCE(Fielding_Errors, 0)) AS Errors\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 ROUND((Putouts + Assists) * 1.0 / NULLIF(Putouts + Assists + Errors, 0), 3) AS FPCT,\n Putouts,\n Assists,\n Errors\n FROM Base\n ),\n Ranked AS (\n SELECT\n RANK() OVER (ORDER BY FPCT DESC NULLS LAST) AS Rank,\n Season,\n GameID,\n link,\n GamesPlayed,\n Wins,\n Losses,\n FPCT,\n Putouts,\n Assists,\n Errors\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_fielding_percentage\n\nUNION ALL BY NAME\n\nSELECT 'team_fielding_putouts' 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(Fielding_PutOuts, 0)) AS Putouts\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 Putouts DESC) AS Rank,\n Season,\n GameID,\n link,\n GamesPlayed,\n Wins,\n Losses,\n Putouts\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_fielding_putouts\n\nUNION ALL BY NAME\n\nSELECT 'team_fielding_assists' 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(Fielding_Assists, 0)) AS Assists\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 Assists DESC) AS Rank,\n Season,\n GameID,\n link,\n GamesPlayed,\n Wins,\n Losses,\n Assists\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_fielding_assists\n\nUNION ALL BY NAME\n\nSELECT 'team_fielding_double_plays' 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(Fielding_DoublePlays, 0)) AS DoublePlaysTurned\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 DoublePlaysTurned DESC) AS Rank,\n Season,\n GameID,\n link,\n GamesPlayed,\n Wins,\n Losses,\n DoublePlaysTurned\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_fielding_double_plays\n\nUNION ALL BY NAME\n\nSELECT 'team_fielding_errors' 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(Fielding_Errors, 0)) AS Errors\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 Errors ASC) AS Rank,\n Season,\n GameID,\n link,\n GamesPlayed,\n Wins,\n Losses,\n Errors\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_fielding_errors\n\nUNION ALL BY NAME\n\nSELECT 'win_streak' AS RecordKey, *\nFROM (\n WITH GameResults AS (\n SELECT\n GameID,\n GameDate,\n Season,\n Opponent,\n WinLoss,\n CASE WHEN WinLoss = 'W' THEN 1 ELSE 0 END AS IsWin\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 IsWin,\n (ROW_NUMBER() OVER (ORDER BY GameDate, GameID)) -\n (ROW_NUMBER() OVER (PARTITION BY IsWin ORDER BY GameDate, GameID)) AS StreakID\n FROM GameResults\n ),\n SL AS (\n SELECT\n IsWin,\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 IsWin, 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 IsWin = 1\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, StreakStart DESC\n) AS win_streak\n\nUNION ALL BY NAME\n\nSELECT 'errorless_streak' AS RecordKey, *\nFROM (\n WITH GameErrors AS (\n SELECT\n GameID,\n GameDate,\n Season,\n Opponent,\n Fielding_Errors,\n CASE WHEN Fielding_Errors = 0 THEN 1 ELSE 0 END AS NoErrors\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 NoErrors,\n (ROW_NUMBER() OVER (ORDER BY GameDate, GameID)) -\n (ROW_NUMBER() OVER (PARTITION BY NoErrors ORDER BY GameDate, GameID)) AS StreakID\n FROM GameErrors\n ),\n SL AS (\n SELECT\n NoErrors,\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 NoErrors, 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 NoErrors = 1\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, StreakStart DESC\n) AS errorless_streak\n\nUNION ALL BY NAME\n\nSELECT 'double_play_streak' AS RecordKey, *\nFROM (\n WITH GameDP AS (\n SELECT\n GameID,\n GameDate,\n Season,\n Opponent,\n Fielding_DoublePlays,\n CASE WHEN Fielding_DoublePlays > 0 THEN 1 ELSE 0 END AS HadDoublePlay\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 HadDoublePlay,\n (ROW_NUMBER() OVER (ORDER BY GameDate, GameID)) -\n (ROW_NUMBER() OVER (PARTITION BY HadDoublePlay ORDER BY GameDate, GameID)) AS StreakID\n FROM GameDP\n ),\n SL AS (\n SELECT\n HadDoublePlay,\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 HadDoublePlay, 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 HadDoublePlay = 1\n )\n SELECT *\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, StreakStart DESC\n) AS double_play_streak","compiled":false,"inline":false}]}

Team Fielding Records

Team Single Game Fielding Records

Team Fielding Records

Fielding Streaks