{"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_fielding_records","compiledQueryString":"-- Builds individual Clemson fielding record tables across single-game, season, and career categories.\n-- Combined page-local SQL for pages/individual-records/fielding/index.md.\n-- Filter this query in the page with RecordKey to retrieve each record table.\n\nSELECT 'top_fielding_putouts_single_game' AS RecordKey, *\nFROM (\n WITH Ranked AS (\n SELECT RANK() OVER (ORDER BY PutOuts 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(COALESCE(p.Field_PutOuts, 0)) AS PutOuts,\n SUM(COALESCE(p.Field_Assists, 0)) AS Assists\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.SeasonType IN ${inputs.single_game.value}\n GROUP BY p.PlayerName, p.GameID\n )\n SELECT *\n FROM stats\n )\n WHERE PutOuts > 0\n )\n SELECT Rank, PlayerName, Season, GameDate, Opponent, Score, PutOuts, GameID, link\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName, GameDate DESC, GameID DESC\n) AS top_fielding_putouts_single_game\n\nUNION ALL BY NAME\n\nSELECT 'top_fielding_assists_single_game' AS RecordKey, *\nFROM (\n WITH Ranked AS (\n SELECT RANK() OVER (ORDER BY Assists 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(COALESCE(p.Field_PutOuts, 0)) AS PutOuts,\n SUM(COALESCE(p.Field_Assists, 0)) AS Assists\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.SeasonType IN ${inputs.single_game.value}\n GROUP BY p.PlayerName, p.GameID\n )\n SELECT *\n FROM stats\n )\n WHERE Assists > 0\n )\n SELECT Rank, PlayerName, Season, GameDate, Opponent, Score, Assists, GameID, link\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName, GameDate DESC, GameID DESC\n) AS top_fielding_assists_single_game\n\nUNION ALL BY NAME\n\nSELECT 'top_fielding_fpct_season' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n Season,\n SUM(COALESCE(Field_PutOuts, 0)) AS PutOuts,\n SUM(COALESCE(Field_Assists, 0)) AS Assists,\n SUM(COALESCE(Field_Errors, 0)) AS Errors,\n ROUND(1.0 * (SUM(COALESCE(Field_PutOuts, 0)) + SUM(COALESCE(Field_Assists, 0)))\n / NULLIF(SUM(COALESCE(Field_PutOuts, 0)) + SUM(COALESCE(Field_Assists, 0)) + SUM(COALESCE(Field_Errors, 0)), 0), 3) AS FPCT\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1\n AND SeasonType IN ${inputs.season.value}\n GROUP BY PlayerName, Season\n HAVING SUM(COALESCE(Field_PutOuts, 0)) + SUM(COALESCE(Field_Assists, 0)) + SUM(COALESCE(Field_Errors, 0)) > 100\n ),\n Ranked AS (\n SELECT\n PlayerName,\n Season,\n PutOuts,\n Assists,\n Errors,\n FPCT,\n RANK() OVER (ORDER BY FPCT DESC) AS Rank\n FROM Base\n )\n SELECT\n Rank,\n PlayerName,\n '/player-profiles/' || PlayerName AS link,\n Season,\n FPCT,\n PutOuts,\n Assists,\n Errors\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName, Season\n) AS top_fielding_fpct_season\n\nUNION ALL BY NAME\n\nSELECT 'top_fielding_putouts_season' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n Season,\n SUM(COALESCE(Field_PutOuts, 0)) AS PutOuts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1\n AND SeasonType IN ${inputs.season.value}\n GROUP BY PlayerName, Season\n ),\n Ranked AS (\n SELECT\n PlayerName,\n Season,\n PutOuts,\n RANK() OVER (ORDER BY PutOuts DESC) AS Rank\n FROM Base\n )\n SELECT\n Rank,\n PlayerName,\n '/player-profiles/' || PlayerName AS link,\n Season,\n PutOuts\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName, Season\n) AS top_fielding_putouts_season\n\nUNION ALL BY NAME\n\nSELECT 'top_fielding_assists_season' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n Season,\n SUM(COALESCE(Field_Assists, 0)) AS Assists\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1\n AND SeasonType IN ${inputs.season.value}\n GROUP BY PlayerName, Season\n ),\n Ranked AS (\n SELECT\n PlayerName,\n Season,\n Assists,\n RANK() OVER (ORDER BY Assists DESC) AS Rank\n FROM Base\n )\n SELECT\n Rank,\n PlayerName,\n '/player-profiles/' || PlayerName AS link,\n Season,\n Assists\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName, Season\n) AS top_fielding_assists_season\n\nUNION ALL BY NAME\n\nSELECT 'top_fielding_doubleplays_season' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n Season,\n SUM(COALESCE(Field_DoublePlays, 0)) AS DoublePlays\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1\n AND SeasonType IN ${inputs.season.value}\n GROUP BY PlayerName, Season\n ),\n Ranked AS (\n SELECT\n PlayerName,\n Season,\n DoublePlays,\n RANK() OVER (ORDER BY DoublePlays DESC) AS Rank\n FROM Base\n )\n SELECT\n Rank,\n PlayerName,\n '/player-profiles/' || PlayerName AS link,\n Season,\n DoublePlays\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName, Season\n) AS top_fielding_doubleplays_season\n\nUNION ALL BY NAME\n\nSELECT 'top_fielding_fpct_career' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n SUM(COALESCE(Field_PutOuts, 0)) AS PutOuts,\n SUM(COALESCE(Field_Assists, 0)) AS Assists,\n SUM(COALESCE(Field_Errors, 0)) AS Errors,\n ROUND(1.0 * (SUM(COALESCE(Field_PutOuts, 0)) + SUM(COALESCE(Field_Assists, 0)))\n / NULLIF(SUM(COALESCE(Field_PutOuts, 0)) + SUM(COALESCE(Field_Assists, 0)) + SUM(COALESCE(Field_Errors, 0)), 0), 3) AS FPCT\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1\n AND SeasonType IN ${inputs.career.value}\n GROUP BY PlayerName\n HAVING SUM(COALESCE(Field_PutOuts, 0)) + SUM(COALESCE(Field_Assists, 0)) + SUM(COALESCE(Field_Errors, 0)) > 250\n ),\n Ranked AS (\n SELECT\n PlayerName,\n PutOuts,\n Assists,\n Errors,\n FPCT,\n RANK() OVER (ORDER BY FPCT DESC) AS Rank\n FROM Base\n )\n SELECT\n Rank,\n PlayerName,\n '/player-profiles/' || PlayerName AS link,\n FPCT,\n PutOuts,\n Assists,\n Errors\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName\n) AS top_fielding_fpct_career\n\nUNION ALL BY NAME\n\nSELECT 'top_fielding_putouts_career' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n SUM(COALESCE(Field_PutOuts, 0)) AS PutOuts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1\n AND SeasonType IN ${inputs.career.value}\n GROUP BY PlayerName\n HAVING SUM(COALESCE(Field_PutOuts, 0)) > 40\n ),\n Ranked AS (\n SELECT\n PlayerName,\n PutOuts,\n RANK() OVER (ORDER BY PutOuts DESC) AS Rank\n FROM Base\n )\n SELECT\n Rank,\n PlayerName,\n '/player-profiles/' || PlayerName AS link,\n PutOuts\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName\n) AS top_fielding_putouts_career\n\nUNION ALL BY NAME\n\nSELECT 'top_fielding_assists_career' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n SUM(COALESCE(Field_Assists, 0)) AS Assists\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1\n AND SeasonType IN ${inputs.career.value}\n GROUP BY PlayerName\n ),\n Ranked AS (\n SELECT\n PlayerName,\n Assists,\n RANK() OVER (ORDER BY Assists DESC) AS Rank\n FROM Base\n )\n SELECT\n Rank,\n PlayerName,\n '/player-profiles/' || PlayerName AS link,\n Assists\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName\n) AS top_fielding_assists_career\n\nUNION ALL BY NAME\n\nSELECT 'top_fielding_doubleplays_career' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n SUM(COALESCE(Field_DoublePlays, 0)) AS DoublePlays\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1\n AND SeasonType IN ${inputs.career.value}\n GROUP BY PlayerName\n ),\n Ranked AS (\n SELECT\n PlayerName,\n DoublePlays,\n RANK() OVER (ORDER BY DoublePlays DESC) AS Rank\n FROM Base\n )\n SELECT\n Rank,\n PlayerName,\n '/player-profiles/' || PlayerName AS link,\n DoublePlays\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName\n) AS top_fielding_doubleplays_career","inputQueryString":"-- Builds individual Clemson fielding record tables across single-game, season, and career categories.\n-- Combined page-local SQL for pages/individual-records/fielding/index.md.\n-- Filter this query in the page with RecordKey to retrieve each record table.\n\nSELECT 'top_fielding_putouts_single_game' AS RecordKey, *\nFROM (\n WITH Ranked AS (\n SELECT RANK() OVER (ORDER BY PutOuts 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(COALESCE(p.Field_PutOuts, 0)) AS PutOuts,\n SUM(COALESCE(p.Field_Assists, 0)) AS Assists\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.SeasonType IN ${inputs.single_game.value}\n GROUP BY p.PlayerName, p.GameID\n )\n SELECT *\n FROM stats\n )\n WHERE PutOuts > 0\n )\n SELECT Rank, PlayerName, Season, GameDate, Opponent, Score, PutOuts, GameID, link\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName, GameDate DESC, GameID DESC\n) AS top_fielding_putouts_single_game\n\nUNION ALL BY NAME\n\nSELECT 'top_fielding_assists_single_game' AS RecordKey, *\nFROM (\n WITH Ranked AS (\n SELECT RANK() OVER (ORDER BY Assists 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(COALESCE(p.Field_PutOuts, 0)) AS PutOuts,\n SUM(COALESCE(p.Field_Assists, 0)) AS Assists\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.SeasonType IN ${inputs.single_game.value}\n GROUP BY p.PlayerName, p.GameID\n )\n SELECT *\n FROM stats\n )\n WHERE Assists > 0\n )\n SELECT Rank, PlayerName, Season, GameDate, Opponent, Score, Assists, GameID, link\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName, GameDate DESC, GameID DESC\n) AS top_fielding_assists_single_game\n\nUNION ALL BY NAME\n\nSELECT 'top_fielding_fpct_season' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n Season,\n SUM(COALESCE(Field_PutOuts, 0)) AS PutOuts,\n SUM(COALESCE(Field_Assists, 0)) AS Assists,\n SUM(COALESCE(Field_Errors, 0)) AS Errors,\n ROUND(1.0 * (SUM(COALESCE(Field_PutOuts, 0)) + SUM(COALESCE(Field_Assists, 0)))\n / NULLIF(SUM(COALESCE(Field_PutOuts, 0)) + SUM(COALESCE(Field_Assists, 0)) + SUM(COALESCE(Field_Errors, 0)), 0), 3) AS FPCT\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1\n AND SeasonType IN ${inputs.season.value}\n GROUP BY PlayerName, Season\n HAVING SUM(COALESCE(Field_PutOuts, 0)) + SUM(COALESCE(Field_Assists, 0)) + SUM(COALESCE(Field_Errors, 0)) > 100\n ),\n Ranked AS (\n SELECT\n PlayerName,\n Season,\n PutOuts,\n Assists,\n Errors,\n FPCT,\n RANK() OVER (ORDER BY FPCT DESC) AS Rank\n FROM Base\n )\n SELECT\n Rank,\n PlayerName,\n '/player-profiles/' || PlayerName AS link,\n Season,\n FPCT,\n PutOuts,\n Assists,\n Errors\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName, Season\n) AS top_fielding_fpct_season\n\nUNION ALL BY NAME\n\nSELECT 'top_fielding_putouts_season' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n Season,\n SUM(COALESCE(Field_PutOuts, 0)) AS PutOuts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1\n AND SeasonType IN ${inputs.season.value}\n GROUP BY PlayerName, Season\n ),\n Ranked AS (\n SELECT\n PlayerName,\n Season,\n PutOuts,\n RANK() OVER (ORDER BY PutOuts DESC) AS Rank\n FROM Base\n )\n SELECT\n Rank,\n PlayerName,\n '/player-profiles/' || PlayerName AS link,\n Season,\n PutOuts\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName, Season\n) AS top_fielding_putouts_season\n\nUNION ALL BY NAME\n\nSELECT 'top_fielding_assists_season' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n Season,\n SUM(COALESCE(Field_Assists, 0)) AS Assists\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1\n AND SeasonType IN ${inputs.season.value}\n GROUP BY PlayerName, Season\n ),\n Ranked AS (\n SELECT\n PlayerName,\n Season,\n Assists,\n RANK() OVER (ORDER BY Assists DESC) AS Rank\n FROM Base\n )\n SELECT\n Rank,\n PlayerName,\n '/player-profiles/' || PlayerName AS link,\n Season,\n Assists\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName, Season\n) AS top_fielding_assists_season\n\nUNION ALL BY NAME\n\nSELECT 'top_fielding_doubleplays_season' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n Season,\n SUM(COALESCE(Field_DoublePlays, 0)) AS DoublePlays\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1\n AND SeasonType IN ${inputs.season.value}\n GROUP BY PlayerName, Season\n ),\n Ranked AS (\n SELECT\n PlayerName,\n Season,\n DoublePlays,\n RANK() OVER (ORDER BY DoublePlays DESC) AS Rank\n FROM Base\n )\n SELECT\n Rank,\n PlayerName,\n '/player-profiles/' || PlayerName AS link,\n Season,\n DoublePlays\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName, Season\n) AS top_fielding_doubleplays_season\n\nUNION ALL BY NAME\n\nSELECT 'top_fielding_fpct_career' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n SUM(COALESCE(Field_PutOuts, 0)) AS PutOuts,\n SUM(COALESCE(Field_Assists, 0)) AS Assists,\n SUM(COALESCE(Field_Errors, 0)) AS Errors,\n ROUND(1.0 * (SUM(COALESCE(Field_PutOuts, 0)) + SUM(COALESCE(Field_Assists, 0)))\n / NULLIF(SUM(COALESCE(Field_PutOuts, 0)) + SUM(COALESCE(Field_Assists, 0)) + SUM(COALESCE(Field_Errors, 0)), 0), 3) AS FPCT\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1\n AND SeasonType IN ${inputs.career.value}\n GROUP BY PlayerName\n HAVING SUM(COALESCE(Field_PutOuts, 0)) + SUM(COALESCE(Field_Assists, 0)) + SUM(COALESCE(Field_Errors, 0)) > 250\n ),\n Ranked AS (\n SELECT\n PlayerName,\n PutOuts,\n Assists,\n Errors,\n FPCT,\n RANK() OVER (ORDER BY FPCT DESC) AS Rank\n FROM Base\n )\n SELECT\n Rank,\n PlayerName,\n '/player-profiles/' || PlayerName AS link,\n FPCT,\n PutOuts,\n Assists,\n Errors\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName\n) AS top_fielding_fpct_career\n\nUNION ALL BY NAME\n\nSELECT 'top_fielding_putouts_career' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n SUM(COALESCE(Field_PutOuts, 0)) AS PutOuts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1\n AND SeasonType IN ${inputs.career.value}\n GROUP BY PlayerName\n HAVING SUM(COALESCE(Field_PutOuts, 0)) > 40\n ),\n Ranked AS (\n SELECT\n PlayerName,\n PutOuts,\n RANK() OVER (ORDER BY PutOuts DESC) AS Rank\n FROM Base\n )\n SELECT\n Rank,\n PlayerName,\n '/player-profiles/' || PlayerName AS link,\n PutOuts\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName\n) AS top_fielding_putouts_career\n\nUNION ALL BY NAME\n\nSELECT 'top_fielding_assists_career' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n SUM(COALESCE(Field_Assists, 0)) AS Assists\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1\n AND SeasonType IN ${inputs.career.value}\n GROUP BY PlayerName\n ),\n Ranked AS (\n SELECT\n PlayerName,\n Assists,\n RANK() OVER (ORDER BY Assists DESC) AS Rank\n FROM Base\n )\n SELECT\n Rank,\n PlayerName,\n '/player-profiles/' || PlayerName AS link,\n Assists\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName\n) AS top_fielding_assists_career\n\nUNION ALL BY NAME\n\nSELECT 'top_fielding_doubleplays_career' AS RecordKey, *\nFROM (\n WITH Base AS (\n SELECT\n PlayerName,\n SUM(COALESCE(Field_DoublePlays, 0)) AS DoublePlays\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1\n AND SeasonType IN ${inputs.career.value}\n GROUP BY PlayerName\n ),\n Ranked AS (\n SELECT\n PlayerName,\n DoublePlays,\n RANK() OVER (ORDER BY DoublePlays DESC) AS Rank\n FROM Base\n )\n SELECT\n Rank,\n PlayerName,\n '/player-profiles/' || PlayerName AS link,\n DoublePlays\n FROM Ranked\n WHERE Rank <= 10\n ORDER BY Rank, PlayerName\n) AS top_fielding_doubleplays_career","compiled":false,"inline":false}]}

Fielding Records

Single Game Records

Season Records

Career Records