{"queries":[{"id":"season_types","compiledQueryString":"-- Purpose: Defines the shared season-type dropdown options used by record-book pages.\n-- Data flow: Static query consumed by pages that filter all games, regular season,\n-- postseason, ACC tournament, NCAA tournament, WNIT, or AIAW rows.\n-- Output grain: One dropdown option with value, label, and display order.\n-- Maintenance notes: Values must match SeasonType values or page-level special-case logic.\nSELECT 'All' AS value, 'All Games' AS label, 0 AS sort_order\nUNION ALL\nSELECT 'REG', 'Regular Season', 1\nUNION ALL\nSELECT 'POST', 'All Postseason', 2\nUNION ALL\nSELECT 'ACC', 'ACC Tournament', 3\nUNION ALL\nSELECT 'NCAA', 'NCAA Tournament', 4\nUNION ALL\nSELECT 'AIAW', 'AIAW Tournament', 5\nUNION ALL\nSELECT 'NWIT', 'NWIT Tournament', 6\nUNION ALL\nSELECT 'WNIT', 'WNIT Tournament',7\nORDER BY sort_order","inputQueryString":"-- Purpose: Defines the shared season-type dropdown options used by record-book pages.\n-- Data flow: Static query consumed by pages that filter all games, regular season,\n-- postseason, ACC tournament, NCAA tournament, WNIT, or AIAW rows.\n-- Output grain: One dropdown option with value, label, and display order.\n-- Maintenance notes: Values must match SeasonType values or page-level special-case logic.\nSELECT 'All' AS value, 'All Games' AS label, 0 AS sort_order\nUNION ALL\nSELECT 'REG', 'Regular Season', 1\nUNION ALL\nSELECT 'POST', 'All Postseason', 2\nUNION ALL\nSELECT 'ACC', 'ACC Tournament', 3\nUNION ALL\nSELECT 'NCAA', 'NCAA Tournament', 4\nUNION ALL\nSELECT 'AIAW', 'AIAW Tournament', 5\nUNION ALL\nSELECT 'NWIT', 'NWIT Tournament', 6\nUNION ALL\nSELECT 'WNIT', 'WNIT Tournament',7\nORDER BY sort_order","compiled":false,"inline":false},{"id":"opponent_options","compiledQueryString":"-- Shared opponent dropdown. The '__ALL__' row is preserved so filters can detect\n-- \"all opponents\" without building a separate query path.\nSELECT DISTINCT\n Opponent,\n OpponentLabel,\n sort_order\nFROM SPORTS_INFO_DW_REPORTING.opponent_options\nWHERE Opponent = '__ALL__'\n OR '${inputs.season_type_button}' IN ('All', 'All Season')\n OR (\n '${inputs.season_type_button}' = 'POST'\n AND SeasonType IN ('ACC', 'NCAA', 'AIAW', 'NWIT', 'WNIT')\n )\n OR SeasonType = '${inputs.season_type_button}'\nORDER BY sort_order, OpponentLabel","inputQueryString":"-- Shared opponent dropdown. The '__ALL__' row is preserved so filters can detect\n-- \"all opponents\" without building a separate query path.\nSELECT DISTINCT\n Opponent,\n OpponentLabel,\n sort_order\nFROM SPORTS_INFO_DW_REPORTING.opponent_options\nWHERE Opponent = '__ALL__'\n OR '${inputs.season_type_button}' IN ('All', 'All Season')\n OR (\n '${inputs.season_type_button}' = 'POST'\n AND SeasonType IN ('ACC', 'NCAA', 'AIAW', 'NWIT', 'WNIT')\n )\n OR SeasonType = '${inputs.season_type_button}'\nORDER BY sort_order, OpponentLabel","compiled":false,"inline":true},{"id":"single_game_metric_options","compiledQueryString":"-- Defines the metrics available in the single-game dropdown. The metric_value entries\n-- are later matched to source columns in the ranking query.\nSELECT *\nFROM (\n VALUES\n ('TotalPoints', 'Points'),\n ('TotalRebounds', 'Rebounds'),\n ('OffensiveRebounds', 'Offensive Rebounds'),\n ('DefensiveRebounds', 'Defensive Rebounds'),\n ('Assists', 'Assists'),\n ('Steals', 'Steals'),\n ('Blocks', 'Blocks'),\n ('ThreePointersMade', 'Three Pointers Made'),\n ('FreeThrowsMade', 'Free Throws Made'),\n ('Turnovers', 'Turnovers'),\n ('FieldGoalsMade', 'Field Goals Made'),\n ('FieldGoalsAttempted', 'Field Goals Attempted'),\n ('ThreePointersAttempted', 'Three Pointers Attempted'),\n ('FreeThrowsAttempted', 'Free Throws Attempted'),\n ('FieldGoalPercentage', 'Field Goal Percentage'),\n ('ThreePointerPercentage', 'Three Pointer Percentage'),\n ('PerfectFreeThrowGame', 'Perfect Free Throw Games')\n) AS t(metric_value, metric_label)","inputQueryString":"-- Defines the metrics available in the single-game dropdown. The metric_value entries\n-- are later matched to source columns in the ranking query.\nSELECT *\nFROM (\n VALUES\n ('TotalPoints', 'Points'),\n ('TotalRebounds', 'Rebounds'),\n ('OffensiveRebounds', 'Offensive Rebounds'),\n ('DefensiveRebounds', 'Defensive Rebounds'),\n ('Assists', 'Assists'),\n ('Steals', 'Steals'),\n ('Blocks', 'Blocks'),\n ('ThreePointersMade', 'Three Pointers Made'),\n ('FreeThrowsMade', 'Free Throws Made'),\n ('Turnovers', 'Turnovers'),\n ('FieldGoalsMade', 'Field Goals Made'),\n ('FieldGoalsAttempted', 'Field Goals Attempted'),\n ('ThreePointersAttempted', 'Three Pointers Attempted'),\n ('FreeThrowsAttempted', 'Free Throws Attempted'),\n ('FieldGoalPercentage', 'Field Goal Percentage'),\n ('ThreePointerPercentage', 'Three Pointer Percentage'),\n ('PerfectFreeThrowGame', 'Perfect Free Throw Games')\n) AS t(metric_value, metric_label)","compiled":false,"inline":true},{"id":"selected_single_game_metric","compiledQueryString":"-- Reduces the metric options to the currently selected dropdown row and builds the\n-- DataTable title used below.\nSELECT\n metric_value,\n metric_label,\n CASE\n WHEN metric_value = 'PerfectFreeThrowGame' THEN metric_label\n ELSE 'Single Game Record for ' || metric_label\n END AS table_title,\n 'No.' AS column_title\nFROM (-- Defines the metrics available in the single-game dropdown. The metric_value entries\n-- are later matched to source columns in the ranking query.\nSELECT *\nFROM (\n VALUES\n ('TotalPoints', 'Points'),\n ('TotalRebounds', 'Rebounds'),\n ('OffensiveRebounds', 'Offensive Rebounds'),\n ('DefensiveRebounds', 'Defensive Rebounds'),\n ('Assists', 'Assists'),\n ('Steals', 'Steals'),\n ('Blocks', 'Blocks'),\n ('ThreePointersMade', 'Three Pointers Made'),\n ('FreeThrowsMade', 'Free Throws Made'),\n ('Turnovers', 'Turnovers'),\n ('FieldGoalsMade', 'Field Goals Made'),\n ('FieldGoalsAttempted', 'Field Goals Attempted'),\n ('ThreePointersAttempted', 'Three Pointers Attempted'),\n ('FreeThrowsAttempted', 'Free Throws Attempted'),\n ('FieldGoalPercentage', 'Field Goal Percentage'),\n ('ThreePointerPercentage', 'Three Pointer Percentage'),\n ('PerfectFreeThrowGame', 'Perfect Free Throw Games')\n) AS t(metric_value, metric_label))\nWHERE metric_value = '${inputs.single_game_record_metric.value}'","inputQueryString":"-- Reduces the metric options to the currently selected dropdown row and builds the\n-- DataTable title used below.\nSELECT\n metric_value,\n metric_label,\n CASE\n WHEN metric_value = 'PerfectFreeThrowGame' THEN metric_label\n ELSE 'Single Game Record for ' || metric_label\n END AS table_title,\n 'No.' AS column_title\nFROM ${single_game_metric_options}\nWHERE metric_value = '${inputs.single_game_record_metric.value}'","compiled":true,"inline":true},{"id":"single_game_selected_opponents","compiledQueryString":"-- Contains only explicitly selected opponents; an empty result means all opponents.\nSELECT Opponent\nFROM (-- Shared opponent dropdown. The '__ALL__' row is preserved so filters can detect\n-- \"all opponents\" without building a separate query path.\nSELECT DISTINCT\n Opponent,\n OpponentLabel,\n sort_order\nFROM SPORTS_INFO_DW_REPORTING.opponent_options\nWHERE Opponent = '__ALL__'\n OR '${inputs.season_type_button}' IN ('All', 'All Season')\n OR (\n '${inputs.season_type_button}' = 'POST'\n AND SeasonType IN ('ACC', 'NCAA', 'AIAW', 'NWIT', 'WNIT')\n )\n OR SeasonType = '${inputs.season_type_button}'\nORDER BY sort_order, OpponentLabel)\nWHERE Opponent <> '__ALL__'\n AND '__ALL__' NOT IN ${inputs.opponent_dropdown_game.value}\n AND Opponent IN ${inputs.opponent_dropdown_game.value}","inputQueryString":"-- Contains only explicitly selected opponents; an empty result means all opponents.\nSELECT Opponent\nFROM ${opponent_options}\nWHERE Opponent <> '__ALL__'\n AND '__ALL__' NOT IN ${inputs.opponent_dropdown_game.value}\n AND Opponent IN ${inputs.opponent_dropdown_game.value}","compiled":true,"inline":true},{"id":"single_game_selection_context","compiledQueryString":"-- Counts selected opponents so the ranking query can apply one WHERE clause for both\n-- \"all opponents\" and specific-opponent modes.\nSELECT\n COUNT(*) AS SelectedOpponentCount\nFROM (-- Contains only explicitly selected opponents; an empty result means all opponents.\nSELECT Opponent\nFROM (-- Shared opponent dropdown. The '__ALL__' row is preserved so filters can detect\n-- \"all opponents\" without building a separate query path.\nSELECT DISTINCT\n Opponent,\n OpponentLabel,\n sort_order\nFROM SPORTS_INFO_DW_REPORTING.opponent_options\nWHERE Opponent = '__ALL__'\n OR '${inputs.season_type_button}' IN ('All', 'All Season')\n OR (\n '${inputs.season_type_button}' = 'POST'\n AND SeasonType IN ('ACC', 'NCAA', 'AIAW', 'NWIT', 'WNIT')\n )\n OR SeasonType = '${inputs.season_type_button}'\nORDER BY sort_order, OpponentLabel)\nWHERE Opponent <> '__ALL__'\n AND '__ALL__' NOT IN ${inputs.opponent_dropdown_game.value}\n AND Opponent IN ${inputs.opponent_dropdown_game.value})","inputQueryString":"-- Counts selected opponents so the ranking query can apply one WHERE clause for both\n-- \"all opponents\" and specific-opponent modes.\nSELECT\n COUNT(*) AS SelectedOpponentCount\nFROM ${single_game_selected_opponents}","compiled":true,"inline":true},{"id":"individual_single_game_ranking","compiledQueryString":"-- Builds Clemson single-game leaderboards. RANK gives tied performances the same\n-- position and skips the next rank; rows with NULL metric values are not ranked.\nWITH selection_context AS (\n SELECT *\n FROM (-- Counts selected opponents so the ranking query can apply one WHERE clause for both\n-- \"all opponents\" and specific-opponent modes.\nSELECT\n COUNT(*) AS SelectedOpponentCount\nFROM (-- Contains only explicitly selected opponents; an empty result means all opponents.\nSELECT Opponent\nFROM (-- Shared opponent dropdown. The '__ALL__' row is preserved so filters can detect\n-- \"all opponents\" without building a separate query path.\nSELECT DISTINCT\n Opponent,\n OpponentLabel,\n sort_order\nFROM SPORTS_INFO_DW_REPORTING.opponent_options\nWHERE Opponent = '__ALL__'\n OR '${inputs.season_type_button}' IN ('All', 'All Season')\n OR (\n '${inputs.season_type_button}' = 'POST'\n AND SeasonType IN ('ACC', 'NCAA', 'AIAW', 'NWIT', 'WNIT')\n )\n OR SeasonType = '${inputs.season_type_button}'\nORDER BY sort_order, OpponentLabel)\nWHERE Opponent <> '__ALL__'\n AND '__ALL__' NOT IN ${inputs.opponent_dropdown_game.value}\n AND Opponent IN ${inputs.opponent_dropdown_game.value}))\n),\n\ngame_source AS (\n -- One Clemson player-game row with season-type filtering applied before stat ranking.\n SELECT\n p.*,\n CASE\n WHEN '${inputs.season_type_button}' IN ('All', 'All Season') THEN 'All'\n WHEN '${inputs.season_type_button}' = 'POST' THEN 'POST'\n ELSE p.SeasonType\n END AS RecordSeasonType\n FROM SPORTS_INFO_DW_REPORTING.vw_WBB_player_stats_by_game p\n WHERE p.IsClemson = 1\n AND (\n '${inputs.season_type_button}' IN ('All', 'All Season')\n OR (\n '${inputs.season_type_button}' = 'POST'\n AND p.SeasonType IN ('ACC', 'NCAA', 'AIAW', 'NWIT', 'WNIT')\n )\n OR p.SeasonType = '${inputs.season_type_button}'\n )\n),\n\nsingle_game_stats AS (\n -- CROSS JOIN LATERAL turns the selected wide stat columns into one metric/value pair.\n -- Percentage and perfect-free-throw metrics apply attempt minimums before ranking.\n SELECT\n CASE\n WHEN PlayerName IN ('Amanda Frist','Amanda White') THEN 'Amanda Frist'\n WHEN PlayerName IN ('Julie Larson','Julie L. Brickley') THEN 'Julie Brickley'\n ELSE PlayerName END AS PlayerName,\n '/player_profiles/' || replace(replace(PlayerName, ' ', '%20'), '''', '%27') AS link,\n Season,\n GameDate,\n Opponent,\n RecordSeasonType AS SeasonType,\n\n SUM(FreeThrowsMade) AS FreeThrowsMade,\n SUM(FreeThrowsAttempted) AS FreeThrowsAttempted,\n SUM(FieldGoalsMade) AS FieldGoalsMade,\n SUM(FieldGoalsAttempted) AS FieldGoalsAttempted,\n SUM(ThreePointersMade) AS ThreePointersMade,\n SUM(ThreePointersAttempted) AS ThreePointersAttempted,\n\n CASE\n WHEN '${inputs.single_game_record_metric.value}' = 'FieldGoalPercentage'\n THEN\n CASE\n WHEN SUM(FieldGoalsAttempted) >= 10\n THEN SUM(FieldGoalsMade) * 1.0 / NULLIF(SUM(FieldGoalsAttempted), 0)\n ELSE NULL\n END\n\n WHEN '${inputs.single_game_record_metric.value}' = 'ThreePointerPercentage'\n THEN\n CASE\n WHEN SUM(ThreePointersAttempted) >= 10\n THEN SUM(ThreePointersMade) * 1.0 / NULLIF(SUM(ThreePointersAttempted), 0)\n ELSE NULL\n END\n\n WHEN '${inputs.single_game_record_metric.value}' = 'FreeThrowPercentage'\n THEN\n CASE\n WHEN SUM(FreeThrowsAttempted) >= 10\n THEN SUM(FreeThrowsMade) * 1.0 / NULLIF(SUM(FreeThrowsAttempted), 0)\n ELSE NULL\n END\n\n WHEN '${inputs.single_game_record_metric.value}' = 'PerfectFreeThrowGame'\n THEN\n CASE\n WHEN SUM(FreeThrowsAttempted) >= 5\n AND SUM(FreeThrowsMade) = SUM(FreeThrowsAttempted)\n THEN SUM(FreeThrowsAttempted)\n ELSE NULL\n END\n\n ELSE ANY_VALUE(${inputs.single_game_record_metric.value})\n END AS SingleGameStatistic\n FROM (\n SELECT\n *,\n CAST(NULL AS DOUBLE) AS PerfectFreeThrowGame\n FROM game_source\n ) stats\n CROSS JOIN selection_context sc\n WHERE CAST(LEFT(Season, 4) AS INT) >= 1976\n AND (\n sc.SelectedOpponentCount = 0\n OR Opponent IN (\n SELECT Opponent\n FROM (-- Contains only explicitly selected opponents; an empty result means all opponents.\nSELECT Opponent\nFROM (-- Shared opponent dropdown. The '__ALL__' row is preserved so filters can detect\n-- \"all opponents\" without building a separate query path.\nSELECT DISTINCT\n Opponent,\n OpponentLabel,\n sort_order\nFROM SPORTS_INFO_DW_REPORTING.opponent_options\nWHERE Opponent = '__ALL__'\n OR '${inputs.season_type_button}' IN ('All', 'All Season')\n OR (\n '${inputs.season_type_button}' = 'POST'\n AND SeasonType IN ('ACC', 'NCAA', 'AIAW', 'NWIT', 'WNIT')\n )\n OR SeasonType = '${inputs.season_type_button}'\nORDER BY sort_order, OpponentLabel)\nWHERE Opponent <> '__ALL__'\n AND '__ALL__' NOT IN ${inputs.opponent_dropdown_game.value}\n AND Opponent IN ${inputs.opponent_dropdown_game.value})\n )\n )\n GROUP BY PlayerName, Season, GameDate, Opponent, RecordSeasonType\n HAVING\n '${inputs.single_game_record_metric.value}' <> 'PerfectFreeThrowGame'\n OR (\n SUM(FreeThrowsAttempted) >= 5\n AND SUM(FreeThrowsMade) = SUM(FreeThrowsAttempted)\n )\n),\n\nranked AS (\n -- Highest values rank first. RANK keeps tied performances together.\n SELECT\n *,\n RANK() OVER (\n ORDER BY SingleGameStatistic DESC NULLS LAST\n ) AS SingleGameRanking\n FROM single_game_stats\n)\n\nSELECT *\nFROM ranked\nORDER BY SingleGameRanking\nLIMIT 100","inputQueryString":"-- Builds Clemson single-game leaderboards. RANK gives tied performances the same\n-- position and skips the next rank; rows with NULL metric values are not ranked.\nWITH selection_context AS (\n SELECT *\n FROM ${single_game_selection_context}\n),\n\ngame_source AS (\n -- One Clemson player-game row with season-type filtering applied before stat ranking.\n SELECT\n p.*,\n CASE\n WHEN '${inputs.season_type_button}' IN ('All', 'All Season') THEN 'All'\n WHEN '${inputs.season_type_button}' = 'POST' THEN 'POST'\n ELSE p.SeasonType\n END AS RecordSeasonType\n FROM SPORTS_INFO_DW_REPORTING.vw_WBB_player_stats_by_game p\n WHERE p.IsClemson = 1\n AND (\n '${inputs.season_type_button}' IN ('All', 'All Season')\n OR (\n '${inputs.season_type_button}' = 'POST'\n AND p.SeasonType IN ('ACC', 'NCAA', 'AIAW', 'NWIT', 'WNIT')\n )\n OR p.SeasonType = '${inputs.season_type_button}'\n )\n),\n\nsingle_game_stats AS (\n -- CROSS JOIN LATERAL turns the selected wide stat columns into one metric/value pair.\n -- Percentage and perfect-free-throw metrics apply attempt minimums before ranking.\n SELECT\n CASE\n WHEN PlayerName IN ('Amanda Frist','Amanda White') THEN 'Amanda Frist'\n WHEN PlayerName IN ('Julie Larson','Julie L. Brickley') THEN 'Julie Brickley'\n ELSE PlayerName END AS PlayerName,\n '/player_profiles/' || replace(replace(PlayerName, ' ', '%20'), '''', '%27') AS link,\n Season,\n GameDate,\n Opponent,\n RecordSeasonType AS SeasonType,\n\n SUM(FreeThrowsMade) AS FreeThrowsMade,\n SUM(FreeThrowsAttempted) AS FreeThrowsAttempted,\n SUM(FieldGoalsMade) AS FieldGoalsMade,\n SUM(FieldGoalsAttempted) AS FieldGoalsAttempted,\n SUM(ThreePointersMade) AS ThreePointersMade,\n SUM(ThreePointersAttempted) AS ThreePointersAttempted,\n\n CASE\n WHEN '${inputs.single_game_record_metric.value}' = 'FieldGoalPercentage'\n THEN\n CASE\n WHEN SUM(FieldGoalsAttempted) >= 10\n THEN SUM(FieldGoalsMade) * 1.0 / NULLIF(SUM(FieldGoalsAttempted), 0)\n ELSE NULL\n END\n\n WHEN '${inputs.single_game_record_metric.value}' = 'ThreePointerPercentage'\n THEN\n CASE\n WHEN SUM(ThreePointersAttempted) >= 10\n THEN SUM(ThreePointersMade) * 1.0 / NULLIF(SUM(ThreePointersAttempted), 0)\n ELSE NULL\n END\n\n WHEN '${inputs.single_game_record_metric.value}' = 'FreeThrowPercentage'\n THEN\n CASE\n WHEN SUM(FreeThrowsAttempted) >= 10\n THEN SUM(FreeThrowsMade) * 1.0 / NULLIF(SUM(FreeThrowsAttempted), 0)\n ELSE NULL\n END\n\n WHEN '${inputs.single_game_record_metric.value}' = 'PerfectFreeThrowGame'\n THEN\n CASE\n WHEN SUM(FreeThrowsAttempted) >= 5\n AND SUM(FreeThrowsMade) = SUM(FreeThrowsAttempted)\n THEN SUM(FreeThrowsAttempted)\n ELSE NULL\n END\n\n ELSE ANY_VALUE(${inputs.single_game_record_metric.value})\n END AS SingleGameStatistic\n FROM (\n SELECT\n *,\n CAST(NULL AS DOUBLE) AS PerfectFreeThrowGame\n FROM game_source\n ) stats\n CROSS JOIN selection_context sc\n WHERE CAST(LEFT(Season, 4) AS INT) >= 1976\n AND (\n sc.SelectedOpponentCount = 0\n OR Opponent IN (\n SELECT Opponent\n FROM ${single_game_selected_opponents}\n )\n )\n GROUP BY PlayerName, Season, GameDate, Opponent, RecordSeasonType\n HAVING\n '${inputs.single_game_record_metric.value}' <> 'PerfectFreeThrowGame'\n OR (\n SUM(FreeThrowsAttempted) >= 5\n AND SUM(FreeThrowsMade) = SUM(FreeThrowsAttempted)\n )\n),\n\nranked AS (\n -- Highest values rank first. RANK keeps tied performances together.\n SELECT\n *,\n RANK() OVER (\n ORDER BY SingleGameStatistic DESC NULLS LAST\n ) AS SingleGameRanking\n FROM single_game_stats\n)\n\nSELECT *\nFROM ranked\nORDER BY SingleGameRanking\nLIMIT 100","compiled":true,"inline":true},{"id":"season_record_metric_options","compiledQueryString":"-- Defines season-total and season-per-game dropdown metrics. Metric values are grouped\n-- so the page can show separate total and per-game controls from one options table.\nSELECT *\nFROM (\n VALUES\n (1, 'Total', 'Total_TotalPoints', 'Points', 'Season Total Points Records', 'No.'),\n (2, 'Total', 'Total_TotalRebounds', 'Rebounds', 'Season Total Rebounds Records', 'No.'),\n (3, 'Total', 'Total_OffensiveRebounds', 'Offensive Rebounds', 'Season Total Offensive Rebounds Records', 'No.'),\n (4, 'Total', 'Total_DefensiveRebounds', 'Defensive Rebounds', 'Season Total Defensive Rebounds Records', 'No.'),\n (5, 'Total', 'Total_Assists', 'Assists', 'Season Total Assists Records', 'No.'),\n (6, 'Total', 'Total_Steals', 'Steals', 'Season Total Steals Records', 'No.'),\n (7, 'Total', 'Total_Blocks', 'Blocks', 'Season Total Blocks Records', 'No.'),\n (8, 'Total', 'Total_ThreePointersMade', 'Three Pointers Made', 'Season Three Pointers Made Records', 'No.'),\n (9, 'Total', 'Total_FreeThrowsMade', 'Free Throws Made', 'Season Free Throws Made Records', 'No.'),\n (10, 'Total', 'Total_Turnovers', 'Turnovers', 'Season Total Turnovers Records', 'No.'),\n (11, 'Total', 'Total_FieldGoalsMade', 'Field Goals Made', 'Season Field Goals Made Records', 'No.'),\n (12, 'Total', 'Total_FieldGoalsAttempted', 'Field Goals Attempted', 'Season Field Goals Attempted Records', 'No.'),\n (13, 'Total', 'Total_ThreePointersAttempted', 'Three Pointers Attempted', 'Season Three Pointers Attempted Records', 'No.'),\n (14, 'Total', 'Total_FreeThrowsAttempted', 'Free Throws Attempted', 'Season Free Throws Attempted Records', 'No.'),\n\n (15, 'Average', 'Average_TotalPoints', 'Points', 'Season Points Per Game Records', 'No.'),\n (16, 'Average', 'Average_TotalRebounds', 'Rebounds', 'Season Rebounds Per Game Records', 'No.'),\n (17, 'Average', 'Average_OffensiveRebounds', 'Offensive Rebounds', 'Season Offensive Rebounds Per Game Records', 'No.'),\n (18, 'Average', 'Average_DefensiveRebounds', 'Defensive Rebounds', 'Season Defensive Rebounds Per Game Records', 'No.'),\n (19, 'Average', 'Average_Assists', 'Assists', 'Season Assists Per Game Records', 'No.'),\n (20, 'Average', 'Average_Steals', 'Steals', 'Season Steals Per Game Records', 'No.'),\n (21, 'Average', 'Average_Blocks', 'Blocks', 'Season Blocks Per Game Records', 'No.'),\n (22, 'Average', 'Average_ThreePointersMade', 'Three Pointers Made', 'Season Three Pointers Made Per Game Records', 'No.'),\n (23, 'Average', 'Average_FreeThrowsMade', 'Free Throws Made', 'Season Free Throws Made Per Game Records', 'No.'),\n (24, 'Average', 'Average_Turnovers', 'Turnovers Per Game', 'Season Turnovers Per Game Records', 'No.'),\n (25, 'Average', 'Average_FieldGoalsMade', 'Field Goals Made', 'Season Field Goals Made Per Game Records', 'No.'),\n (26, 'Average', 'Average_FieldGoalsAttempted', 'Field Goals Attempted', 'Season Field Goals Attempted Per Game Records', 'No.'),\n (27, 'Average', 'Average_ThreePointersAttempted','Three Pointers Attempted', 'Season Three Pointers Attempted Per Game Records','No.'),\n (28, 'Average', 'Average_FreeThrowsAttempted', 'Free Throws Attempted', 'Season Free Throws Attempted Per Game Records', 'No.'),\n (29, 'Average', 'Average_FieldGoalPercentage', 'Field Goal Percentage', 'Season Field Goal Percentage Records', 'No.'),\n (30, 'Average', 'Average_ThreePointerPercentage','Three Pointer Percentage', 'Season Three Point Percentage Records', 'No.'),\n (31, 'Average', 'Average_FreeThrowPercentage', 'Free Throw Percentage', 'Season Free Throw Percentage Records', 'No.')\n) AS t(metric_order, metric_type, metric_value, metric_label, table_title, column_title)","inputQueryString":"-- Defines season-total and season-per-game dropdown metrics. Metric values are grouped\n-- so the page can show separate total and per-game controls from one options table.\nSELECT *\nFROM (\n VALUES\n (1, 'Total', 'Total_TotalPoints', 'Points', 'Season Total Points Records', 'No.'),\n (2, 'Total', 'Total_TotalRebounds', 'Rebounds', 'Season Total Rebounds Records', 'No.'),\n (3, 'Total', 'Total_OffensiveRebounds', 'Offensive Rebounds', 'Season Total Offensive Rebounds Records', 'No.'),\n (4, 'Total', 'Total_DefensiveRebounds', 'Defensive Rebounds', 'Season Total Defensive Rebounds Records', 'No.'),\n (5, 'Total', 'Total_Assists', 'Assists', 'Season Total Assists Records', 'No.'),\n (6, 'Total', 'Total_Steals', 'Steals', 'Season Total Steals Records', 'No.'),\n (7, 'Total', 'Total_Blocks', 'Blocks', 'Season Total Blocks Records', 'No.'),\n (8, 'Total', 'Total_ThreePointersMade', 'Three Pointers Made', 'Season Three Pointers Made Records', 'No.'),\n (9, 'Total', 'Total_FreeThrowsMade', 'Free Throws Made', 'Season Free Throws Made Records', 'No.'),\n (10, 'Total', 'Total_Turnovers', 'Turnovers', 'Season Total Turnovers Records', 'No.'),\n (11, 'Total', 'Total_FieldGoalsMade', 'Field Goals Made', 'Season Field Goals Made Records', 'No.'),\n (12, 'Total', 'Total_FieldGoalsAttempted', 'Field Goals Attempted', 'Season Field Goals Attempted Records', 'No.'),\n (13, 'Total', 'Total_ThreePointersAttempted', 'Three Pointers Attempted', 'Season Three Pointers Attempted Records', 'No.'),\n (14, 'Total', 'Total_FreeThrowsAttempted', 'Free Throws Attempted', 'Season Free Throws Attempted Records', 'No.'),\n\n (15, 'Average', 'Average_TotalPoints', 'Points', 'Season Points Per Game Records', 'No.'),\n (16, 'Average', 'Average_TotalRebounds', 'Rebounds', 'Season Rebounds Per Game Records', 'No.'),\n (17, 'Average', 'Average_OffensiveRebounds', 'Offensive Rebounds', 'Season Offensive Rebounds Per Game Records', 'No.'),\n (18, 'Average', 'Average_DefensiveRebounds', 'Defensive Rebounds', 'Season Defensive Rebounds Per Game Records', 'No.'),\n (19, 'Average', 'Average_Assists', 'Assists', 'Season Assists Per Game Records', 'No.'),\n (20, 'Average', 'Average_Steals', 'Steals', 'Season Steals Per Game Records', 'No.'),\n (21, 'Average', 'Average_Blocks', 'Blocks', 'Season Blocks Per Game Records', 'No.'),\n (22, 'Average', 'Average_ThreePointersMade', 'Three Pointers Made', 'Season Three Pointers Made Per Game Records', 'No.'),\n (23, 'Average', 'Average_FreeThrowsMade', 'Free Throws Made', 'Season Free Throws Made Per Game Records', 'No.'),\n (24, 'Average', 'Average_Turnovers', 'Turnovers Per Game', 'Season Turnovers Per Game Records', 'No.'),\n (25, 'Average', 'Average_FieldGoalsMade', 'Field Goals Made', 'Season Field Goals Made Per Game Records', 'No.'),\n (26, 'Average', 'Average_FieldGoalsAttempted', 'Field Goals Attempted', 'Season Field Goals Attempted Per Game Records', 'No.'),\n (27, 'Average', 'Average_ThreePointersAttempted','Three Pointers Attempted', 'Season Three Pointers Attempted Per Game Records','No.'),\n (28, 'Average', 'Average_FreeThrowsAttempted', 'Free Throws Attempted', 'Season Free Throws Attempted Per Game Records', 'No.'),\n (29, 'Average', 'Average_FieldGoalPercentage', 'Field Goal Percentage', 'Season Field Goal Percentage Records', 'No.'),\n (30, 'Average', 'Average_ThreePointerPercentage','Three Pointer Percentage', 'Season Three Point Percentage Records', 'No.'),\n (31, 'Average', 'Average_FreeThrowPercentage', 'Free Throw Percentage', 'Season Free Throw Percentage Records', 'No.')\n) AS t(metric_order, metric_type, metric_value, metric_label, table_title, column_title)","compiled":false,"inline":true},{"id":"season_metric_totals_options","compiledQueryString":"SELECT *\nFROM (-- Defines season-total and season-per-game dropdown metrics. Metric values are grouped\n-- so the page can show separate total and per-game controls from one options table.\nSELECT *\nFROM (\n VALUES\n (1, 'Total', 'Total_TotalPoints', 'Points', 'Season Total Points Records', 'No.'),\n (2, 'Total', 'Total_TotalRebounds', 'Rebounds', 'Season Total Rebounds Records', 'No.'),\n (3, 'Total', 'Total_OffensiveRebounds', 'Offensive Rebounds', 'Season Total Offensive Rebounds Records', 'No.'),\n (4, 'Total', 'Total_DefensiveRebounds', 'Defensive Rebounds', 'Season Total Defensive Rebounds Records', 'No.'),\n (5, 'Total', 'Total_Assists', 'Assists', 'Season Total Assists Records', 'No.'),\n (6, 'Total', 'Total_Steals', 'Steals', 'Season Total Steals Records', 'No.'),\n (7, 'Total', 'Total_Blocks', 'Blocks', 'Season Total Blocks Records', 'No.'),\n (8, 'Total', 'Total_ThreePointersMade', 'Three Pointers Made', 'Season Three Pointers Made Records', 'No.'),\n (9, 'Total', 'Total_FreeThrowsMade', 'Free Throws Made', 'Season Free Throws Made Records', 'No.'),\n (10, 'Total', 'Total_Turnovers', 'Turnovers', 'Season Total Turnovers Records', 'No.'),\n (11, 'Total', 'Total_FieldGoalsMade', 'Field Goals Made', 'Season Field Goals Made Records', 'No.'),\n (12, 'Total', 'Total_FieldGoalsAttempted', 'Field Goals Attempted', 'Season Field Goals Attempted Records', 'No.'),\n (13, 'Total', 'Total_ThreePointersAttempted', 'Three Pointers Attempted', 'Season Three Pointers Attempted Records', 'No.'),\n (14, 'Total', 'Total_FreeThrowsAttempted', 'Free Throws Attempted', 'Season Free Throws Attempted Records', 'No.'),\n\n (15, 'Average', 'Average_TotalPoints', 'Points', 'Season Points Per Game Records', 'No.'),\n (16, 'Average', 'Average_TotalRebounds', 'Rebounds', 'Season Rebounds Per Game Records', 'No.'),\n (17, 'Average', 'Average_OffensiveRebounds', 'Offensive Rebounds', 'Season Offensive Rebounds Per Game Records', 'No.'),\n (18, 'Average', 'Average_DefensiveRebounds', 'Defensive Rebounds', 'Season Defensive Rebounds Per Game Records', 'No.'),\n (19, 'Average', 'Average_Assists', 'Assists', 'Season Assists Per Game Records', 'No.'),\n (20, 'Average', 'Average_Steals', 'Steals', 'Season Steals Per Game Records', 'No.'),\n (21, 'Average', 'Average_Blocks', 'Blocks', 'Season Blocks Per Game Records', 'No.'),\n (22, 'Average', 'Average_ThreePointersMade', 'Three Pointers Made', 'Season Three Pointers Made Per Game Records', 'No.'),\n (23, 'Average', 'Average_FreeThrowsMade', 'Free Throws Made', 'Season Free Throws Made Per Game Records', 'No.'),\n (24, 'Average', 'Average_Turnovers', 'Turnovers Per Game', 'Season Turnovers Per Game Records', 'No.'),\n (25, 'Average', 'Average_FieldGoalsMade', 'Field Goals Made', 'Season Field Goals Made Per Game Records', 'No.'),\n (26, 'Average', 'Average_FieldGoalsAttempted', 'Field Goals Attempted', 'Season Field Goals Attempted Per Game Records', 'No.'),\n (27, 'Average', 'Average_ThreePointersAttempted','Three Pointers Attempted', 'Season Three Pointers Attempted Per Game Records','No.'),\n (28, 'Average', 'Average_FreeThrowsAttempted', 'Free Throws Attempted', 'Season Free Throws Attempted Per Game Records', 'No.'),\n (29, 'Average', 'Average_FieldGoalPercentage', 'Field Goal Percentage', 'Season Field Goal Percentage Records', 'No.'),\n (30, 'Average', 'Average_ThreePointerPercentage','Three Pointer Percentage', 'Season Three Point Percentage Records', 'No.'),\n (31, 'Average', 'Average_FreeThrowPercentage', 'Free Throw Percentage', 'Season Free Throw Percentage Records', 'No.')\n) AS t(metric_order, metric_type, metric_value, metric_label, table_title, column_title))\nWHERE metric_type = 'Total'\nORDER BY metric_order","inputQueryString":"SELECT *\nFROM ${season_record_metric_options}\nWHERE metric_type = 'Total'\nORDER BY metric_order","compiled":true,"inline":true},{"id":"season_metric_per_game_options","compiledQueryString":"SELECT *\nFROM (-- Defines season-total and season-per-game dropdown metrics. Metric values are grouped\n-- so the page can show separate total and per-game controls from one options table.\nSELECT *\nFROM (\n VALUES\n (1, 'Total', 'Total_TotalPoints', 'Points', 'Season Total Points Records', 'No.'),\n (2, 'Total', 'Total_TotalRebounds', 'Rebounds', 'Season Total Rebounds Records', 'No.'),\n (3, 'Total', 'Total_OffensiveRebounds', 'Offensive Rebounds', 'Season Total Offensive Rebounds Records', 'No.'),\n (4, 'Total', 'Total_DefensiveRebounds', 'Defensive Rebounds', 'Season Total Defensive Rebounds Records', 'No.'),\n (5, 'Total', 'Total_Assists', 'Assists', 'Season Total Assists Records', 'No.'),\n (6, 'Total', 'Total_Steals', 'Steals', 'Season Total Steals Records', 'No.'),\n (7, 'Total', 'Total_Blocks', 'Blocks', 'Season Total Blocks Records', 'No.'),\n (8, 'Total', 'Total_ThreePointersMade', 'Three Pointers Made', 'Season Three Pointers Made Records', 'No.'),\n (9, 'Total', 'Total_FreeThrowsMade', 'Free Throws Made', 'Season Free Throws Made Records', 'No.'),\n (10, 'Total', 'Total_Turnovers', 'Turnovers', 'Season Total Turnovers Records', 'No.'),\n (11, 'Total', 'Total_FieldGoalsMade', 'Field Goals Made', 'Season Field Goals Made Records', 'No.'),\n (12, 'Total', 'Total_FieldGoalsAttempted', 'Field Goals Attempted', 'Season Field Goals Attempted Records', 'No.'),\n (13, 'Total', 'Total_ThreePointersAttempted', 'Three Pointers Attempted', 'Season Three Pointers Attempted Records', 'No.'),\n (14, 'Total', 'Total_FreeThrowsAttempted', 'Free Throws Attempted', 'Season Free Throws Attempted Records', 'No.'),\n\n (15, 'Average', 'Average_TotalPoints', 'Points', 'Season Points Per Game Records', 'No.'),\n (16, 'Average', 'Average_TotalRebounds', 'Rebounds', 'Season Rebounds Per Game Records', 'No.'),\n (17, 'Average', 'Average_OffensiveRebounds', 'Offensive Rebounds', 'Season Offensive Rebounds Per Game Records', 'No.'),\n (18, 'Average', 'Average_DefensiveRebounds', 'Defensive Rebounds', 'Season Defensive Rebounds Per Game Records', 'No.'),\n (19, 'Average', 'Average_Assists', 'Assists', 'Season Assists Per Game Records', 'No.'),\n (20, 'Average', 'Average_Steals', 'Steals', 'Season Steals Per Game Records', 'No.'),\n (21, 'Average', 'Average_Blocks', 'Blocks', 'Season Blocks Per Game Records', 'No.'),\n (22, 'Average', 'Average_ThreePointersMade', 'Three Pointers Made', 'Season Three Pointers Made Per Game Records', 'No.'),\n (23, 'Average', 'Average_FreeThrowsMade', 'Free Throws Made', 'Season Free Throws Made Per Game Records', 'No.'),\n (24, 'Average', 'Average_Turnovers', 'Turnovers Per Game', 'Season Turnovers Per Game Records', 'No.'),\n (25, 'Average', 'Average_FieldGoalsMade', 'Field Goals Made', 'Season Field Goals Made Per Game Records', 'No.'),\n (26, 'Average', 'Average_FieldGoalsAttempted', 'Field Goals Attempted', 'Season Field Goals Attempted Per Game Records', 'No.'),\n (27, 'Average', 'Average_ThreePointersAttempted','Three Pointers Attempted', 'Season Three Pointers Attempted Per Game Records','No.'),\n (28, 'Average', 'Average_FreeThrowsAttempted', 'Free Throws Attempted', 'Season Free Throws Attempted Per Game Records', 'No.'),\n (29, 'Average', 'Average_FieldGoalPercentage', 'Field Goal Percentage', 'Season Field Goal Percentage Records', 'No.'),\n (30, 'Average', 'Average_ThreePointerPercentage','Three Pointer Percentage', 'Season Three Point Percentage Records', 'No.'),\n (31, 'Average', 'Average_FreeThrowPercentage', 'Free Throw Percentage', 'Season Free Throw Percentage Records', 'No.')\n) AS t(metric_order, metric_type, metric_value, metric_label, table_title, column_title))\nWHERE metric_type = 'Average'\nORDER BY metric_order","inputQueryString":"SELECT *\nFROM ${season_record_metric_options}\nWHERE metric_type = 'Average'\nORDER BY metric_order","compiled":true,"inline":true},{"id":"selected_season_total_record_metric","compiledQueryString":"SELECT *\nFROM (-- Defines season-total and season-per-game dropdown metrics. Metric values are grouped\n-- so the page can show separate total and per-game controls from one options table.\nSELECT *\nFROM (\n VALUES\n (1, 'Total', 'Total_TotalPoints', 'Points', 'Season Total Points Records', 'No.'),\n (2, 'Total', 'Total_TotalRebounds', 'Rebounds', 'Season Total Rebounds Records', 'No.'),\n (3, 'Total', 'Total_OffensiveRebounds', 'Offensive Rebounds', 'Season Total Offensive Rebounds Records', 'No.'),\n (4, 'Total', 'Total_DefensiveRebounds', 'Defensive Rebounds', 'Season Total Defensive Rebounds Records', 'No.'),\n (5, 'Total', 'Total_Assists', 'Assists', 'Season Total Assists Records', 'No.'),\n (6, 'Total', 'Total_Steals', 'Steals', 'Season Total Steals Records', 'No.'),\n (7, 'Total', 'Total_Blocks', 'Blocks', 'Season Total Blocks Records', 'No.'),\n (8, 'Total', 'Total_ThreePointersMade', 'Three Pointers Made', 'Season Three Pointers Made Records', 'No.'),\n (9, 'Total', 'Total_FreeThrowsMade', 'Free Throws Made', 'Season Free Throws Made Records', 'No.'),\n (10, 'Total', 'Total_Turnovers', 'Turnovers', 'Season Total Turnovers Records', 'No.'),\n (11, 'Total', 'Total_FieldGoalsMade', 'Field Goals Made', 'Season Field Goals Made Records', 'No.'),\n (12, 'Total', 'Total_FieldGoalsAttempted', 'Field Goals Attempted', 'Season Field Goals Attempted Records', 'No.'),\n (13, 'Total', 'Total_ThreePointersAttempted', 'Three Pointers Attempted', 'Season Three Pointers Attempted Records', 'No.'),\n (14, 'Total', 'Total_FreeThrowsAttempted', 'Free Throws Attempted', 'Season Free Throws Attempted Records', 'No.'),\n\n (15, 'Average', 'Average_TotalPoints', 'Points', 'Season Points Per Game Records', 'No.'),\n (16, 'Average', 'Average_TotalRebounds', 'Rebounds', 'Season Rebounds Per Game Records', 'No.'),\n (17, 'Average', 'Average_OffensiveRebounds', 'Offensive Rebounds', 'Season Offensive Rebounds Per Game Records', 'No.'),\n (18, 'Average', 'Average_DefensiveRebounds', 'Defensive Rebounds', 'Season Defensive Rebounds Per Game Records', 'No.'),\n (19, 'Average', 'Average_Assists', 'Assists', 'Season Assists Per Game Records', 'No.'),\n (20, 'Average', 'Average_Steals', 'Steals', 'Season Steals Per Game Records', 'No.'),\n (21, 'Average', 'Average_Blocks', 'Blocks', 'Season Blocks Per Game Records', 'No.'),\n (22, 'Average', 'Average_ThreePointersMade', 'Three Pointers Made', 'Season Three Pointers Made Per Game Records', 'No.'),\n (23, 'Average', 'Average_FreeThrowsMade', 'Free Throws Made', 'Season Free Throws Made Per Game Records', 'No.'),\n (24, 'Average', 'Average_Turnovers', 'Turnovers Per Game', 'Season Turnovers Per Game Records', 'No.'),\n (25, 'Average', 'Average_FieldGoalsMade', 'Field Goals Made', 'Season Field Goals Made Per Game Records', 'No.'),\n (26, 'Average', 'Average_FieldGoalsAttempted', 'Field Goals Attempted', 'Season Field Goals Attempted Per Game Records', 'No.'),\n (27, 'Average', 'Average_ThreePointersAttempted','Three Pointers Attempted', 'Season Three Pointers Attempted Per Game Records','No.'),\n (28, 'Average', 'Average_FreeThrowsAttempted', 'Free Throws Attempted', 'Season Free Throws Attempted Per Game Records', 'No.'),\n (29, 'Average', 'Average_FieldGoalPercentage', 'Field Goal Percentage', 'Season Field Goal Percentage Records', 'No.'),\n (30, 'Average', 'Average_ThreePointerPercentage','Three Pointer Percentage', 'Season Three Point Percentage Records', 'No.'),\n (31, 'Average', 'Average_FreeThrowPercentage', 'Free Throw Percentage', 'Season Free Throw Percentage Records', 'No.')\n) AS t(metric_order, metric_type, metric_value, metric_label, table_title, column_title))\nWHERE metric_value = '${inputs.season_total_record_metric.value}'","inputQueryString":"SELECT *\nFROM ${season_record_metric_options}\nWHERE metric_value = '${inputs.season_total_record_metric.value}'","compiled":true,"inline":true},{"id":"selected_season_per_game_record_metric","compiledQueryString":"SELECT *\nFROM (-- Defines season-total and season-per-game dropdown metrics. Metric values are grouped\n-- so the page can show separate total and per-game controls from one options table.\nSELECT *\nFROM (\n VALUES\n (1, 'Total', 'Total_TotalPoints', 'Points', 'Season Total Points Records', 'No.'),\n (2, 'Total', 'Total_TotalRebounds', 'Rebounds', 'Season Total Rebounds Records', 'No.'),\n (3, 'Total', 'Total_OffensiveRebounds', 'Offensive Rebounds', 'Season Total Offensive Rebounds Records', 'No.'),\n (4, 'Total', 'Total_DefensiveRebounds', 'Defensive Rebounds', 'Season Total Defensive Rebounds Records', 'No.'),\n (5, 'Total', 'Total_Assists', 'Assists', 'Season Total Assists Records', 'No.'),\n (6, 'Total', 'Total_Steals', 'Steals', 'Season Total Steals Records', 'No.'),\n (7, 'Total', 'Total_Blocks', 'Blocks', 'Season Total Blocks Records', 'No.'),\n (8, 'Total', 'Total_ThreePointersMade', 'Three Pointers Made', 'Season Three Pointers Made Records', 'No.'),\n (9, 'Total', 'Total_FreeThrowsMade', 'Free Throws Made', 'Season Free Throws Made Records', 'No.'),\n (10, 'Total', 'Total_Turnovers', 'Turnovers', 'Season Total Turnovers Records', 'No.'),\n (11, 'Total', 'Total_FieldGoalsMade', 'Field Goals Made', 'Season Field Goals Made Records', 'No.'),\n (12, 'Total', 'Total_FieldGoalsAttempted', 'Field Goals Attempted', 'Season Field Goals Attempted Records', 'No.'),\n (13, 'Total', 'Total_ThreePointersAttempted', 'Three Pointers Attempted', 'Season Three Pointers Attempted Records', 'No.'),\n (14, 'Total', 'Total_FreeThrowsAttempted', 'Free Throws Attempted', 'Season Free Throws Attempted Records', 'No.'),\n\n (15, 'Average', 'Average_TotalPoints', 'Points', 'Season Points Per Game Records', 'No.'),\n (16, 'Average', 'Average_TotalRebounds', 'Rebounds', 'Season Rebounds Per Game Records', 'No.'),\n (17, 'Average', 'Average_OffensiveRebounds', 'Offensive Rebounds', 'Season Offensive Rebounds Per Game Records', 'No.'),\n (18, 'Average', 'Average_DefensiveRebounds', 'Defensive Rebounds', 'Season Defensive Rebounds Per Game Records', 'No.'),\n (19, 'Average', 'Average_Assists', 'Assists', 'Season Assists Per Game Records', 'No.'),\n (20, 'Average', 'Average_Steals', 'Steals', 'Season Steals Per Game Records', 'No.'),\n (21, 'Average', 'Average_Blocks', 'Blocks', 'Season Blocks Per Game Records', 'No.'),\n (22, 'Average', 'Average_ThreePointersMade', 'Three Pointers Made', 'Season Three Pointers Made Per Game Records', 'No.'),\n (23, 'Average', 'Average_FreeThrowsMade', 'Free Throws Made', 'Season Free Throws Made Per Game Records', 'No.'),\n (24, 'Average', 'Average_Turnovers', 'Turnovers Per Game', 'Season Turnovers Per Game Records', 'No.'),\n (25, 'Average', 'Average_FieldGoalsMade', 'Field Goals Made', 'Season Field Goals Made Per Game Records', 'No.'),\n (26, 'Average', 'Average_FieldGoalsAttempted', 'Field Goals Attempted', 'Season Field Goals Attempted Per Game Records', 'No.'),\n (27, 'Average', 'Average_ThreePointersAttempted','Three Pointers Attempted', 'Season Three Pointers Attempted Per Game Records','No.'),\n (28, 'Average', 'Average_FreeThrowsAttempted', 'Free Throws Attempted', 'Season Free Throws Attempted Per Game Records', 'No.'),\n (29, 'Average', 'Average_FieldGoalPercentage', 'Field Goal Percentage', 'Season Field Goal Percentage Records', 'No.'),\n (30, 'Average', 'Average_ThreePointerPercentage','Three Pointer Percentage', 'Season Three Point Percentage Records', 'No.'),\n (31, 'Average', 'Average_FreeThrowPercentage', 'Free Throw Percentage', 'Season Free Throw Percentage Records', 'No.')\n) AS t(metric_order, metric_type, metric_value, metric_label, table_title, column_title))\nWHERE metric_value = '${inputs.season_per_game_record_metric.value}'","inputQueryString":"SELECT *\nFROM ${season_record_metric_options}\nWHERE metric_value = '${inputs.season_per_game_record_metric.value}'","compiled":true,"inline":true},{"id":"season_selected_opponents","compiledQueryString":"SELECT Opponent\nFROM (-- Shared opponent dropdown. The '__ALL__' row is preserved so filters can detect\n-- \"all opponents\" without building a separate query path.\nSELECT DISTINCT\n Opponent,\n OpponentLabel,\n sort_order\nFROM SPORTS_INFO_DW_REPORTING.opponent_options\nWHERE Opponent = '__ALL__'\n OR '${inputs.season_type_button}' IN ('All', 'All Season')\n OR (\n '${inputs.season_type_button}' = 'POST'\n AND SeasonType IN ('ACC', 'NCAA', 'AIAW', 'NWIT', 'WNIT')\n )\n OR SeasonType = '${inputs.season_type_button}'\nORDER BY sort_order, OpponentLabel)\nWHERE Opponent <> '__ALL__'\n AND '__ALL__' NOT IN ${inputs.opponent_dropdown_season.value}\n AND Opponent IN ${inputs.opponent_dropdown_season.value}","inputQueryString":"SELECT Opponent\nFROM ${opponent_options}\nWHERE Opponent <> '__ALL__'\n AND '__ALL__' NOT IN ${inputs.opponent_dropdown_season.value}\n AND Opponent IN ${inputs.opponent_dropdown_season.value}","compiled":true,"inline":true},{"id":"season_record_selection_context","compiledQueryString":"-- Counts selected season opponents; zero means the season tables should use all opponents.\nWITH selection_count AS (\n SELECT\n COUNT(*) AS SelectedOpponentCount\n FROM (SELECT Opponent\nFROM (-- Shared opponent dropdown. The '__ALL__' row is preserved so filters can detect\n-- \"all opponents\" without building a separate query path.\nSELECT DISTINCT\n Opponent,\n OpponentLabel,\n sort_order\nFROM SPORTS_INFO_DW_REPORTING.opponent_options\nWHERE Opponent = '__ALL__'\n OR '${inputs.season_type_button}' IN ('All', 'All Season')\n OR (\n '${inputs.season_type_button}' = 'POST'\n AND SeasonType IN ('ACC', 'NCAA', 'AIAW', 'NWIT', 'WNIT')\n )\n OR SeasonType = '${inputs.season_type_button}'\nORDER BY sort_order, OpponentLabel)\nWHERE Opponent <> '__ALL__'\n AND '__ALL__' NOT IN ${inputs.opponent_dropdown_season.value}\n AND Opponent IN ${inputs.opponent_dropdown_season.value})\n)\n\nSELECT\n SelectedOpponentCount\nFROM selection_count","inputQueryString":"-- Counts selected season opponents; zero means the season tables should use all opponents.\nWITH selection_count AS (\n SELECT\n COUNT(*) AS SelectedOpponentCount\n FROM ${season_selected_opponents}\n)\n\nSELECT\n SelectedOpponentCount\nFROM selection_count","compiled":true,"inline":true},{"id":"player_season_base","compiledQueryString":"-- Aggregates Clemson player-games to one player-season after season-type and opponent\n-- filters are applied. Empty selected-opponent sets are treated as all opponents.\nSELECT\n CASE\n WHEN p.PlayerName IN ('Amanda Frist','Amanda White') THEN 'Amanda Frist'\n WHEN p.PlayerName IN ('Julie Larson','Julie L. Brickley') THEN 'Julie Brickley'\n ELSE p.PlayerName END AS PlayerName,\n p.Season,\n CASE\n WHEN '${inputs.season_type_button}' IN ('All', 'All Season') THEN 'All'\n WHEN '${inputs.season_type_button}' = 'POST' THEN 'POST'\n ELSE p.SeasonType\n END AS SeasonType,\n\n CASE\n WHEN sc.SelectedOpponentCount = 0 THEN 'All Opponents'\n WHEN sc.SelectedOpponentCount = 1 THEN ANY_VALUE(p.Opponent)\n ELSE STRING_AGG(DISTINCT p.Opponent, ', ')\n END AS Opponent,\n\n sc.SelectedOpponentCount,\n\n SUM(p.GamesPlayed) AS GamesPlayed,\n SUM(p.TotalPoints) AS TotalPoints,\n SUM(p.TotalRebounds) AS TotalRebounds,\n SUM(p.OffensiveRebounds) AS OffensiveRebounds,\n -- Maintenance note: This page uses the same defensive-rebound cutoff pattern as\n -- source record models, but the reason is not documented elsewhere in the repo.\n SUM(CASE WHEN p.Season >= '1985' THEN p.DefensiveRebounds ELSE 0 END) AS DefensiveRebounds,\n SUM(p.Assists) AS Assists,\n SUM(p.Steals) AS Steals,\n SUM(p.Blocks) AS Blocks,\n SUM(p.ThreePointersMade) AS ThreePointersMade,\n SUM(p.FreeThrowsMade) AS FreeThrowsMade,\n SUM(p.Turnovers) AS Turnovers,\n SUM(p.FieldGoalsMade) AS FieldGoalsMade,\n SUM(p.FieldGoalsAttempted) AS FieldGoalsAttempted,\n SUM(p.ThreePointersAttempted) AS ThreePointersAttempted,\n SUM(p.FreeThrowsAttempted) AS FreeThrowsAttempted,\n (SUM(p.GamesPlayed)*5) AS MinFieldGoalsMade,\n (SUM(p.GamesPlayed)*2) AS MinThreePointersAttempted,\n (SUM(p.GamesPlayed)*2) AS MinFreeThrowsAttempted\nFROM SPORTS_INFO_DW_REPORTING.vw_WBB_player_stats_by_game p\nCROSS JOIN (-- Counts selected season opponents; zero means the season tables should use all opponents.\nWITH selection_count AS (\n SELECT\n COUNT(*) AS SelectedOpponentCount\n FROM (SELECT Opponent\nFROM (-- Shared opponent dropdown. The '__ALL__' row is preserved so filters can detect\n-- \"all opponents\" without building a separate query path.\nSELECT DISTINCT\n Opponent,\n OpponentLabel,\n sort_order\nFROM SPORTS_INFO_DW_REPORTING.opponent_options\nWHERE Opponent = '__ALL__'\n OR '${inputs.season_type_button}' IN ('All', 'All Season')\n OR (\n '${inputs.season_type_button}' = 'POST'\n AND SeasonType IN ('ACC', 'NCAA', 'AIAW', 'NWIT', 'WNIT')\n )\n OR SeasonType = '${inputs.season_type_button}'\nORDER BY sort_order, OpponentLabel)\nWHERE Opponent <> '__ALL__'\n AND '__ALL__' NOT IN ${inputs.opponent_dropdown_season.value}\n AND Opponent IN ${inputs.opponent_dropdown_season.value})\n)\n\nSELECT\n SelectedOpponentCount\nFROM selection_count) sc\nWHERE (\n sc.SelectedOpponentCount = 0\n OR p.Opponent IN (\n SELECT Opponent\n FROM (SELECT Opponent\nFROM (-- Shared opponent dropdown. The '__ALL__' row is preserved so filters can detect\n-- \"all opponents\" without building a separate query path.\nSELECT DISTINCT\n Opponent,\n OpponentLabel,\n sort_order\nFROM SPORTS_INFO_DW_REPORTING.opponent_options\nWHERE Opponent = '__ALL__'\n OR '${inputs.season_type_button}' IN ('All', 'All Season')\n OR (\n '${inputs.season_type_button}' = 'POST'\n AND SeasonType IN ('ACC', 'NCAA', 'AIAW', 'NWIT', 'WNIT')\n )\n OR SeasonType = '${inputs.season_type_button}'\nORDER BY sort_order, OpponentLabel)\nWHERE Opponent <> '__ALL__'\n AND '__ALL__' NOT IN ${inputs.opponent_dropdown_season.value}\n AND Opponent IN ${inputs.opponent_dropdown_season.value})\n )\n )\n AND (\n '${inputs.season_type_button}' IN ('All', 'All Season')\n OR (\n '${inputs.season_type_button}' = 'POST'\n AND p.SeasonType IN ('ACC', 'NCAA', 'AIAW', 'NWIT', 'WNIT')\n )\n OR p.SeasonType = '${inputs.season_type_button}'\n )\n AND IsClemson= 1\n AND Season > '1975-1976'\nGROUP BY\n PlayerName,\n p.Season,\n CASE\n WHEN '${inputs.season_type_button}' IN ('All', 'All Season') THEN 'All'\n WHEN '${inputs.season_type_button}' = 'POST' THEN 'POST'\n ELSE p.SeasonType\n END,\n sc.SelectedOpponentCount","inputQueryString":"-- Aggregates Clemson player-games to one player-season after season-type and opponent\n-- filters are applied. Empty selected-opponent sets are treated as all opponents.\nSELECT\n CASE\n WHEN p.PlayerName IN ('Amanda Frist','Amanda White') THEN 'Amanda Frist'\n WHEN p.PlayerName IN ('Julie Larson','Julie L. Brickley') THEN 'Julie Brickley'\n ELSE p.PlayerName END AS PlayerName,\n p.Season,\n CASE\n WHEN '${inputs.season_type_button}' IN ('All', 'All Season') THEN 'All'\n WHEN '${inputs.season_type_button}' = 'POST' THEN 'POST'\n ELSE p.SeasonType\n END AS SeasonType,\n\n CASE\n WHEN sc.SelectedOpponentCount = 0 THEN 'All Opponents'\n WHEN sc.SelectedOpponentCount = 1 THEN ANY_VALUE(p.Opponent)\n ELSE STRING_AGG(DISTINCT p.Opponent, ', ')\n END AS Opponent,\n\n sc.SelectedOpponentCount,\n\n SUM(p.GamesPlayed) AS GamesPlayed,\n SUM(p.TotalPoints) AS TotalPoints,\n SUM(p.TotalRebounds) AS TotalRebounds,\n SUM(p.OffensiveRebounds) AS OffensiveRebounds,\n -- Maintenance note: This page uses the same defensive-rebound cutoff pattern as\n -- source record models, but the reason is not documented elsewhere in the repo.\n SUM(CASE WHEN p.Season >= '1985' THEN p.DefensiveRebounds ELSE 0 END) AS DefensiveRebounds,\n SUM(p.Assists) AS Assists,\n SUM(p.Steals) AS Steals,\n SUM(p.Blocks) AS Blocks,\n SUM(p.ThreePointersMade) AS ThreePointersMade,\n SUM(p.FreeThrowsMade) AS FreeThrowsMade,\n SUM(p.Turnovers) AS Turnovers,\n SUM(p.FieldGoalsMade) AS FieldGoalsMade,\n SUM(p.FieldGoalsAttempted) AS FieldGoalsAttempted,\n SUM(p.ThreePointersAttempted) AS ThreePointersAttempted,\n SUM(p.FreeThrowsAttempted) AS FreeThrowsAttempted,\n (SUM(p.GamesPlayed)*5) AS MinFieldGoalsMade,\n (SUM(p.GamesPlayed)*2) AS MinThreePointersAttempted,\n (SUM(p.GamesPlayed)*2) AS MinFreeThrowsAttempted\nFROM SPORTS_INFO_DW_REPORTING.vw_WBB_player_stats_by_game p\nCROSS JOIN ${season_record_selection_context} sc\nWHERE (\n sc.SelectedOpponentCount = 0\n OR p.Opponent IN (\n SELECT Opponent\n FROM ${season_selected_opponents}\n )\n )\n AND (\n '${inputs.season_type_button}' IN ('All', 'All Season')\n OR (\n '${inputs.season_type_button}' = 'POST'\n AND p.SeasonType IN ('ACC', 'NCAA', 'AIAW', 'NWIT', 'WNIT')\n )\n OR p.SeasonType = '${inputs.season_type_button}'\n )\n AND IsClemson= 1\n AND Season > '1975-1976'\nGROUP BY\n PlayerName,\n p.Season,\n CASE\n WHEN '${inputs.season_type_button}' IN ('All', 'All Season') THEN 'All'\n WHEN '${inputs.season_type_button}' = 'POST' THEN 'POST'\n ELSE p.SeasonType\n END,\n sc.SelectedOpponentCount","compiled":true,"inline":true},{"id":"individual_season_total_ranking","compiledQueryString":"-- Ranks season total metrics. Ties share the same RANK, and NULL metric values are excluded.\nWITH season_metrics AS (\n SELECT\n s.PlayerName,\n '/player_profiles/' || replace(replace(s.PlayerName, ' ', '%20'), '''', '%27') AS link,\n s.Season,\n s.Opponent,\n s.GamesPlayed,\n s.SelectedOpponentCount,\n s.MinFieldGoalsMade,\n s.MinThreePointersAttempted,\n s.MinFreeThrowsAttempted,\n s.FieldGoalsMade,\n s.FieldGoalsAttempted,\n s.ThreePointersMade,\n s.ThreePointersAttempted,\n s.FreeThrowsMade,\n s.FreeThrowsAttempted,\n o.metric_type AS MetricType,\n o.metric_value AS MetricValue,\n o.metric_label AS MetricLabel,\n o.table_title AS TableTitle,\n o.column_title AS ColumnTitle,\n CASE o.metric_value\n WHEN 'Total_TotalPoints' THEN s.TotalPoints * 1.0\n WHEN 'Total_TotalRebounds' THEN s.TotalRebounds * 1.0\n WHEN 'Total_OffensiveRebounds' THEN s.OffensiveRebounds * 1.0\n WHEN 'Total_DefensiveRebounds' THEN s.DefensiveRebounds * 1.0\n WHEN 'Total_Assists' THEN s.Assists * 1.0\n WHEN 'Total_Steals' THEN s.Steals * 1.0\n WHEN 'Total_Blocks' THEN s.Blocks * 1.0\n WHEN 'Total_ThreePointersMade' THEN s.ThreePointersMade * 1.0\n WHEN 'Total_FreeThrowsMade' THEN s.FreeThrowsMade * 1.0\n WHEN 'Total_Turnovers' THEN s.Turnovers * 1.0\n WHEN 'Total_FieldGoalsMade' THEN s.FieldGoalsMade * 1.0\n WHEN 'Total_FieldGoalsAttempted' THEN s.FieldGoalsAttempted * 1.0\n WHEN 'Total_ThreePointersAttempted' THEN s.ThreePointersAttempted * 1.0\n WHEN 'Total_FreeThrowsAttempted' THEN s.FreeThrowsAttempted * 1.0\n END AS SeasonRecordValue\n FROM (-- Aggregates Clemson player-games to one player-season after season-type and opponent\n-- filters are applied. Empty selected-opponent sets are treated as all opponents.\nSELECT\n CASE\n WHEN p.PlayerName IN ('Amanda Frist','Amanda White') THEN 'Amanda Frist'\n WHEN p.PlayerName IN ('Julie Larson','Julie L. Brickley') THEN 'Julie Brickley'\n ELSE p.PlayerName END AS PlayerName,\n p.Season,\n CASE\n WHEN '${inputs.season_type_button}' IN ('All', 'All Season') THEN 'All'\n WHEN '${inputs.season_type_button}' = 'POST' THEN 'POST'\n ELSE p.SeasonType\n END AS SeasonType,\n\n CASE\n WHEN sc.SelectedOpponentCount = 0 THEN 'All Opponents'\n WHEN sc.SelectedOpponentCount = 1 THEN ANY_VALUE(p.Opponent)\n ELSE STRING_AGG(DISTINCT p.Opponent, ', ')\n END AS Opponent,\n\n sc.SelectedOpponentCount,\n\n SUM(p.GamesPlayed) AS GamesPlayed,\n SUM(p.TotalPoints) AS TotalPoints,\n SUM(p.TotalRebounds) AS TotalRebounds,\n SUM(p.OffensiveRebounds) AS OffensiveRebounds,\n -- Maintenance note: This page uses the same defensive-rebound cutoff pattern as\n -- source record models, but the reason is not documented elsewhere in the repo.\n SUM(CASE WHEN p.Season >= '1985' THEN p.DefensiveRebounds ELSE 0 END) AS DefensiveRebounds,\n SUM(p.Assists) AS Assists,\n SUM(p.Steals) AS Steals,\n SUM(p.Blocks) AS Blocks,\n SUM(p.ThreePointersMade) AS ThreePointersMade,\n SUM(p.FreeThrowsMade) AS FreeThrowsMade,\n SUM(p.Turnovers) AS Turnovers,\n SUM(p.FieldGoalsMade) AS FieldGoalsMade,\n SUM(p.FieldGoalsAttempted) AS FieldGoalsAttempted,\n SUM(p.ThreePointersAttempted) AS ThreePointersAttempted,\n SUM(p.FreeThrowsAttempted) AS FreeThrowsAttempted,\n (SUM(p.GamesPlayed)*5) AS MinFieldGoalsMade,\n (SUM(p.GamesPlayed)*2) AS MinThreePointersAttempted,\n (SUM(p.GamesPlayed)*2) AS MinFreeThrowsAttempted\nFROM SPORTS_INFO_DW_REPORTING.vw_WBB_player_stats_by_game p\nCROSS JOIN (-- Counts selected season opponents; zero means the season tables should use all opponents.\nWITH selection_count AS (\n SELECT\n COUNT(*) AS SelectedOpponentCount\n FROM (SELECT Opponent\nFROM (-- Shared opponent dropdown. The '__ALL__' row is preserved so filters can detect\n-- \"all opponents\" without building a separate query path.\nSELECT DISTINCT\n Opponent,\n OpponentLabel,\n sort_order\nFROM SPORTS_INFO_DW_REPORTING.opponent_options\nWHERE Opponent = '__ALL__'\n OR '${inputs.season_type_button}' IN ('All', 'All Season')\n OR (\n '${inputs.season_type_button}' = 'POST'\n AND SeasonType IN ('ACC', 'NCAA', 'AIAW', 'NWIT', 'WNIT')\n )\n OR SeasonType = '${inputs.season_type_button}'\nORDER BY sort_order, OpponentLabel)\nWHERE Opponent <> '__ALL__'\n AND '__ALL__' NOT IN ${inputs.opponent_dropdown_season.value}\n AND Opponent IN ${inputs.opponent_dropdown_season.value})\n)\n\nSELECT\n SelectedOpponentCount\nFROM selection_count) sc\nWHERE (\n sc.SelectedOpponentCount = 0\n OR p.Opponent IN (\n SELECT Opponent\n FROM (SELECT Opponent\nFROM (-- Shared opponent dropdown. The '__ALL__' row is preserved so filters can detect\n-- \"all opponents\" without building a separate query path.\nSELECT DISTINCT\n Opponent,\n OpponentLabel,\n sort_order\nFROM SPORTS_INFO_DW_REPORTING.opponent_options\nWHERE Opponent = '__ALL__'\n OR '${inputs.season_type_button}' IN ('All', 'All Season')\n OR (\n '${inputs.season_type_button}' = 'POST'\n AND SeasonType IN ('ACC', 'NCAA', 'AIAW', 'NWIT', 'WNIT')\n )\n OR SeasonType = '${inputs.season_type_button}'\nORDER BY sort_order, OpponentLabel)\nWHERE Opponent <> '__ALL__'\n AND '__ALL__' NOT IN ${inputs.opponent_dropdown_season.value}\n AND Opponent IN ${inputs.opponent_dropdown_season.value})\n )\n )\n AND (\n '${inputs.season_type_button}' IN ('All', 'All Season')\n OR (\n '${inputs.season_type_button}' = 'POST'\n AND p.SeasonType IN ('ACC', 'NCAA', 'AIAW', 'NWIT', 'WNIT')\n )\n OR p.SeasonType = '${inputs.season_type_button}'\n )\n AND IsClemson= 1\n AND Season > '1975-1976'\nGROUP BY\n PlayerName,\n p.Season,\n CASE\n WHEN '${inputs.season_type_button}' IN ('All', 'All Season') THEN 'All'\n WHEN '${inputs.season_type_button}' = 'POST' THEN 'POST'\n ELSE p.SeasonType\n END,\n sc.SelectedOpponentCount) s\n CROSS JOIN (SELECT *\nFROM (-- Defines season-total and season-per-game dropdown metrics. Metric values are grouped\n-- so the page can show separate total and per-game controls from one options table.\nSELECT *\nFROM (\n VALUES\n (1, 'Total', 'Total_TotalPoints', 'Points', 'Season Total Points Records', 'No.'),\n (2, 'Total', 'Total_TotalRebounds', 'Rebounds', 'Season Total Rebounds Records', 'No.'),\n (3, 'Total', 'Total_OffensiveRebounds', 'Offensive Rebounds', 'Season Total Offensive Rebounds Records', 'No.'),\n (4, 'Total', 'Total_DefensiveRebounds', 'Defensive Rebounds', 'Season Total Defensive Rebounds Records', 'No.'),\n (5, 'Total', 'Total_Assists', 'Assists', 'Season Total Assists Records', 'No.'),\n (6, 'Total', 'Total_Steals', 'Steals', 'Season Total Steals Records', 'No.'),\n (7, 'Total', 'Total_Blocks', 'Blocks', 'Season Total Blocks Records', 'No.'),\n (8, 'Total', 'Total_ThreePointersMade', 'Three Pointers Made', 'Season Three Pointers Made Records', 'No.'),\n (9, 'Total', 'Total_FreeThrowsMade', 'Free Throws Made', 'Season Free Throws Made Records', 'No.'),\n (10, 'Total', 'Total_Turnovers', 'Turnovers', 'Season Total Turnovers Records', 'No.'),\n (11, 'Total', 'Total_FieldGoalsMade', 'Field Goals Made', 'Season Field Goals Made Records', 'No.'),\n (12, 'Total', 'Total_FieldGoalsAttempted', 'Field Goals Attempted', 'Season Field Goals Attempted Records', 'No.'),\n (13, 'Total', 'Total_ThreePointersAttempted', 'Three Pointers Attempted', 'Season Three Pointers Attempted Records', 'No.'),\n (14, 'Total', 'Total_FreeThrowsAttempted', 'Free Throws Attempted', 'Season Free Throws Attempted Records', 'No.'),\n\n (15, 'Average', 'Average_TotalPoints', 'Points', 'Season Points Per Game Records', 'No.'),\n (16, 'Average', 'Average_TotalRebounds', 'Rebounds', 'Season Rebounds Per Game Records', 'No.'),\n (17, 'Average', 'Average_OffensiveRebounds', 'Offensive Rebounds', 'Season Offensive Rebounds Per Game Records', 'No.'),\n (18, 'Average', 'Average_DefensiveRebounds', 'Defensive Rebounds', 'Season Defensive Rebounds Per Game Records', 'No.'),\n (19, 'Average', 'Average_Assists', 'Assists', 'Season Assists Per Game Records', 'No.'),\n (20, 'Average', 'Average_Steals', 'Steals', 'Season Steals Per Game Records', 'No.'),\n (21, 'Average', 'Average_Blocks', 'Blocks', 'Season Blocks Per Game Records', 'No.'),\n (22, 'Average', 'Average_ThreePointersMade', 'Three Pointers Made', 'Season Three Pointers Made Per Game Records', 'No.'),\n (23, 'Average', 'Average_FreeThrowsMade', 'Free Throws Made', 'Season Free Throws Made Per Game Records', 'No.'),\n (24, 'Average', 'Average_Turnovers', 'Turnovers Per Game', 'Season Turnovers Per Game Records', 'No.'),\n (25, 'Average', 'Average_FieldGoalsMade', 'Field Goals Made', 'Season Field Goals Made Per Game Records', 'No.'),\n (26, 'Average', 'Average_FieldGoalsAttempted', 'Field Goals Attempted', 'Season Field Goals Attempted Per Game Records', 'No.'),\n (27, 'Average', 'Average_ThreePointersAttempted','Three Pointers Attempted', 'Season Three Pointers Attempted Per Game Records','No.'),\n (28, 'Average', 'Average_FreeThrowsAttempted', 'Free Throws Attempted', 'Season Free Throws Attempted Per Game Records', 'No.'),\n (29, 'Average', 'Average_FieldGoalPercentage', 'Field Goal Percentage', 'Season Field Goal Percentage Records', 'No.'),\n (30, 'Average', 'Average_ThreePointerPercentage','Three Pointer Percentage', 'Season Three Point Percentage Records', 'No.'),\n (31, 'Average', 'Average_FreeThrowPercentage', 'Free Throw Percentage', 'Season Free Throw Percentage Records', 'No.')\n) AS t(metric_order, metric_type, metric_value, metric_label, table_title, column_title))\nWHERE metric_value = '${inputs.season_total_record_metric.value}') o\n),\n\nranked AS (\n SELECT\n *,\n CAST(\n RANK() OVER (\n ORDER BY SeasonRecordValue DESC NULLS LAST\n ) AS INT\n ) AS SeasonRanking\n FROM season_metrics\n WHERE MetricType = 'Total'\n AND MetricValue = '${inputs.season_total_record_metric.value}'\n)\n\nSELECT *\nFROM ranked\nORDER BY SeasonRanking","inputQueryString":"-- Ranks season total metrics. Ties share the same RANK, and NULL metric values are excluded.\nWITH season_metrics AS (\n SELECT\n s.PlayerName,\n '/player_profiles/' || replace(replace(s.PlayerName, ' ', '%20'), '''', '%27') AS link,\n s.Season,\n s.Opponent,\n s.GamesPlayed,\n s.SelectedOpponentCount,\n s.MinFieldGoalsMade,\n s.MinThreePointersAttempted,\n s.MinFreeThrowsAttempted,\n s.FieldGoalsMade,\n s.FieldGoalsAttempted,\n s.ThreePointersMade,\n s.ThreePointersAttempted,\n s.FreeThrowsMade,\n s.FreeThrowsAttempted,\n o.metric_type AS MetricType,\n o.metric_value AS MetricValue,\n o.metric_label AS MetricLabel,\n o.table_title AS TableTitle,\n o.column_title AS ColumnTitle,\n CASE o.metric_value\n WHEN 'Total_TotalPoints' THEN s.TotalPoints * 1.0\n WHEN 'Total_TotalRebounds' THEN s.TotalRebounds * 1.0\n WHEN 'Total_OffensiveRebounds' THEN s.OffensiveRebounds * 1.0\n WHEN 'Total_DefensiveRebounds' THEN s.DefensiveRebounds * 1.0\n WHEN 'Total_Assists' THEN s.Assists * 1.0\n WHEN 'Total_Steals' THEN s.Steals * 1.0\n WHEN 'Total_Blocks' THEN s.Blocks * 1.0\n WHEN 'Total_ThreePointersMade' THEN s.ThreePointersMade * 1.0\n WHEN 'Total_FreeThrowsMade' THEN s.FreeThrowsMade * 1.0\n WHEN 'Total_Turnovers' THEN s.Turnovers * 1.0\n WHEN 'Total_FieldGoalsMade' THEN s.FieldGoalsMade * 1.0\n WHEN 'Total_FieldGoalsAttempted' THEN s.FieldGoalsAttempted * 1.0\n WHEN 'Total_ThreePointersAttempted' THEN s.ThreePointersAttempted * 1.0\n WHEN 'Total_FreeThrowsAttempted' THEN s.FreeThrowsAttempted * 1.0\n END AS SeasonRecordValue\n FROM ${player_season_base} s\n CROSS JOIN ${selected_season_total_record_metric} o\n),\n\nranked AS (\n SELECT\n *,\n CAST(\n RANK() OVER (\n ORDER BY SeasonRecordValue DESC NULLS LAST\n ) AS INT\n ) AS SeasonRanking\n FROM season_metrics\n WHERE MetricType = 'Total'\n AND MetricValue = '${inputs.season_total_record_metric.value}'\n)\n\nSELECT *\nFROM ranked\nORDER BY SeasonRanking","compiled":true,"inline":true},{"id":"individual_season_per_game_ranking","compiledQueryString":"-- Ranks season average/percentage metrics. Games played and attempt thresholds are\n-- encoded here; verify the intended eligibility rule before changing those cutoffs.\nWITH season_metrics AS (\n SELECT\n s.PlayerName,\n '/player_profiles/' || replace(replace(s.PlayerName, ' ', '%20'), '''', '%27') AS link,\n s.Season,\n s.Opponent,\n s.SeasonType,\n s.GamesPlayed,\n s.SelectedOpponentCount,\n s.MinFieldGoalsMade,\n s.MinThreePointersAttempted,\n s.MinFreeThrowsAttempted,\n s.FieldGoalsMade,\n s.FieldGoalsAttempted,\n s.ThreePointersMade,\n s.ThreePointersAttempted,\n s.FreeThrowsMade,\n s.FreeThrowsAttempted,\n o.metric_type AS MetricType,\n o.metric_value AS MetricValue,\n o.metric_label AS MetricLabel,\n o.table_title AS TableTitle,\n o.column_title AS ColumnTitle,\n CASE o.metric_value\n WHEN 'Average_TotalPoints' THEN s.TotalPoints * 1.0 / NULLIF(s.GamesPlayed, 0)\n WHEN 'Average_TotalRebounds' THEN s.TotalRebounds * 1.0 / NULLIF(s.GamesPlayed, 0)\n WHEN 'Average_OffensiveRebounds' THEN s.OffensiveRebounds * 1.0 / NULLIF(s.GamesPlayed, 0)\n WHEN 'Average_DefensiveRebounds' THEN s.DefensiveRebounds * 1.0 / NULLIF(s.GamesPlayed, 0)\n WHEN 'Average_Assists' THEN s.Assists * 1.0 / NULLIF(s.GamesPlayed, 0)\n WHEN 'Average_Steals' THEN s.Steals * 1.0 / NULLIF(s.GamesPlayed, 0)\n WHEN 'Average_Blocks' THEN s.Blocks * 1.0 / NULLIF(s.GamesPlayed, 0)\n WHEN 'Average_ThreePointersMade' THEN s.ThreePointersMade * 1.0 / NULLIF(s.GamesPlayed, 0)\n WHEN 'Average_FreeThrowsMade' THEN s.FreeThrowsMade * 1.0 / NULLIF(s.GamesPlayed, 0)\n WHEN 'Average_Turnovers' THEN s.Turnovers * 1.0 / NULLIF(s.GamesPlayed, 0)\n WHEN 'Average_FieldGoalsMade' THEN s.FieldGoalsMade * 1.0 / NULLIF(s.GamesPlayed, 0)\n WHEN 'Average_FieldGoalsAttempted' THEN s.FieldGoalsAttempted * 1.0 / NULLIF(s.GamesPlayed, 0)\n WHEN 'Average_ThreePointersAttempted' THEN s.ThreePointersAttempted * 1.0 / NULLIF(s.GamesPlayed, 0)\n WHEN 'Average_FreeThrowsAttempted' THEN s.FreeThrowsAttempted * 1.0 / NULLIF(s.GamesPlayed, 0)\n WHEN 'Average_FieldGoalPercentage' THEN s.FieldGoalsMade * 1.0 / NULLIF(s.FieldGoalsAttempted, 0)\n WHEN 'Average_ThreePointerPercentage' THEN s.ThreePointersMade * 1.0 / NULLIF(s.ThreePointersAttempted, 0)\n WHEN 'Average_FreeThrowPercentage' THEN s.FreeThrowsMade * 1.0 / NULLIF(s.FreeThrowsAttempted, 0)\n END AS SeasonRecordValue\n FROM (-- Aggregates Clemson player-games to one player-season after season-type and opponent\n-- filters are applied. Empty selected-opponent sets are treated as all opponents.\nSELECT\n CASE\n WHEN p.PlayerName IN ('Amanda Frist','Amanda White') THEN 'Amanda Frist'\n WHEN p.PlayerName IN ('Julie Larson','Julie L. Brickley') THEN 'Julie Brickley'\n ELSE p.PlayerName END AS PlayerName,\n p.Season,\n CASE\n WHEN '${inputs.season_type_button}' IN ('All', 'All Season') THEN 'All'\n WHEN '${inputs.season_type_button}' = 'POST' THEN 'POST'\n ELSE p.SeasonType\n END AS SeasonType,\n\n CASE\n WHEN sc.SelectedOpponentCount = 0 THEN 'All Opponents'\n WHEN sc.SelectedOpponentCount = 1 THEN ANY_VALUE(p.Opponent)\n ELSE STRING_AGG(DISTINCT p.Opponent, ', ')\n END AS Opponent,\n\n sc.SelectedOpponentCount,\n\n SUM(p.GamesPlayed) AS GamesPlayed,\n SUM(p.TotalPoints) AS TotalPoints,\n SUM(p.TotalRebounds) AS TotalRebounds,\n SUM(p.OffensiveRebounds) AS OffensiveRebounds,\n -- Maintenance note: This page uses the same defensive-rebound cutoff pattern as\n -- source record models, but the reason is not documented elsewhere in the repo.\n SUM(CASE WHEN p.Season >= '1985' THEN p.DefensiveRebounds ELSE 0 END) AS DefensiveRebounds,\n SUM(p.Assists) AS Assists,\n SUM(p.Steals) AS Steals,\n SUM(p.Blocks) AS Blocks,\n SUM(p.ThreePointersMade) AS ThreePointersMade,\n SUM(p.FreeThrowsMade) AS FreeThrowsMade,\n SUM(p.Turnovers) AS Turnovers,\n SUM(p.FieldGoalsMade) AS FieldGoalsMade,\n SUM(p.FieldGoalsAttempted) AS FieldGoalsAttempted,\n SUM(p.ThreePointersAttempted) AS ThreePointersAttempted,\n SUM(p.FreeThrowsAttempted) AS FreeThrowsAttempted,\n (SUM(p.GamesPlayed)*5) AS MinFieldGoalsMade,\n (SUM(p.GamesPlayed)*2) AS MinThreePointersAttempted,\n (SUM(p.GamesPlayed)*2) AS MinFreeThrowsAttempted\nFROM SPORTS_INFO_DW_REPORTING.vw_WBB_player_stats_by_game p\nCROSS JOIN (-- Counts selected season opponents; zero means the season tables should use all opponents.\nWITH selection_count AS (\n SELECT\n COUNT(*) AS SelectedOpponentCount\n FROM (SELECT Opponent\nFROM (-- Shared opponent dropdown. The '__ALL__' row is preserved so filters can detect\n-- \"all opponents\" without building a separate query path.\nSELECT DISTINCT\n Opponent,\n OpponentLabel,\n sort_order\nFROM SPORTS_INFO_DW_REPORTING.opponent_options\nWHERE Opponent = '__ALL__'\n OR '${inputs.season_type_button}' IN ('All', 'All Season')\n OR (\n '${inputs.season_type_button}' = 'POST'\n AND SeasonType IN ('ACC', 'NCAA', 'AIAW', 'NWIT', 'WNIT')\n )\n OR SeasonType = '${inputs.season_type_button}'\nORDER BY sort_order, OpponentLabel)\nWHERE Opponent <> '__ALL__'\n AND '__ALL__' NOT IN ${inputs.opponent_dropdown_season.value}\n AND Opponent IN ${inputs.opponent_dropdown_season.value})\n)\n\nSELECT\n SelectedOpponentCount\nFROM selection_count) sc\nWHERE (\n sc.SelectedOpponentCount = 0\n OR p.Opponent IN (\n SELECT Opponent\n FROM (SELECT Opponent\nFROM (-- Shared opponent dropdown. The '__ALL__' row is preserved so filters can detect\n-- \"all opponents\" without building a separate query path.\nSELECT DISTINCT\n Opponent,\n OpponentLabel,\n sort_order\nFROM SPORTS_INFO_DW_REPORTING.opponent_options\nWHERE Opponent = '__ALL__'\n OR '${inputs.season_type_button}' IN ('All', 'All Season')\n OR (\n '${inputs.season_type_button}' = 'POST'\n AND SeasonType IN ('ACC', 'NCAA', 'AIAW', 'NWIT', 'WNIT')\n )\n OR SeasonType = '${inputs.season_type_button}'\nORDER BY sort_order, OpponentLabel)\nWHERE Opponent <> '__ALL__'\n AND '__ALL__' NOT IN ${inputs.opponent_dropdown_season.value}\n AND Opponent IN ${inputs.opponent_dropdown_season.value})\n )\n )\n AND (\n '${inputs.season_type_button}' IN ('All', 'All Season')\n OR (\n '${inputs.season_type_button}' = 'POST'\n AND p.SeasonType IN ('ACC', 'NCAA', 'AIAW', 'NWIT', 'WNIT')\n )\n OR p.SeasonType = '${inputs.season_type_button}'\n )\n AND IsClemson= 1\n AND Season > '1975-1976'\nGROUP BY\n PlayerName,\n p.Season,\n CASE\n WHEN '${inputs.season_type_button}' IN ('All', 'All Season') THEN 'All'\n WHEN '${inputs.season_type_button}' = 'POST' THEN 'POST'\n ELSE p.SeasonType\n END,\n sc.SelectedOpponentCount) s\n CROSS JOIN (SELECT *\nFROM (-- Defines season-total and season-per-game dropdown metrics. Metric values are grouped\n-- so the page can show separate total and per-game controls from one options table.\nSELECT *\nFROM (\n VALUES\n (1, 'Total', 'Total_TotalPoints', 'Points', 'Season Total Points Records', 'No.'),\n (2, 'Total', 'Total_TotalRebounds', 'Rebounds', 'Season Total Rebounds Records', 'No.'),\n (3, 'Total', 'Total_OffensiveRebounds', 'Offensive Rebounds', 'Season Total Offensive Rebounds Records', 'No.'),\n (4, 'Total', 'Total_DefensiveRebounds', 'Defensive Rebounds', 'Season Total Defensive Rebounds Records', 'No.'),\n (5, 'Total', 'Total_Assists', 'Assists', 'Season Total Assists Records', 'No.'),\n (6, 'Total', 'Total_Steals', 'Steals', 'Season Total Steals Records', 'No.'),\n (7, 'Total', 'Total_Blocks', 'Blocks', 'Season Total Blocks Records', 'No.'),\n (8, 'Total', 'Total_ThreePointersMade', 'Three Pointers Made', 'Season Three Pointers Made Records', 'No.'),\n (9, 'Total', 'Total_FreeThrowsMade', 'Free Throws Made', 'Season Free Throws Made Records', 'No.'),\n (10, 'Total', 'Total_Turnovers', 'Turnovers', 'Season Total Turnovers Records', 'No.'),\n (11, 'Total', 'Total_FieldGoalsMade', 'Field Goals Made', 'Season Field Goals Made Records', 'No.'),\n (12, 'Total', 'Total_FieldGoalsAttempted', 'Field Goals Attempted', 'Season Field Goals Attempted Records', 'No.'),\n (13, 'Total', 'Total_ThreePointersAttempted', 'Three Pointers Attempted', 'Season Three Pointers Attempted Records', 'No.'),\n (14, 'Total', 'Total_FreeThrowsAttempted', 'Free Throws Attempted', 'Season Free Throws Attempted Records', 'No.'),\n\n (15, 'Average', 'Average_TotalPoints', 'Points', 'Season Points Per Game Records', 'No.'),\n (16, 'Average', 'Average_TotalRebounds', 'Rebounds', 'Season Rebounds Per Game Records', 'No.'),\n (17, 'Average', 'Average_OffensiveRebounds', 'Offensive Rebounds', 'Season Offensive Rebounds Per Game Records', 'No.'),\n (18, 'Average', 'Average_DefensiveRebounds', 'Defensive Rebounds', 'Season Defensive Rebounds Per Game Records', 'No.'),\n (19, 'Average', 'Average_Assists', 'Assists', 'Season Assists Per Game Records', 'No.'),\n (20, 'Average', 'Average_Steals', 'Steals', 'Season Steals Per Game Records', 'No.'),\n (21, 'Average', 'Average_Blocks', 'Blocks', 'Season Blocks Per Game Records', 'No.'),\n (22, 'Average', 'Average_ThreePointersMade', 'Three Pointers Made', 'Season Three Pointers Made Per Game Records', 'No.'),\n (23, 'Average', 'Average_FreeThrowsMade', 'Free Throws Made', 'Season Free Throws Made Per Game Records', 'No.'),\n (24, 'Average', 'Average_Turnovers', 'Turnovers Per Game', 'Season Turnovers Per Game Records', 'No.'),\n (25, 'Average', 'Average_FieldGoalsMade', 'Field Goals Made', 'Season Field Goals Made Per Game Records', 'No.'),\n (26, 'Average', 'Average_FieldGoalsAttempted', 'Field Goals Attempted', 'Season Field Goals Attempted Per Game Records', 'No.'),\n (27, 'Average', 'Average_ThreePointersAttempted','Three Pointers Attempted', 'Season Three Pointers Attempted Per Game Records','No.'),\n (28, 'Average', 'Average_FreeThrowsAttempted', 'Free Throws Attempted', 'Season Free Throws Attempted Per Game Records', 'No.'),\n (29, 'Average', 'Average_FieldGoalPercentage', 'Field Goal Percentage', 'Season Field Goal Percentage Records', 'No.'),\n (30, 'Average', 'Average_ThreePointerPercentage','Three Pointer Percentage', 'Season Three Point Percentage Records', 'No.'),\n (31, 'Average', 'Average_FreeThrowPercentage', 'Free Throw Percentage', 'Season Free Throw Percentage Records', 'No.')\n) AS t(metric_order, metric_type, metric_value, metric_label, table_title, column_title))\nWHERE metric_value = '${inputs.season_per_game_record_metric.value}') o\n WHERE s.GamesPlayed > 3\n AND (\n o.metric_value != 'Average_FieldGoalPercentage'\n OR s.FieldGoalsMade >= s.MinFieldGoalsMade\n )\n AND (\n o.metric_value != 'Average_ThreePointerPercentage'\n OR s.ThreePointersAttempted >= s.MinThreePointersAttempted\n )\n AND (\n o.metric_value != 'Average_FreeThrowPercentage'\n OR s.FreeThrowsAttempted >= s.MinFreeThrowsAttempted\n )\n),\n\nranked AS (\n SELECT\n *,\n CAST(\n RANK() OVER (\n ORDER BY SeasonRecordValue DESC NULLS LAST\n ) AS INT\n ) AS SeasonRanking\n FROM season_metrics\n WHERE MetricType = 'Average'\n AND MetricValue = '${inputs.season_per_game_record_metric.value}'\n)\n\nSELECT *\nFROM ranked\nORDER BY SeasonRanking","inputQueryString":"-- Ranks season average/percentage metrics. Games played and attempt thresholds are\n-- encoded here; verify the intended eligibility rule before changing those cutoffs.\nWITH season_metrics AS (\n SELECT\n s.PlayerName,\n '/player_profiles/' || replace(replace(s.PlayerName, ' ', '%20'), '''', '%27') AS link,\n s.Season,\n s.Opponent,\n s.SeasonType,\n s.GamesPlayed,\n s.SelectedOpponentCount,\n s.MinFieldGoalsMade,\n s.MinThreePointersAttempted,\n s.MinFreeThrowsAttempted,\n s.FieldGoalsMade,\n s.FieldGoalsAttempted,\n s.ThreePointersMade,\n s.ThreePointersAttempted,\n s.FreeThrowsMade,\n s.FreeThrowsAttempted,\n o.metric_type AS MetricType,\n o.metric_value AS MetricValue,\n o.metric_label AS MetricLabel,\n o.table_title AS TableTitle,\n o.column_title AS ColumnTitle,\n CASE o.metric_value\n WHEN 'Average_TotalPoints' THEN s.TotalPoints * 1.0 / NULLIF(s.GamesPlayed, 0)\n WHEN 'Average_TotalRebounds' THEN s.TotalRebounds * 1.0 / NULLIF(s.GamesPlayed, 0)\n WHEN 'Average_OffensiveRebounds' THEN s.OffensiveRebounds * 1.0 / NULLIF(s.GamesPlayed, 0)\n WHEN 'Average_DefensiveRebounds' THEN s.DefensiveRebounds * 1.0 / NULLIF(s.GamesPlayed, 0)\n WHEN 'Average_Assists' THEN s.Assists * 1.0 / NULLIF(s.GamesPlayed, 0)\n WHEN 'Average_Steals' THEN s.Steals * 1.0 / NULLIF(s.GamesPlayed, 0)\n WHEN 'Average_Blocks' THEN s.Blocks * 1.0 / NULLIF(s.GamesPlayed, 0)\n WHEN 'Average_ThreePointersMade' THEN s.ThreePointersMade * 1.0 / NULLIF(s.GamesPlayed, 0)\n WHEN 'Average_FreeThrowsMade' THEN s.FreeThrowsMade * 1.0 / NULLIF(s.GamesPlayed, 0)\n WHEN 'Average_Turnovers' THEN s.Turnovers * 1.0 / NULLIF(s.GamesPlayed, 0)\n WHEN 'Average_FieldGoalsMade' THEN s.FieldGoalsMade * 1.0 / NULLIF(s.GamesPlayed, 0)\n WHEN 'Average_FieldGoalsAttempted' THEN s.FieldGoalsAttempted * 1.0 / NULLIF(s.GamesPlayed, 0)\n WHEN 'Average_ThreePointersAttempted' THEN s.ThreePointersAttempted * 1.0 / NULLIF(s.GamesPlayed, 0)\n WHEN 'Average_FreeThrowsAttempted' THEN s.FreeThrowsAttempted * 1.0 / NULLIF(s.GamesPlayed, 0)\n WHEN 'Average_FieldGoalPercentage' THEN s.FieldGoalsMade * 1.0 / NULLIF(s.FieldGoalsAttempted, 0)\n WHEN 'Average_ThreePointerPercentage' THEN s.ThreePointersMade * 1.0 / NULLIF(s.ThreePointersAttempted, 0)\n WHEN 'Average_FreeThrowPercentage' THEN s.FreeThrowsMade * 1.0 / NULLIF(s.FreeThrowsAttempted, 0)\n END AS SeasonRecordValue\n FROM ${player_season_base} s\n CROSS JOIN ${selected_season_per_game_record_metric} o\n WHERE s.GamesPlayed > 3\n AND (\n o.metric_value != 'Average_FieldGoalPercentage'\n OR s.FieldGoalsMade >= s.MinFieldGoalsMade\n )\n AND (\n o.metric_value != 'Average_ThreePointerPercentage'\n OR s.ThreePointersAttempted >= s.MinThreePointersAttempted\n )\n AND (\n o.metric_value != 'Average_FreeThrowPercentage'\n OR s.FreeThrowsAttempted >= s.MinFreeThrowsAttempted\n )\n),\n\nranked AS (\n SELECT\n *,\n CAST(\n RANK() OVER (\n ORDER BY SeasonRecordValue DESC NULLS LAST\n ) AS INT\n ) AS SeasonRanking\n FROM season_metrics\n WHERE MetricType = 'Average'\n AND MetricValue = '${inputs.season_per_game_record_metric.value}'\n)\n\nSELECT *\nFROM ranked\nORDER BY SeasonRanking","compiled":true,"inline":true},{"id":"career_record_metric_options","compiledQueryString":"-- Defines career total, percentage, and per-game dropdown metrics for the career section.\nSELECT *\nFROM (\n VALUES\n (1, 'Total', 'Total', 'Total_GamesPlayed', 'GP', 'Top 100 Career Games Played', 'No.'),\n (2, 'Total', 'Total', 'Total_GamesStarted', 'GS', 'Top 100 Career Games Started', 'No.'),\n (3, 'Total', 'Total', 'Total_TotalPoints', 'Points', 'Top 100 Career Total Points', 'No.'),\n (4, 'Total', 'Total', 'Total_TotalRebounds', 'Rebounds', 'Top 100 Career Total Rebounds', 'No.'),\n (5, 'Total', 'Total', 'Total_OffensiveRebounds', 'Offensive Rebounds', 'Top 100 Career Total Offensive Rebounds', 'No.'),\n (6, 'Total', 'Total', 'Total_DefensiveRebounds', 'Defensive Rebounds', 'Top 100 Career Total Defensive Rebounds', 'No.'),\n (7, 'Total', 'Total', 'Total_Assists', 'Assists', 'Top 100 Career Total Assists', 'No.'),\n (8, 'Total', 'Total', 'Total_Steals', 'Steals', 'Top 100 Career Total Steals', 'No.'),\n (9, 'Total', 'Total', 'Total_Blocks', 'Blocks', 'Top 100 Career Total Blocks', 'No.'),\n (10, 'Total', 'Total', 'Total_ThreePointersMade', 'Three Pointers Made', 'Top 100 Career Total Three Pointers Made', 'No.'),\n (11, 'Total', 'Total', 'Total_FreeThrowsMade', 'Free Throws Made', 'Top 100 Career Total Free Throws Made', 'No.'),\n (12, 'Total', 'Total', 'Total_Turnovers', 'TO', 'Top 100 Career Total Turnovers', 'No.'),\n (13, 'Total', 'Total', 'Total_FieldGoalsMade', 'Field Goals Made', 'Top 100 Career Total Field Goals Made', 'No.'),\n (14, 'Total', 'Total', 'Total_FieldGoalsAttempted', 'Field Goals Attempted', 'Top 100 Career Total Field Goals Attempted', 'No.'),\n (15, 'Total', 'Total', 'Total_ThreePointersAttempted', 'Three Pointers Attempted', 'Top 100 Career Total Three Pointers Attempted', 'No.'),\n (16, 'Total', 'Total', 'Total_FreeThrowsAttempted', 'Free Throws Attempted', 'Top 100 Career Total Free Throws Attempted', 'No.'),\n\n (17, 'PerGame', 'PerGame', 'Average_TotalPoints', 'Points', 'Top 100 Career Points Per Game', 'No.'),\n (18, 'PerGame', 'PerGame', 'Average_TotalRebounds', 'Rebounds', 'Top 100 Career Rebounds Per Game', 'No.'),\n (19, 'PerGame', 'PerGame', 'Average_OffensiveRebounds', 'Offensive Rebounds', 'Top 100 Career Offensive Rebounds Per Game', 'No.'),\n (20, 'PerGame', 'PerGame', 'Average_DefensiveRebounds', 'Defensive Rebounds', 'Top 100 Career Defensive Rebounds Per Game', 'No.'),\n (21, 'PerGame', 'PerGame', 'Average_Assists', 'Assists', 'Top 100 Career Assists Per Game', 'No.'),\n (22, 'PerGame', 'PerGame', 'Average_Steals', 'Steals', 'Top 100 Career Steals Per Game', 'No.'),\n (23, 'PerGame', 'PerGame', 'Average_Blocks', 'Blocks', 'Top 100 Career Blocks Per Game', 'No.'),\n (24, 'PerGame', 'PerGame', 'Average_ThreePointersMade', 'Three Pointers Made', 'Top 100 Career Three Pointers Made Per Game', 'No.'),\n (25, 'PerGame', 'PerGame', 'Average_FreeThrowsMade', 'Free Throws Made', 'Top 100 Career Free Throws Made Per Game', 'No.'),\n (26, 'PerGame', 'PerGame', 'Average_Turnovers', 'TO', 'Top 100 Career Turnovers Per Game', 'No.'),\n (27, 'PerGame', 'PerGame', 'Average_FieldGoalsMade', 'Field Goals Made', 'Top 100 Career Field Goals Made Per Game', 'No.'),\n (28, 'PerGame', 'PerGame', 'Average_FieldGoalsAttempted', 'Field Goals Attempted', 'Top 100 Career Field Goals Attempted Per Game', 'No.'),\n (29, 'PerGame', 'PerGame', 'Average_ThreePointersAttempted', 'Three Pointers Attempted', 'Top 100 Career Three Pointers Attempted Per Game', 'No.'),\n (30, 'PerGame', 'PerGame', 'Average_FreeThrowsAttempted', 'Free Throws Attempted', 'Top 100 Career Free Throws Attempted Per Game', 'No.'),\n (31, 'PerGame', 'PerGame', 'Average_FieldGoalPercentage', 'Field Goal Percentage', 'Top 100 Career Field Goal Percentage', 'No.'),\n (32, 'PerGame', 'PerGame', 'Average_ThreePointerPercentage', 'Three Pointer Percentage', 'Top 100 Career Three Point Percentage', 'No.'),\n (33, 'PerGame', 'PerGame', 'Average_FreeThrowPercentage', 'Free Throw Percentage', 'Top 100 Career Free Throw Percentage', 'No.')\n) AS t(metric_order, metric_type, metric_display_group, metric_value, metric_label, table_title, column_title)","inputQueryString":"-- Defines career total, percentage, and per-game dropdown metrics for the career section.\nSELECT *\nFROM (\n VALUES\n (1, 'Total', 'Total', 'Total_GamesPlayed', 'GP', 'Top 100 Career Games Played', 'No.'),\n (2, 'Total', 'Total', 'Total_GamesStarted', 'GS', 'Top 100 Career Games Started', 'No.'),\n (3, 'Total', 'Total', 'Total_TotalPoints', 'Points', 'Top 100 Career Total Points', 'No.'),\n (4, 'Total', 'Total', 'Total_TotalRebounds', 'Rebounds', 'Top 100 Career Total Rebounds', 'No.'),\n (5, 'Total', 'Total', 'Total_OffensiveRebounds', 'Offensive Rebounds', 'Top 100 Career Total Offensive Rebounds', 'No.'),\n (6, 'Total', 'Total', 'Total_DefensiveRebounds', 'Defensive Rebounds', 'Top 100 Career Total Defensive Rebounds', 'No.'),\n (7, 'Total', 'Total', 'Total_Assists', 'Assists', 'Top 100 Career Total Assists', 'No.'),\n (8, 'Total', 'Total', 'Total_Steals', 'Steals', 'Top 100 Career Total Steals', 'No.'),\n (9, 'Total', 'Total', 'Total_Blocks', 'Blocks', 'Top 100 Career Total Blocks', 'No.'),\n (10, 'Total', 'Total', 'Total_ThreePointersMade', 'Three Pointers Made', 'Top 100 Career Total Three Pointers Made', 'No.'),\n (11, 'Total', 'Total', 'Total_FreeThrowsMade', 'Free Throws Made', 'Top 100 Career Total Free Throws Made', 'No.'),\n (12, 'Total', 'Total', 'Total_Turnovers', 'TO', 'Top 100 Career Total Turnovers', 'No.'),\n (13, 'Total', 'Total', 'Total_FieldGoalsMade', 'Field Goals Made', 'Top 100 Career Total Field Goals Made', 'No.'),\n (14, 'Total', 'Total', 'Total_FieldGoalsAttempted', 'Field Goals Attempted', 'Top 100 Career Total Field Goals Attempted', 'No.'),\n (15, 'Total', 'Total', 'Total_ThreePointersAttempted', 'Three Pointers Attempted', 'Top 100 Career Total Three Pointers Attempted', 'No.'),\n (16, 'Total', 'Total', 'Total_FreeThrowsAttempted', 'Free Throws Attempted', 'Top 100 Career Total Free Throws Attempted', 'No.'),\n\n (17, 'PerGame', 'PerGame', 'Average_TotalPoints', 'Points', 'Top 100 Career Points Per Game', 'No.'),\n (18, 'PerGame', 'PerGame', 'Average_TotalRebounds', 'Rebounds', 'Top 100 Career Rebounds Per Game', 'No.'),\n (19, 'PerGame', 'PerGame', 'Average_OffensiveRebounds', 'Offensive Rebounds', 'Top 100 Career Offensive Rebounds Per Game', 'No.'),\n (20, 'PerGame', 'PerGame', 'Average_DefensiveRebounds', 'Defensive Rebounds', 'Top 100 Career Defensive Rebounds Per Game', 'No.'),\n (21, 'PerGame', 'PerGame', 'Average_Assists', 'Assists', 'Top 100 Career Assists Per Game', 'No.'),\n (22, 'PerGame', 'PerGame', 'Average_Steals', 'Steals', 'Top 100 Career Steals Per Game', 'No.'),\n (23, 'PerGame', 'PerGame', 'Average_Blocks', 'Blocks', 'Top 100 Career Blocks Per Game', 'No.'),\n (24, 'PerGame', 'PerGame', 'Average_ThreePointersMade', 'Three Pointers Made', 'Top 100 Career Three Pointers Made Per Game', 'No.'),\n (25, 'PerGame', 'PerGame', 'Average_FreeThrowsMade', 'Free Throws Made', 'Top 100 Career Free Throws Made Per Game', 'No.'),\n (26, 'PerGame', 'PerGame', 'Average_Turnovers', 'TO', 'Top 100 Career Turnovers Per Game', 'No.'),\n (27, 'PerGame', 'PerGame', 'Average_FieldGoalsMade', 'Field Goals Made', 'Top 100 Career Field Goals Made Per Game', 'No.'),\n (28, 'PerGame', 'PerGame', 'Average_FieldGoalsAttempted', 'Field Goals Attempted', 'Top 100 Career Field Goals Attempted Per Game', 'No.'),\n (29, 'PerGame', 'PerGame', 'Average_ThreePointersAttempted', 'Three Pointers Attempted', 'Top 100 Career Three Pointers Attempted Per Game', 'No.'),\n (30, 'PerGame', 'PerGame', 'Average_FreeThrowsAttempted', 'Free Throws Attempted', 'Top 100 Career Free Throws Attempted Per Game', 'No.'),\n (31, 'PerGame', 'PerGame', 'Average_FieldGoalPercentage', 'Field Goal Percentage', 'Top 100 Career Field Goal Percentage', 'No.'),\n (32, 'PerGame', 'PerGame', 'Average_ThreePointerPercentage', 'Three Pointer Percentage', 'Top 100 Career Three Point Percentage', 'No.'),\n (33, 'PerGame', 'PerGame', 'Average_FreeThrowPercentage', 'Free Throw Percentage', 'Top 100 Career Free Throw Percentage', 'No.')\n) AS t(metric_order, metric_type, metric_display_group, metric_value, metric_label, table_title, column_title)","compiled":false,"inline":true},{"id":"career_metric_totals_options","compiledQueryString":"SELECT *\nFROM (-- Defines career total, percentage, and per-game dropdown metrics for the career section.\nSELECT *\nFROM (\n VALUES\n (1, 'Total', 'Total', 'Total_GamesPlayed', 'GP', 'Top 100 Career Games Played', 'No.'),\n (2, 'Total', 'Total', 'Total_GamesStarted', 'GS', 'Top 100 Career Games Started', 'No.'),\n (3, 'Total', 'Total', 'Total_TotalPoints', 'Points', 'Top 100 Career Total Points', 'No.'),\n (4, 'Total', 'Total', 'Total_TotalRebounds', 'Rebounds', 'Top 100 Career Total Rebounds', 'No.'),\n (5, 'Total', 'Total', 'Total_OffensiveRebounds', 'Offensive Rebounds', 'Top 100 Career Total Offensive Rebounds', 'No.'),\n (6, 'Total', 'Total', 'Total_DefensiveRebounds', 'Defensive Rebounds', 'Top 100 Career Total Defensive Rebounds', 'No.'),\n (7, 'Total', 'Total', 'Total_Assists', 'Assists', 'Top 100 Career Total Assists', 'No.'),\n (8, 'Total', 'Total', 'Total_Steals', 'Steals', 'Top 100 Career Total Steals', 'No.'),\n (9, 'Total', 'Total', 'Total_Blocks', 'Blocks', 'Top 100 Career Total Blocks', 'No.'),\n (10, 'Total', 'Total', 'Total_ThreePointersMade', 'Three Pointers Made', 'Top 100 Career Total Three Pointers Made', 'No.'),\n (11, 'Total', 'Total', 'Total_FreeThrowsMade', 'Free Throws Made', 'Top 100 Career Total Free Throws Made', 'No.'),\n (12, 'Total', 'Total', 'Total_Turnovers', 'TO', 'Top 100 Career Total Turnovers', 'No.'),\n (13, 'Total', 'Total', 'Total_FieldGoalsMade', 'Field Goals Made', 'Top 100 Career Total Field Goals Made', 'No.'),\n (14, 'Total', 'Total', 'Total_FieldGoalsAttempted', 'Field Goals Attempted', 'Top 100 Career Total Field Goals Attempted', 'No.'),\n (15, 'Total', 'Total', 'Total_ThreePointersAttempted', 'Three Pointers Attempted', 'Top 100 Career Total Three Pointers Attempted', 'No.'),\n (16, 'Total', 'Total', 'Total_FreeThrowsAttempted', 'Free Throws Attempted', 'Top 100 Career Total Free Throws Attempted', 'No.'),\n\n (17, 'PerGame', 'PerGame', 'Average_TotalPoints', 'Points', 'Top 100 Career Points Per Game', 'No.'),\n (18, 'PerGame', 'PerGame', 'Average_TotalRebounds', 'Rebounds', 'Top 100 Career Rebounds Per Game', 'No.'),\n (19, 'PerGame', 'PerGame', 'Average_OffensiveRebounds', 'Offensive Rebounds', 'Top 100 Career Offensive Rebounds Per Game', 'No.'),\n (20, 'PerGame', 'PerGame', 'Average_DefensiveRebounds', 'Defensive Rebounds', 'Top 100 Career Defensive Rebounds Per Game', 'No.'),\n (21, 'PerGame', 'PerGame', 'Average_Assists', 'Assists', 'Top 100 Career Assists Per Game', 'No.'),\n (22, 'PerGame', 'PerGame', 'Average_Steals', 'Steals', 'Top 100 Career Steals Per Game', 'No.'),\n (23, 'PerGame', 'PerGame', 'Average_Blocks', 'Blocks', 'Top 100 Career Blocks Per Game', 'No.'),\n (24, 'PerGame', 'PerGame', 'Average_ThreePointersMade', 'Three Pointers Made', 'Top 100 Career Three Pointers Made Per Game', 'No.'),\n (25, 'PerGame', 'PerGame', 'Average_FreeThrowsMade', 'Free Throws Made', 'Top 100 Career Free Throws Made Per Game', 'No.'),\n (26, 'PerGame', 'PerGame', 'Average_Turnovers', 'TO', 'Top 100 Career Turnovers Per Game', 'No.'),\n (27, 'PerGame', 'PerGame', 'Average_FieldGoalsMade', 'Field Goals Made', 'Top 100 Career Field Goals Made Per Game', 'No.'),\n (28, 'PerGame', 'PerGame', 'Average_FieldGoalsAttempted', 'Field Goals Attempted', 'Top 100 Career Field Goals Attempted Per Game', 'No.'),\n (29, 'PerGame', 'PerGame', 'Average_ThreePointersAttempted', 'Three Pointers Attempted', 'Top 100 Career Three Pointers Attempted Per Game', 'No.'),\n (30, 'PerGame', 'PerGame', 'Average_FreeThrowsAttempted', 'Free Throws Attempted', 'Top 100 Career Free Throws Attempted Per Game', 'No.'),\n (31, 'PerGame', 'PerGame', 'Average_FieldGoalPercentage', 'Field Goal Percentage', 'Top 100 Career Field Goal Percentage', 'No.'),\n (32, 'PerGame', 'PerGame', 'Average_ThreePointerPercentage', 'Three Pointer Percentage', 'Top 100 Career Three Point Percentage', 'No.'),\n (33, 'PerGame', 'PerGame', 'Average_FreeThrowPercentage', 'Free Throw Percentage', 'Top 100 Career Free Throw Percentage', 'No.')\n) AS t(metric_order, metric_type, metric_display_group, metric_value, metric_label, table_title, column_title))\nWHERE metric_display_group = 'Total'\nORDER BY metric_order","inputQueryString":"SELECT *\nFROM ${career_record_metric_options}\nWHERE metric_display_group = 'Total'\nORDER BY metric_order","compiled":true,"inline":true},{"id":"career_metric_per_game_options","compiledQueryString":"SELECT *\nFROM (-- Defines career total, percentage, and per-game dropdown metrics for the career section.\nSELECT *\nFROM (\n VALUES\n (1, 'Total', 'Total', 'Total_GamesPlayed', 'GP', 'Top 100 Career Games Played', 'No.'),\n (2, 'Total', 'Total', 'Total_GamesStarted', 'GS', 'Top 100 Career Games Started', 'No.'),\n (3, 'Total', 'Total', 'Total_TotalPoints', 'Points', 'Top 100 Career Total Points', 'No.'),\n (4, 'Total', 'Total', 'Total_TotalRebounds', 'Rebounds', 'Top 100 Career Total Rebounds', 'No.'),\n (5, 'Total', 'Total', 'Total_OffensiveRebounds', 'Offensive Rebounds', 'Top 100 Career Total Offensive Rebounds', 'No.'),\n (6, 'Total', 'Total', 'Total_DefensiveRebounds', 'Defensive Rebounds', 'Top 100 Career Total Defensive Rebounds', 'No.'),\n (7, 'Total', 'Total', 'Total_Assists', 'Assists', 'Top 100 Career Total Assists', 'No.'),\n (8, 'Total', 'Total', 'Total_Steals', 'Steals', 'Top 100 Career Total Steals', 'No.'),\n (9, 'Total', 'Total', 'Total_Blocks', 'Blocks', 'Top 100 Career Total Blocks', 'No.'),\n (10, 'Total', 'Total', 'Total_ThreePointersMade', 'Three Pointers Made', 'Top 100 Career Total Three Pointers Made', 'No.'),\n (11, 'Total', 'Total', 'Total_FreeThrowsMade', 'Free Throws Made', 'Top 100 Career Total Free Throws Made', 'No.'),\n (12, 'Total', 'Total', 'Total_Turnovers', 'TO', 'Top 100 Career Total Turnovers', 'No.'),\n (13, 'Total', 'Total', 'Total_FieldGoalsMade', 'Field Goals Made', 'Top 100 Career Total Field Goals Made', 'No.'),\n (14, 'Total', 'Total', 'Total_FieldGoalsAttempted', 'Field Goals Attempted', 'Top 100 Career Total Field Goals Attempted', 'No.'),\n (15, 'Total', 'Total', 'Total_ThreePointersAttempted', 'Three Pointers Attempted', 'Top 100 Career Total Three Pointers Attempted', 'No.'),\n (16, 'Total', 'Total', 'Total_FreeThrowsAttempted', 'Free Throws Attempted', 'Top 100 Career Total Free Throws Attempted', 'No.'),\n\n (17, 'PerGame', 'PerGame', 'Average_TotalPoints', 'Points', 'Top 100 Career Points Per Game', 'No.'),\n (18, 'PerGame', 'PerGame', 'Average_TotalRebounds', 'Rebounds', 'Top 100 Career Rebounds Per Game', 'No.'),\n (19, 'PerGame', 'PerGame', 'Average_OffensiveRebounds', 'Offensive Rebounds', 'Top 100 Career Offensive Rebounds Per Game', 'No.'),\n (20, 'PerGame', 'PerGame', 'Average_DefensiveRebounds', 'Defensive Rebounds', 'Top 100 Career Defensive Rebounds Per Game', 'No.'),\n (21, 'PerGame', 'PerGame', 'Average_Assists', 'Assists', 'Top 100 Career Assists Per Game', 'No.'),\n (22, 'PerGame', 'PerGame', 'Average_Steals', 'Steals', 'Top 100 Career Steals Per Game', 'No.'),\n (23, 'PerGame', 'PerGame', 'Average_Blocks', 'Blocks', 'Top 100 Career Blocks Per Game', 'No.'),\n (24, 'PerGame', 'PerGame', 'Average_ThreePointersMade', 'Three Pointers Made', 'Top 100 Career Three Pointers Made Per Game', 'No.'),\n (25, 'PerGame', 'PerGame', 'Average_FreeThrowsMade', 'Free Throws Made', 'Top 100 Career Free Throws Made Per Game', 'No.'),\n (26, 'PerGame', 'PerGame', 'Average_Turnovers', 'TO', 'Top 100 Career Turnovers Per Game', 'No.'),\n (27, 'PerGame', 'PerGame', 'Average_FieldGoalsMade', 'Field Goals Made', 'Top 100 Career Field Goals Made Per Game', 'No.'),\n (28, 'PerGame', 'PerGame', 'Average_FieldGoalsAttempted', 'Field Goals Attempted', 'Top 100 Career Field Goals Attempted Per Game', 'No.'),\n (29, 'PerGame', 'PerGame', 'Average_ThreePointersAttempted', 'Three Pointers Attempted', 'Top 100 Career Three Pointers Attempted Per Game', 'No.'),\n (30, 'PerGame', 'PerGame', 'Average_FreeThrowsAttempted', 'Free Throws Attempted', 'Top 100 Career Free Throws Attempted Per Game', 'No.'),\n (31, 'PerGame', 'PerGame', 'Average_FieldGoalPercentage', 'Field Goal Percentage', 'Top 100 Career Field Goal Percentage', 'No.'),\n (32, 'PerGame', 'PerGame', 'Average_ThreePointerPercentage', 'Three Pointer Percentage', 'Top 100 Career Three Point Percentage', 'No.'),\n (33, 'PerGame', 'PerGame', 'Average_FreeThrowPercentage', 'Free Throw Percentage', 'Top 100 Career Free Throw Percentage', 'No.')\n) AS t(metric_order, metric_type, metric_display_group, metric_value, metric_label, table_title, column_title))\nWHERE metric_display_group = 'PerGame'\nORDER BY metric_order","inputQueryString":"SELECT *\nFROM ${career_record_metric_options}\nWHERE metric_display_group = 'PerGame'\nORDER BY metric_order","compiled":true,"inline":true},{"id":"selected_career_total_record_metric","compiledQueryString":"SELECT *\nFROM (-- Defines career total, percentage, and per-game dropdown metrics for the career section.\nSELECT *\nFROM (\n VALUES\n (1, 'Total', 'Total', 'Total_GamesPlayed', 'GP', 'Top 100 Career Games Played', 'No.'),\n (2, 'Total', 'Total', 'Total_GamesStarted', 'GS', 'Top 100 Career Games Started', 'No.'),\n (3, 'Total', 'Total', 'Total_TotalPoints', 'Points', 'Top 100 Career Total Points', 'No.'),\n (4, 'Total', 'Total', 'Total_TotalRebounds', 'Rebounds', 'Top 100 Career Total Rebounds', 'No.'),\n (5, 'Total', 'Total', 'Total_OffensiveRebounds', 'Offensive Rebounds', 'Top 100 Career Total Offensive Rebounds', 'No.'),\n (6, 'Total', 'Total', 'Total_DefensiveRebounds', 'Defensive Rebounds', 'Top 100 Career Total Defensive Rebounds', 'No.'),\n (7, 'Total', 'Total', 'Total_Assists', 'Assists', 'Top 100 Career Total Assists', 'No.'),\n (8, 'Total', 'Total', 'Total_Steals', 'Steals', 'Top 100 Career Total Steals', 'No.'),\n (9, 'Total', 'Total', 'Total_Blocks', 'Blocks', 'Top 100 Career Total Blocks', 'No.'),\n (10, 'Total', 'Total', 'Total_ThreePointersMade', 'Three Pointers Made', 'Top 100 Career Total Three Pointers Made', 'No.'),\n (11, 'Total', 'Total', 'Total_FreeThrowsMade', 'Free Throws Made', 'Top 100 Career Total Free Throws Made', 'No.'),\n (12, 'Total', 'Total', 'Total_Turnovers', 'TO', 'Top 100 Career Total Turnovers', 'No.'),\n (13, 'Total', 'Total', 'Total_FieldGoalsMade', 'Field Goals Made', 'Top 100 Career Total Field Goals Made', 'No.'),\n (14, 'Total', 'Total', 'Total_FieldGoalsAttempted', 'Field Goals Attempted', 'Top 100 Career Total Field Goals Attempted', 'No.'),\n (15, 'Total', 'Total', 'Total_ThreePointersAttempted', 'Three Pointers Attempted', 'Top 100 Career Total Three Pointers Attempted', 'No.'),\n (16, 'Total', 'Total', 'Total_FreeThrowsAttempted', 'Free Throws Attempted', 'Top 100 Career Total Free Throws Attempted', 'No.'),\n\n (17, 'PerGame', 'PerGame', 'Average_TotalPoints', 'Points', 'Top 100 Career Points Per Game', 'No.'),\n (18, 'PerGame', 'PerGame', 'Average_TotalRebounds', 'Rebounds', 'Top 100 Career Rebounds Per Game', 'No.'),\n (19, 'PerGame', 'PerGame', 'Average_OffensiveRebounds', 'Offensive Rebounds', 'Top 100 Career Offensive Rebounds Per Game', 'No.'),\n (20, 'PerGame', 'PerGame', 'Average_DefensiveRebounds', 'Defensive Rebounds', 'Top 100 Career Defensive Rebounds Per Game', 'No.'),\n (21, 'PerGame', 'PerGame', 'Average_Assists', 'Assists', 'Top 100 Career Assists Per Game', 'No.'),\n (22, 'PerGame', 'PerGame', 'Average_Steals', 'Steals', 'Top 100 Career Steals Per Game', 'No.'),\n (23, 'PerGame', 'PerGame', 'Average_Blocks', 'Blocks', 'Top 100 Career Blocks Per Game', 'No.'),\n (24, 'PerGame', 'PerGame', 'Average_ThreePointersMade', 'Three Pointers Made', 'Top 100 Career Three Pointers Made Per Game', 'No.'),\n (25, 'PerGame', 'PerGame', 'Average_FreeThrowsMade', 'Free Throws Made', 'Top 100 Career Free Throws Made Per Game', 'No.'),\n (26, 'PerGame', 'PerGame', 'Average_Turnovers', 'TO', 'Top 100 Career Turnovers Per Game', 'No.'),\n (27, 'PerGame', 'PerGame', 'Average_FieldGoalsMade', 'Field Goals Made', 'Top 100 Career Field Goals Made Per Game', 'No.'),\n (28, 'PerGame', 'PerGame', 'Average_FieldGoalsAttempted', 'Field Goals Attempted', 'Top 100 Career Field Goals Attempted Per Game', 'No.'),\n (29, 'PerGame', 'PerGame', 'Average_ThreePointersAttempted', 'Three Pointers Attempted', 'Top 100 Career Three Pointers Attempted Per Game', 'No.'),\n (30, 'PerGame', 'PerGame', 'Average_FreeThrowsAttempted', 'Free Throws Attempted', 'Top 100 Career Free Throws Attempted Per Game', 'No.'),\n (31, 'PerGame', 'PerGame', 'Average_FieldGoalPercentage', 'Field Goal Percentage', 'Top 100 Career Field Goal Percentage', 'No.'),\n (32, 'PerGame', 'PerGame', 'Average_ThreePointerPercentage', 'Three Pointer Percentage', 'Top 100 Career Three Point Percentage', 'No.'),\n (33, 'PerGame', 'PerGame', 'Average_FreeThrowPercentage', 'Free Throw Percentage', 'Top 100 Career Free Throw Percentage', 'No.')\n) AS t(metric_order, metric_type, metric_display_group, metric_value, metric_label, table_title, column_title))\nWHERE metric_value = '${inputs.career_total_record_metric.value}'","inputQueryString":"SELECT *\nFROM ${career_record_metric_options}\nWHERE metric_value = '${inputs.career_total_record_metric.value}'","compiled":true,"inline":true},{"id":"selected_career_per_game_record_metric","compiledQueryString":"SELECT *\nFROM (-- Defines career total, percentage, and per-game dropdown metrics for the career section.\nSELECT *\nFROM (\n VALUES\n (1, 'Total', 'Total', 'Total_GamesPlayed', 'GP', 'Top 100 Career Games Played', 'No.'),\n (2, 'Total', 'Total', 'Total_GamesStarted', 'GS', 'Top 100 Career Games Started', 'No.'),\n (3, 'Total', 'Total', 'Total_TotalPoints', 'Points', 'Top 100 Career Total Points', 'No.'),\n (4, 'Total', 'Total', 'Total_TotalRebounds', 'Rebounds', 'Top 100 Career Total Rebounds', 'No.'),\n (5, 'Total', 'Total', 'Total_OffensiveRebounds', 'Offensive Rebounds', 'Top 100 Career Total Offensive Rebounds', 'No.'),\n (6, 'Total', 'Total', 'Total_DefensiveRebounds', 'Defensive Rebounds', 'Top 100 Career Total Defensive Rebounds', 'No.'),\n (7, 'Total', 'Total', 'Total_Assists', 'Assists', 'Top 100 Career Total Assists', 'No.'),\n (8, 'Total', 'Total', 'Total_Steals', 'Steals', 'Top 100 Career Total Steals', 'No.'),\n (9, 'Total', 'Total', 'Total_Blocks', 'Blocks', 'Top 100 Career Total Blocks', 'No.'),\n (10, 'Total', 'Total', 'Total_ThreePointersMade', 'Three Pointers Made', 'Top 100 Career Total Three Pointers Made', 'No.'),\n (11, 'Total', 'Total', 'Total_FreeThrowsMade', 'Free Throws Made', 'Top 100 Career Total Free Throws Made', 'No.'),\n (12, 'Total', 'Total', 'Total_Turnovers', 'TO', 'Top 100 Career Total Turnovers', 'No.'),\n (13, 'Total', 'Total', 'Total_FieldGoalsMade', 'Field Goals Made', 'Top 100 Career Total Field Goals Made', 'No.'),\n (14, 'Total', 'Total', 'Total_FieldGoalsAttempted', 'Field Goals Attempted', 'Top 100 Career Total Field Goals Attempted', 'No.'),\n (15, 'Total', 'Total', 'Total_ThreePointersAttempted', 'Three Pointers Attempted', 'Top 100 Career Total Three Pointers Attempted', 'No.'),\n (16, 'Total', 'Total', 'Total_FreeThrowsAttempted', 'Free Throws Attempted', 'Top 100 Career Total Free Throws Attempted', 'No.'),\n\n (17, 'PerGame', 'PerGame', 'Average_TotalPoints', 'Points', 'Top 100 Career Points Per Game', 'No.'),\n (18, 'PerGame', 'PerGame', 'Average_TotalRebounds', 'Rebounds', 'Top 100 Career Rebounds Per Game', 'No.'),\n (19, 'PerGame', 'PerGame', 'Average_OffensiveRebounds', 'Offensive Rebounds', 'Top 100 Career Offensive Rebounds Per Game', 'No.'),\n (20, 'PerGame', 'PerGame', 'Average_DefensiveRebounds', 'Defensive Rebounds', 'Top 100 Career Defensive Rebounds Per Game', 'No.'),\n (21, 'PerGame', 'PerGame', 'Average_Assists', 'Assists', 'Top 100 Career Assists Per Game', 'No.'),\n (22, 'PerGame', 'PerGame', 'Average_Steals', 'Steals', 'Top 100 Career Steals Per Game', 'No.'),\n (23, 'PerGame', 'PerGame', 'Average_Blocks', 'Blocks', 'Top 100 Career Blocks Per Game', 'No.'),\n (24, 'PerGame', 'PerGame', 'Average_ThreePointersMade', 'Three Pointers Made', 'Top 100 Career Three Pointers Made Per Game', 'No.'),\n (25, 'PerGame', 'PerGame', 'Average_FreeThrowsMade', 'Free Throws Made', 'Top 100 Career Free Throws Made Per Game', 'No.'),\n (26, 'PerGame', 'PerGame', 'Average_Turnovers', 'TO', 'Top 100 Career Turnovers Per Game', 'No.'),\n (27, 'PerGame', 'PerGame', 'Average_FieldGoalsMade', 'Field Goals Made', 'Top 100 Career Field Goals Made Per Game', 'No.'),\n (28, 'PerGame', 'PerGame', 'Average_FieldGoalsAttempted', 'Field Goals Attempted', 'Top 100 Career Field Goals Attempted Per Game', 'No.'),\n (29, 'PerGame', 'PerGame', 'Average_ThreePointersAttempted', 'Three Pointers Attempted', 'Top 100 Career Three Pointers Attempted Per Game', 'No.'),\n (30, 'PerGame', 'PerGame', 'Average_FreeThrowsAttempted', 'Free Throws Attempted', 'Top 100 Career Free Throws Attempted Per Game', 'No.'),\n (31, 'PerGame', 'PerGame', 'Average_FieldGoalPercentage', 'Field Goal Percentage', 'Top 100 Career Field Goal Percentage', 'No.'),\n (32, 'PerGame', 'PerGame', 'Average_ThreePointerPercentage', 'Three Pointer Percentage', 'Top 100 Career Three Point Percentage', 'No.'),\n (33, 'PerGame', 'PerGame', 'Average_FreeThrowPercentage', 'Free Throw Percentage', 'Top 100 Career Free Throw Percentage', 'No.')\n) AS t(metric_order, metric_type, metric_display_group, metric_value, metric_label, table_title, column_title))\nWHERE metric_value = '${inputs.career_per_game_record_metric.value}'","inputQueryString":"SELECT *\nFROM ${career_record_metric_options}\nWHERE metric_value = '${inputs.career_per_game_record_metric.value}'","compiled":true,"inline":true},{"id":"career_selected_opponents","compiledQueryString":"-- Career records use their own selected-opponent context so career filters can differ\n-- from the game and season record sections.\nSELECT Opponent\nFROM (-- Shared opponent dropdown. The '__ALL__' row is preserved so filters can detect\n-- \"all opponents\" without building a separate query path.\nSELECT DISTINCT\n Opponent,\n OpponentLabel,\n sort_order\nFROM SPORTS_INFO_DW_REPORTING.opponent_options\nWHERE Opponent = '__ALL__'\n OR '${inputs.season_type_button}' IN ('All', 'All Season')\n OR (\n '${inputs.season_type_button}' = 'POST'\n AND SeasonType IN ('ACC', 'NCAA', 'AIAW', 'NWIT', 'WNIT')\n )\n OR SeasonType = '${inputs.season_type_button}'\nORDER BY sort_order, OpponentLabel)\nWHERE Opponent <> '__ALL__'\n AND '__ALL__' NOT IN ${inputs.opponent_dropdown_career.value}\n AND Opponent IN ${inputs.opponent_dropdown_career.value}","inputQueryString":"-- Career records use their own selected-opponent context so career filters can differ\n-- from the game and season record sections.\nSELECT Opponent\nFROM ${opponent_options}\nWHERE Opponent <> '__ALL__'\n AND '__ALL__' NOT IN ${inputs.opponent_dropdown_career.value}\n AND Opponent IN ${inputs.opponent_dropdown_career.value}","compiled":true,"inline":true},{"id":"career_record_selection_context","compiledQueryString":"SELECT\n COUNT(*) AS SelectedOpponentCount\n FROM (-- Career records use their own selected-opponent context so career filters can differ\n-- from the game and season record sections.\nSELECT Opponent\nFROM (-- Shared opponent dropdown. The '__ALL__' row is preserved so filters can detect\n-- \"all opponents\" without building a separate query path.\nSELECT DISTINCT\n Opponent,\n OpponentLabel,\n sort_order\nFROM SPORTS_INFO_DW_REPORTING.opponent_options\nWHERE Opponent = '__ALL__'\n OR '${inputs.season_type_button}' IN ('All', 'All Season')\n OR (\n '${inputs.season_type_button}' = 'POST'\n AND SeasonType IN ('ACC', 'NCAA', 'AIAW', 'NWIT', 'WNIT')\n )\n OR SeasonType = '${inputs.season_type_button}'\nORDER BY sort_order, OpponentLabel)\nWHERE Opponent <> '__ALL__'\n AND '__ALL__' NOT IN ${inputs.opponent_dropdown_career.value}\n AND Opponent IN ${inputs.opponent_dropdown_career.value})","inputQueryString":"SELECT\n COUNT(*) AS SelectedOpponentCount\n FROM ${career_selected_opponents}","compiled":true,"inline":true},{"id":"career_source","compiledQueryString":"-- Applies the career section filters before aggregation so career totals, percentages,\n-- and per-game values share the same season-type and opponent context.\nSELECT\n p.PlayerName,\n p.Opponent,\n p.Season,\n p.GamesPlayed,\n p.GamesStarted,\n p.TotalPoints,\n p.TotalRebounds,\n p.OffensiveRebounds,\n p.DefensiveRebounds,\n p.Assists,\n p.Steals,\n p.Blocks,\n p.ThreePointersMade,\n p.FreeThrowsMade,\n p.Turnovers,\n p.FieldGoalsMade,\n p.FieldGoalsAttempted,\n p.ThreePointersAttempted,\n p.FreeThrowsAttempted,\n CASE\n WHEN p.PlayerName IN ('Amanda Frist','Amanda White') THEN 'Amanda Frist'\n WHEN p.PlayerName IN ('Julie Larson','Julie L. Brickley') THEN 'Julie Brickley'\n ELSE p.PlayerName\n END AS CanonicalPlayerName,\n CASE\n WHEN '${inputs.season_type_button}' IN ('All', 'All Season') THEN 'All'\n WHEN '${inputs.season_type_button}' = 'POST' THEN 'POST'\n ELSE p.SeasonType\n END AS CareerSeasonType\nFROM SPORTS_INFO_DW_REPORTING.vw_WBB_player_stats_by_game p\nWHERE p.IsClemson = 1\n AND (\n '${inputs.season_type_button}' IN ('All', 'All Season')\n OR (\n '${inputs.season_type_button}' = 'POST'\n AND p.SeasonType IN ('ACC', 'NCAA', 'NWIT', 'AIAW', 'WNIT')\n )\n OR p.SeasonType = '${inputs.season_type_button}'\n )","inputQueryString":"-- Applies the career section filters before aggregation so career totals, percentages,\n-- and per-game values share the same season-type and opponent context.\nSELECT\n p.PlayerName,\n p.Opponent,\n p.Season,\n p.GamesPlayed,\n p.GamesStarted,\n p.TotalPoints,\n p.TotalRebounds,\n p.OffensiveRebounds,\n p.DefensiveRebounds,\n p.Assists,\n p.Steals,\n p.Blocks,\n p.ThreePointersMade,\n p.FreeThrowsMade,\n p.Turnovers,\n p.FieldGoalsMade,\n p.FieldGoalsAttempted,\n p.ThreePointersAttempted,\n p.FreeThrowsAttempted,\n CASE\n WHEN p.PlayerName IN ('Amanda Frist','Amanda White') THEN 'Amanda Frist'\n WHEN p.PlayerName IN ('Julie Larson','Julie L. Brickley') THEN 'Julie Brickley'\n ELSE p.PlayerName\n END AS CanonicalPlayerName,\n CASE\n WHEN '${inputs.season_type_button}' IN ('All', 'All Season') THEN 'All'\n WHEN '${inputs.season_type_button}' = 'POST' THEN 'POST'\n ELSE p.SeasonType\n END AS CareerSeasonType\nFROM SPORTS_INFO_DW_REPORTING.vw_WBB_player_stats_by_game p\nWHERE p.IsClemson = 1\n AND (\n '${inputs.season_type_button}' IN ('All', 'All Season')\n OR (\n '${inputs.season_type_button}' = 'POST'\n AND p.SeasonType IN ('ACC', 'NCAA', 'NWIT', 'AIAW', 'WNIT')\n )\n OR p.SeasonType = '${inputs.season_type_button}'\n )","compiled":false,"inline":true},{"id":"player_career_base","compiledQueryString":"-- Aggregates filtered games to one player career row. Counting stats are summed and\n-- shooting values are calculated later from career made/attempt totals.\nSELECT\n p.CanonicalPlayerName AS PlayerName,\n p.CareerSeasonType AS SeasonType,\n\n CASE\n WHEN sc.SelectedOpponentCount = 0 THEN 'All Opponents'\n WHEN sc.SelectedOpponentCount = 1 THEN ANY_VALUE(p.Opponent)\n ELSE STRING_AGG(DISTINCT p.Opponent, ', ')\n END AS Opponent,\n\n sc.SelectedOpponentCount,\n\n MIN(CAST(LEFT(p.Season, 4) AS INT)) AS FirstSeason,\n MAX(CAST(RIGHT(p.Season, 4) AS INT)) AS LastSeason,\n\n SUM(p.GamesPlayed) AS GamesPlayed,\n SUM(p.GamesStarted) AS GamesStarted,\n SUM(p.TotalPoints) AS TotalPoints,\n SUM(p.TotalRebounds) AS TotalRebounds,\n SUM(p.OffensiveRebounds) AS OffensiveRebounds,\n -- Maintenance note: The defensive-rebound cutoff is encoded here to match other\n -- record sections; verify the intended historical availability rule before changing.\n SUM(CASE WHEN p.Season >= '1985' THEN p.DefensiveRebounds ELSE 0 END) AS DefensiveRebounds,\n SUM(p.Assists) AS Assists,\n SUM(p.Steals) AS Steals,\n SUM(p.Blocks) AS Blocks,\n SUM(p.ThreePointersMade) AS ThreePointersMade,\n SUM(p.FreeThrowsMade) AS FreeThrowsMade,\n SUM(p.Turnovers) AS Turnovers,\n SUM(p.FieldGoalsMade) AS FieldGoalsMade,\n SUM(p.FieldGoalsAttempted) AS FieldGoalsAttempted,\n SUM(p.ThreePointersAttempted) AS ThreePointersAttempted,\n SUM(p.FreeThrowsAttempted) AS FreeThrowsAttempted,\n (SUM(p.GamesPlayed)*5) AS MinFieldGoalsMade,\n (SUM(p.GamesPlayed)*2) AS MinThreePointersAttempted,\n (SUM(p.GamesPlayed)*2) AS MinFreeThrowsAttempted\nFROM (-- Applies the career section filters before aggregation so career totals, percentages,\n-- and per-game values share the same season-type and opponent context.\nSELECT\n p.PlayerName,\n p.Opponent,\n p.Season,\n p.GamesPlayed,\n p.GamesStarted,\n p.TotalPoints,\n p.TotalRebounds,\n p.OffensiveRebounds,\n p.DefensiveRebounds,\n p.Assists,\n p.Steals,\n p.Blocks,\n p.ThreePointersMade,\n p.FreeThrowsMade,\n p.Turnovers,\n p.FieldGoalsMade,\n p.FieldGoalsAttempted,\n p.ThreePointersAttempted,\n p.FreeThrowsAttempted,\n CASE\n WHEN p.PlayerName IN ('Amanda Frist','Amanda White') THEN 'Amanda Frist'\n WHEN p.PlayerName IN ('Julie Larson','Julie L. Brickley') THEN 'Julie Brickley'\n ELSE p.PlayerName\n END AS CanonicalPlayerName,\n CASE\n WHEN '${inputs.season_type_button}' IN ('All', 'All Season') THEN 'All'\n WHEN '${inputs.season_type_button}' = 'POST' THEN 'POST'\n ELSE p.SeasonType\n END AS CareerSeasonType\nFROM SPORTS_INFO_DW_REPORTING.vw_WBB_player_stats_by_game p\nWHERE p.IsClemson = 1\n AND (\n '${inputs.season_type_button}' IN ('All', 'All Season')\n OR (\n '${inputs.season_type_button}' = 'POST'\n AND p.SeasonType IN ('ACC', 'NCAA', 'NWIT', 'AIAW', 'WNIT')\n )\n OR p.SeasonType = '${inputs.season_type_button}'\n )) p\nCROSS JOIN (SELECT\n COUNT(*) AS SelectedOpponentCount\n FROM (-- Career records use their own selected-opponent context so career filters can differ\n-- from the game and season record sections.\nSELECT Opponent\nFROM (-- Shared opponent dropdown. The '__ALL__' row is preserved so filters can detect\n-- \"all opponents\" without building a separate query path.\nSELECT DISTINCT\n Opponent,\n OpponentLabel,\n sort_order\nFROM SPORTS_INFO_DW_REPORTING.opponent_options\nWHERE Opponent = '__ALL__'\n OR '${inputs.season_type_button}' IN ('All', 'All Season')\n OR (\n '${inputs.season_type_button}' = 'POST'\n AND SeasonType IN ('ACC', 'NCAA', 'AIAW', 'NWIT', 'WNIT')\n )\n OR SeasonType = '${inputs.season_type_button}'\nORDER BY sort_order, OpponentLabel)\nWHERE Opponent <> '__ALL__'\n AND '__ALL__' NOT IN ${inputs.opponent_dropdown_career.value}\n AND Opponent IN ${inputs.opponent_dropdown_career.value})) sc\nWHERE sc.SelectedOpponentCount = 0\n OR p.Opponent IN (\n SELECT Opponent\n FROM (-- Career records use their own selected-opponent context so career filters can differ\n-- from the game and season record sections.\nSELECT Opponent\nFROM (-- Shared opponent dropdown. The '__ALL__' row is preserved so filters can detect\n-- \"all opponents\" without building a separate query path.\nSELECT DISTINCT\n Opponent,\n OpponentLabel,\n sort_order\nFROM SPORTS_INFO_DW_REPORTING.opponent_options\nWHERE Opponent = '__ALL__'\n OR '${inputs.season_type_button}' IN ('All', 'All Season')\n OR (\n '${inputs.season_type_button}' = 'POST'\n AND SeasonType IN ('ACC', 'NCAA', 'AIAW', 'NWIT', 'WNIT')\n )\n OR SeasonType = '${inputs.season_type_button}'\nORDER BY sort_order, OpponentLabel)\nWHERE Opponent <> '__ALL__'\n AND '__ALL__' NOT IN ${inputs.opponent_dropdown_career.value}\n AND Opponent IN ${inputs.opponent_dropdown_career.value})\n )\nGROUP BY\n p.CanonicalPlayerName,\n p.CareerSeasonType,\n sc.SelectedOpponentCount","inputQueryString":"-- Aggregates filtered games to one player career row. Counting stats are summed and\n-- shooting values are calculated later from career made/attempt totals.\nSELECT\n p.CanonicalPlayerName AS PlayerName,\n p.CareerSeasonType AS SeasonType,\n\n CASE\n WHEN sc.SelectedOpponentCount = 0 THEN 'All Opponents'\n WHEN sc.SelectedOpponentCount = 1 THEN ANY_VALUE(p.Opponent)\n ELSE STRING_AGG(DISTINCT p.Opponent, ', ')\n END AS Opponent,\n\n sc.SelectedOpponentCount,\n\n MIN(CAST(LEFT(p.Season, 4) AS INT)) AS FirstSeason,\n MAX(CAST(RIGHT(p.Season, 4) AS INT)) AS LastSeason,\n\n SUM(p.GamesPlayed) AS GamesPlayed,\n SUM(p.GamesStarted) AS GamesStarted,\n SUM(p.TotalPoints) AS TotalPoints,\n SUM(p.TotalRebounds) AS TotalRebounds,\n SUM(p.OffensiveRebounds) AS OffensiveRebounds,\n -- Maintenance note: The defensive-rebound cutoff is encoded here to match other\n -- record sections; verify the intended historical availability rule before changing.\n SUM(CASE WHEN p.Season >= '1985' THEN p.DefensiveRebounds ELSE 0 END) AS DefensiveRebounds,\n SUM(p.Assists) AS Assists,\n SUM(p.Steals) AS Steals,\n SUM(p.Blocks) AS Blocks,\n SUM(p.ThreePointersMade) AS ThreePointersMade,\n SUM(p.FreeThrowsMade) AS FreeThrowsMade,\n SUM(p.Turnovers) AS Turnovers,\n SUM(p.FieldGoalsMade) AS FieldGoalsMade,\n SUM(p.FieldGoalsAttempted) AS FieldGoalsAttempted,\n SUM(p.ThreePointersAttempted) AS ThreePointersAttempted,\n SUM(p.FreeThrowsAttempted) AS FreeThrowsAttempted,\n (SUM(p.GamesPlayed)*5) AS MinFieldGoalsMade,\n (SUM(p.GamesPlayed)*2) AS MinThreePointersAttempted,\n (SUM(p.GamesPlayed)*2) AS MinFreeThrowsAttempted\nFROM ${career_source} p\nCROSS JOIN ${career_record_selection_context} sc\nWHERE sc.SelectedOpponentCount = 0\n OR p.Opponent IN (\n SELECT Opponent\n FROM ${career_selected_opponents}\n )\nGROUP BY\n p.CanonicalPlayerName,\n p.CareerSeasonType,\n sc.SelectedOpponentCount","compiled":true,"inline":true},{"id":"individual_career_total_ranking","compiledQueryString":"-- Ranks career total and percentage metrics. Minimum games and attempt thresholds are\n-- encoded here and should be verified before modification.\nWITH career_metrics AS (\n SELECT\n c.PlayerName,\n '/player_profiles/' || replace(replace(c.PlayerName, ' ', '%20'), '''', '%27') AS link,\n c.FirstSeason || ' - ' || c.LastSeason AS CareerSeasons,\n c.GamesPlayed,\n c.SeasonType,\n c.Opponent,\n c.SelectedOpponentCount,\n c.MinFieldGoalsMade,\n c.MinThreePointersAttempted,\n c.MinFreeThrowsAttempted,\n c.FieldGoalsMade,\n c.FieldGoalsAttempted,\n c.ThreePointersMade,\n c.ThreePointersAttempted,\n c.FreeThrowsMade,\n c.FreeThrowsAttempted,\n o.metric_type AS MetricType,\n o.metric_display_group AS MetricDisplayGroup,\n o.metric_value AS MetricValue,\n o.metric_label AS MetricLabel,\n o.table_title AS TableTitle,\n o.column_title AS ColumnTitle,\n CASE o.metric_value\n WHEN 'Total_GamesPlayed' THEN c.GamesPlayed * 1.0\n WHEN 'Total_GamesStarted' THEN c.GamesStarted * 1.0\n WHEN 'Total_TotalPoints' THEN c.TotalPoints * 1.0\n WHEN 'Total_TotalRebounds' THEN c.TotalRebounds * 1.0\n WHEN 'Total_OffensiveRebounds' THEN c.OffensiveRebounds * 1.0\n WHEN 'Total_DefensiveRebounds' THEN c.DefensiveRebounds * 1.0\n WHEN 'Total_Assists' THEN c.Assists * 1.0\n WHEN 'Total_Steals' THEN c.Steals * 1.0\n WHEN 'Total_Blocks' THEN c.Blocks * 1.0\n WHEN 'Total_ThreePointersMade' THEN c.ThreePointersMade * 1.0\n WHEN 'Total_FreeThrowsMade' THEN c.FreeThrowsMade * 1.0\n WHEN 'Total_Turnovers' THEN c.Turnovers * 1.0\n WHEN 'Total_FieldGoalsMade' THEN c.FieldGoalsMade * 1.0\n WHEN 'Total_FieldGoalsAttempted' THEN c.FieldGoalsAttempted * 1.0\n WHEN 'Total_ThreePointersAttempted' THEN c.ThreePointersAttempted * 1.0\n WHEN 'Total_FreeThrowsAttempted' THEN c.FreeThrowsAttempted * 1.0\n END AS CareerRecordValue\n FROM (-- Aggregates filtered games to one player career row. Counting stats are summed and\n-- shooting values are calculated later from career made/attempt totals.\nSELECT\n p.CanonicalPlayerName AS PlayerName,\n p.CareerSeasonType AS SeasonType,\n\n CASE\n WHEN sc.SelectedOpponentCount = 0 THEN 'All Opponents'\n WHEN sc.SelectedOpponentCount = 1 THEN ANY_VALUE(p.Opponent)\n ELSE STRING_AGG(DISTINCT p.Opponent, ', ')\n END AS Opponent,\n\n sc.SelectedOpponentCount,\n\n MIN(CAST(LEFT(p.Season, 4) AS INT)) AS FirstSeason,\n MAX(CAST(RIGHT(p.Season, 4) AS INT)) AS LastSeason,\n\n SUM(p.GamesPlayed) AS GamesPlayed,\n SUM(p.GamesStarted) AS GamesStarted,\n SUM(p.TotalPoints) AS TotalPoints,\n SUM(p.TotalRebounds) AS TotalRebounds,\n SUM(p.OffensiveRebounds) AS OffensiveRebounds,\n -- Maintenance note: The defensive-rebound cutoff is encoded here to match other\n -- record sections; verify the intended historical availability rule before changing.\n SUM(CASE WHEN p.Season >= '1985' THEN p.DefensiveRebounds ELSE 0 END) AS DefensiveRebounds,\n SUM(p.Assists) AS Assists,\n SUM(p.Steals) AS Steals,\n SUM(p.Blocks) AS Blocks,\n SUM(p.ThreePointersMade) AS ThreePointersMade,\n SUM(p.FreeThrowsMade) AS FreeThrowsMade,\n SUM(p.Turnovers) AS Turnovers,\n SUM(p.FieldGoalsMade) AS FieldGoalsMade,\n SUM(p.FieldGoalsAttempted) AS FieldGoalsAttempted,\n SUM(p.ThreePointersAttempted) AS ThreePointersAttempted,\n SUM(p.FreeThrowsAttempted) AS FreeThrowsAttempted,\n (SUM(p.GamesPlayed)*5) AS MinFieldGoalsMade,\n (SUM(p.GamesPlayed)*2) AS MinThreePointersAttempted,\n (SUM(p.GamesPlayed)*2) AS MinFreeThrowsAttempted\nFROM (-- Applies the career section filters before aggregation so career totals, percentages,\n-- and per-game values share the same season-type and opponent context.\nSELECT\n p.PlayerName,\n p.Opponent,\n p.Season,\n p.GamesPlayed,\n p.GamesStarted,\n p.TotalPoints,\n p.TotalRebounds,\n p.OffensiveRebounds,\n p.DefensiveRebounds,\n p.Assists,\n p.Steals,\n p.Blocks,\n p.ThreePointersMade,\n p.FreeThrowsMade,\n p.Turnovers,\n p.FieldGoalsMade,\n p.FieldGoalsAttempted,\n p.ThreePointersAttempted,\n p.FreeThrowsAttempted,\n CASE\n WHEN p.PlayerName IN ('Amanda Frist','Amanda White') THEN 'Amanda Frist'\n WHEN p.PlayerName IN ('Julie Larson','Julie L. Brickley') THEN 'Julie Brickley'\n ELSE p.PlayerName\n END AS CanonicalPlayerName,\n CASE\n WHEN '${inputs.season_type_button}' IN ('All', 'All Season') THEN 'All'\n WHEN '${inputs.season_type_button}' = 'POST' THEN 'POST'\n ELSE p.SeasonType\n END AS CareerSeasonType\nFROM SPORTS_INFO_DW_REPORTING.vw_WBB_player_stats_by_game p\nWHERE p.IsClemson = 1\n AND (\n '${inputs.season_type_button}' IN ('All', 'All Season')\n OR (\n '${inputs.season_type_button}' = 'POST'\n AND p.SeasonType IN ('ACC', 'NCAA', 'NWIT', 'AIAW', 'WNIT')\n )\n OR p.SeasonType = '${inputs.season_type_button}'\n )) p\nCROSS JOIN (SELECT\n COUNT(*) AS SelectedOpponentCount\n FROM (-- Career records use their own selected-opponent context so career filters can differ\n-- from the game and season record sections.\nSELECT Opponent\nFROM (-- Shared opponent dropdown. The '__ALL__' row is preserved so filters can detect\n-- \"all opponents\" without building a separate query path.\nSELECT DISTINCT\n Opponent,\n OpponentLabel,\n sort_order\nFROM SPORTS_INFO_DW_REPORTING.opponent_options\nWHERE Opponent = '__ALL__'\n OR '${inputs.season_type_button}' IN ('All', 'All Season')\n OR (\n '${inputs.season_type_button}' = 'POST'\n AND SeasonType IN ('ACC', 'NCAA', 'AIAW', 'NWIT', 'WNIT')\n )\n OR SeasonType = '${inputs.season_type_button}'\nORDER BY sort_order, OpponentLabel)\nWHERE Opponent <> '__ALL__'\n AND '__ALL__' NOT IN ${inputs.opponent_dropdown_career.value}\n AND Opponent IN ${inputs.opponent_dropdown_career.value})) sc\nWHERE sc.SelectedOpponentCount = 0\n OR p.Opponent IN (\n SELECT Opponent\n FROM (-- Career records use their own selected-opponent context so career filters can differ\n-- from the game and season record sections.\nSELECT Opponent\nFROM (-- Shared opponent dropdown. The '__ALL__' row is preserved so filters can detect\n-- \"all opponents\" without building a separate query path.\nSELECT DISTINCT\n Opponent,\n OpponentLabel,\n sort_order\nFROM SPORTS_INFO_DW_REPORTING.opponent_options\nWHERE Opponent = '__ALL__'\n OR '${inputs.season_type_button}' IN ('All', 'All Season')\n OR (\n '${inputs.season_type_button}' = 'POST'\n AND SeasonType IN ('ACC', 'NCAA', 'AIAW', 'NWIT', 'WNIT')\n )\n OR SeasonType = '${inputs.season_type_button}'\nORDER BY sort_order, OpponentLabel)\nWHERE Opponent <> '__ALL__'\n AND '__ALL__' NOT IN ${inputs.opponent_dropdown_career.value}\n AND Opponent IN ${inputs.opponent_dropdown_career.value})\n )\nGROUP BY\n p.CanonicalPlayerName,\n p.CareerSeasonType,\n sc.SelectedOpponentCount) c\n CROSS JOIN (SELECT *\nFROM (-- Defines career total, percentage, and per-game dropdown metrics for the career section.\nSELECT *\nFROM (\n VALUES\n (1, 'Total', 'Total', 'Total_GamesPlayed', 'GP', 'Top 100 Career Games Played', 'No.'),\n (2, 'Total', 'Total', 'Total_GamesStarted', 'GS', 'Top 100 Career Games Started', 'No.'),\n (3, 'Total', 'Total', 'Total_TotalPoints', 'Points', 'Top 100 Career Total Points', 'No.'),\n (4, 'Total', 'Total', 'Total_TotalRebounds', 'Rebounds', 'Top 100 Career Total Rebounds', 'No.'),\n (5, 'Total', 'Total', 'Total_OffensiveRebounds', 'Offensive Rebounds', 'Top 100 Career Total Offensive Rebounds', 'No.'),\n (6, 'Total', 'Total', 'Total_DefensiveRebounds', 'Defensive Rebounds', 'Top 100 Career Total Defensive Rebounds', 'No.'),\n (7, 'Total', 'Total', 'Total_Assists', 'Assists', 'Top 100 Career Total Assists', 'No.'),\n (8, 'Total', 'Total', 'Total_Steals', 'Steals', 'Top 100 Career Total Steals', 'No.'),\n (9, 'Total', 'Total', 'Total_Blocks', 'Blocks', 'Top 100 Career Total Blocks', 'No.'),\n (10, 'Total', 'Total', 'Total_ThreePointersMade', 'Three Pointers Made', 'Top 100 Career Total Three Pointers Made', 'No.'),\n (11, 'Total', 'Total', 'Total_FreeThrowsMade', 'Free Throws Made', 'Top 100 Career Total Free Throws Made', 'No.'),\n (12, 'Total', 'Total', 'Total_Turnovers', 'TO', 'Top 100 Career Total Turnovers', 'No.'),\n (13, 'Total', 'Total', 'Total_FieldGoalsMade', 'Field Goals Made', 'Top 100 Career Total Field Goals Made', 'No.'),\n (14, 'Total', 'Total', 'Total_FieldGoalsAttempted', 'Field Goals Attempted', 'Top 100 Career Total Field Goals Attempted', 'No.'),\n (15, 'Total', 'Total', 'Total_ThreePointersAttempted', 'Three Pointers Attempted', 'Top 100 Career Total Three Pointers Attempted', 'No.'),\n (16, 'Total', 'Total', 'Total_FreeThrowsAttempted', 'Free Throws Attempted', 'Top 100 Career Total Free Throws Attempted', 'No.'),\n\n (17, 'PerGame', 'PerGame', 'Average_TotalPoints', 'Points', 'Top 100 Career Points Per Game', 'No.'),\n (18, 'PerGame', 'PerGame', 'Average_TotalRebounds', 'Rebounds', 'Top 100 Career Rebounds Per Game', 'No.'),\n (19, 'PerGame', 'PerGame', 'Average_OffensiveRebounds', 'Offensive Rebounds', 'Top 100 Career Offensive Rebounds Per Game', 'No.'),\n (20, 'PerGame', 'PerGame', 'Average_DefensiveRebounds', 'Defensive Rebounds', 'Top 100 Career Defensive Rebounds Per Game', 'No.'),\n (21, 'PerGame', 'PerGame', 'Average_Assists', 'Assists', 'Top 100 Career Assists Per Game', 'No.'),\n (22, 'PerGame', 'PerGame', 'Average_Steals', 'Steals', 'Top 100 Career Steals Per Game', 'No.'),\n (23, 'PerGame', 'PerGame', 'Average_Blocks', 'Blocks', 'Top 100 Career Blocks Per Game', 'No.'),\n (24, 'PerGame', 'PerGame', 'Average_ThreePointersMade', 'Three Pointers Made', 'Top 100 Career Three Pointers Made Per Game', 'No.'),\n (25, 'PerGame', 'PerGame', 'Average_FreeThrowsMade', 'Free Throws Made', 'Top 100 Career Free Throws Made Per Game', 'No.'),\n (26, 'PerGame', 'PerGame', 'Average_Turnovers', 'TO', 'Top 100 Career Turnovers Per Game', 'No.'),\n (27, 'PerGame', 'PerGame', 'Average_FieldGoalsMade', 'Field Goals Made', 'Top 100 Career Field Goals Made Per Game', 'No.'),\n (28, 'PerGame', 'PerGame', 'Average_FieldGoalsAttempted', 'Field Goals Attempted', 'Top 100 Career Field Goals Attempted Per Game', 'No.'),\n (29, 'PerGame', 'PerGame', 'Average_ThreePointersAttempted', 'Three Pointers Attempted', 'Top 100 Career Three Pointers Attempted Per Game', 'No.'),\n (30, 'PerGame', 'PerGame', 'Average_FreeThrowsAttempted', 'Free Throws Attempted', 'Top 100 Career Free Throws Attempted Per Game', 'No.'),\n (31, 'PerGame', 'PerGame', 'Average_FieldGoalPercentage', 'Field Goal Percentage', 'Top 100 Career Field Goal Percentage', 'No.'),\n (32, 'PerGame', 'PerGame', 'Average_ThreePointerPercentage', 'Three Pointer Percentage', 'Top 100 Career Three Point Percentage', 'No.'),\n (33, 'PerGame', 'PerGame', 'Average_FreeThrowPercentage', 'Free Throw Percentage', 'Top 100 Career Free Throw Percentage', 'No.')\n) AS t(metric_order, metric_type, metric_display_group, metric_value, metric_label, table_title, column_title))\nWHERE metric_value = '${inputs.career_total_record_metric.value}') o\n WHERE c.GamesPlayed >= 5\n),\n\ncareer_ranked AS (\n SELECT\n *,\n CAST(\n RANK() OVER (\n ORDER BY CareerRecordValue DESC NULLS LAST\n ) AS INT\n ) AS CareerRanking\n FROM career_metrics\n WHERE MetricDisplayGroup = 'Total'\n AND MetricValue = '${inputs.career_total_record_metric.value}'\n)\n\nSELECT *\nFROM career_ranked\nORDER BY CareerRanking\nLIMIT 100","inputQueryString":"-- Ranks career total and percentage metrics. Minimum games and attempt thresholds are\n-- encoded here and should be verified before modification.\nWITH career_metrics AS (\n SELECT\n c.PlayerName,\n '/player_profiles/' || replace(replace(c.PlayerName, ' ', '%20'), '''', '%27') AS link,\n c.FirstSeason || ' - ' || c.LastSeason AS CareerSeasons,\n c.GamesPlayed,\n c.SeasonType,\n c.Opponent,\n c.SelectedOpponentCount,\n c.MinFieldGoalsMade,\n c.MinThreePointersAttempted,\n c.MinFreeThrowsAttempted,\n c.FieldGoalsMade,\n c.FieldGoalsAttempted,\n c.ThreePointersMade,\n c.ThreePointersAttempted,\n c.FreeThrowsMade,\n c.FreeThrowsAttempted,\n o.metric_type AS MetricType,\n o.metric_display_group AS MetricDisplayGroup,\n o.metric_value AS MetricValue,\n o.metric_label AS MetricLabel,\n o.table_title AS TableTitle,\n o.column_title AS ColumnTitle,\n CASE o.metric_value\n WHEN 'Total_GamesPlayed' THEN c.GamesPlayed * 1.0\n WHEN 'Total_GamesStarted' THEN c.GamesStarted * 1.0\n WHEN 'Total_TotalPoints' THEN c.TotalPoints * 1.0\n WHEN 'Total_TotalRebounds' THEN c.TotalRebounds * 1.0\n WHEN 'Total_OffensiveRebounds' THEN c.OffensiveRebounds * 1.0\n WHEN 'Total_DefensiveRebounds' THEN c.DefensiveRebounds * 1.0\n WHEN 'Total_Assists' THEN c.Assists * 1.0\n WHEN 'Total_Steals' THEN c.Steals * 1.0\n WHEN 'Total_Blocks' THEN c.Blocks * 1.0\n WHEN 'Total_ThreePointersMade' THEN c.ThreePointersMade * 1.0\n WHEN 'Total_FreeThrowsMade' THEN c.FreeThrowsMade * 1.0\n WHEN 'Total_Turnovers' THEN c.Turnovers * 1.0\n WHEN 'Total_FieldGoalsMade' THEN c.FieldGoalsMade * 1.0\n WHEN 'Total_FieldGoalsAttempted' THEN c.FieldGoalsAttempted * 1.0\n WHEN 'Total_ThreePointersAttempted' THEN c.ThreePointersAttempted * 1.0\n WHEN 'Total_FreeThrowsAttempted' THEN c.FreeThrowsAttempted * 1.0\n END AS CareerRecordValue\n FROM ${player_career_base} c\n CROSS JOIN ${selected_career_total_record_metric} o\n WHERE c.GamesPlayed >= 5\n),\n\ncareer_ranked AS (\n SELECT\n *,\n CAST(\n RANK() OVER (\n ORDER BY CareerRecordValue DESC NULLS LAST\n ) AS INT\n ) AS CareerRanking\n FROM career_metrics\n WHERE MetricDisplayGroup = 'Total'\n AND MetricValue = '${inputs.career_total_record_metric.value}'\n)\n\nSELECT *\nFROM career_ranked\nORDER BY CareerRanking\nLIMIT 100","compiled":true,"inline":true},{"id":"individual_career_per_game_ranking","compiledQueryString":"-- Ranks career per-game metrics after applying the same career games/attempt eligibility\n-- checks used by the total/percentage ranking.\nWITH career_metrics AS (\n SELECT\n c.PlayerName,\n '/player_profiles/' || replace(replace(c.PlayerName, ' ', '%20'), '''', '%27') AS link,\n c.FirstSeason || ' - ' || c.LastSeason AS CareerSeasons,\n c.GamesPlayed,\n c.SeasonType,\n c.Opponent,\n c.SelectedOpponentCount,\n c.MinFieldGoalsMade,\n c.MinThreePointersAttempted,\n c.MinFreeThrowsAttempted,\n c.FieldGoalsMade,\n c.FieldGoalsAttempted,\n c.ThreePointersMade,\n c.ThreePointersAttempted,\n c.FreeThrowsMade,\n c.FreeThrowsAttempted,\n o.metric_type AS MetricType,\n o.metric_display_group AS MetricDisplayGroup,\n o.metric_value AS MetricValue,\n o.metric_label AS MetricLabel,\n o.table_title AS TableTitle,\n o.column_title AS ColumnTitle,\n CASE o.metric_value\n WHEN 'Average_TotalPoints' THEN c.TotalPoints * 1.0 / NULLIF(c.GamesPlayed, 0)\n WHEN 'Average_TotalRebounds' THEN c.TotalRebounds * 1.0 / NULLIF(c.GamesPlayed, 0)\n WHEN 'Average_OffensiveRebounds' THEN c.OffensiveRebounds * 1.0 / NULLIF(c.GamesPlayed, 0)\n WHEN 'Average_DefensiveRebounds' THEN c.DefensiveRebounds * 1.0 / NULLIF(c.GamesPlayed, 0)\n WHEN 'Average_Assists' THEN c.Assists * 1.0 / NULLIF(c.GamesPlayed, 0)\n WHEN 'Average_Steals' THEN c.Steals * 1.0 / NULLIF(c.GamesPlayed, 0)\n WHEN 'Average_Blocks' THEN c.Blocks * 1.0 / NULLIF(c.GamesPlayed, 0)\n WHEN 'Average_ThreePointersMade' THEN c.ThreePointersMade * 1.0 / NULLIF(c.GamesPlayed, 0)\n WHEN 'Average_FreeThrowsMade' THEN c.FreeThrowsMade * 1.0 / NULLIF(c.GamesPlayed, 0)\n WHEN 'Average_Turnovers' THEN c.Turnovers * 1.0 / NULLIF(c.GamesPlayed, 0)\n WHEN 'Average_FieldGoalsMade' THEN c.FieldGoalsMade * 1.0 / NULLIF(c.GamesPlayed, 0)\n WHEN 'Average_FieldGoalsAttempted' THEN c.FieldGoalsAttempted * 1.0 / NULLIF(c.GamesPlayed, 0)\n WHEN 'Average_ThreePointersAttempted' THEN c.ThreePointersAttempted * 1.0 / NULLIF(c.GamesPlayed, 0)\n WHEN 'Average_FreeThrowsAttempted' THEN c.FreeThrowsAttempted * 1.0 / NULLIF(c.GamesPlayed, 0)\n WHEN 'Average_FieldGoalPercentage' THEN c.FieldGoalsMade * 1.0 / NULLIF(c.FieldGoalsAttempted, 0)\n WHEN 'Average_ThreePointerPercentage' THEN c.ThreePointersMade * 1.0 / NULLIF(c.ThreePointersAttempted, 0)\n WHEN 'Average_FreeThrowPercentage' THEN c.FreeThrowsMade * 1.0 / NULLIF(c.FreeThrowsAttempted, 0)\n END AS CareerRecordValue\n FROM (-- Aggregates filtered games to one player career row. Counting stats are summed and\n-- shooting values are calculated later from career made/attempt totals.\nSELECT\n p.CanonicalPlayerName AS PlayerName,\n p.CareerSeasonType AS SeasonType,\n\n CASE\n WHEN sc.SelectedOpponentCount = 0 THEN 'All Opponents'\n WHEN sc.SelectedOpponentCount = 1 THEN ANY_VALUE(p.Opponent)\n ELSE STRING_AGG(DISTINCT p.Opponent, ', ')\n END AS Opponent,\n\n sc.SelectedOpponentCount,\n\n MIN(CAST(LEFT(p.Season, 4) AS INT)) AS FirstSeason,\n MAX(CAST(RIGHT(p.Season, 4) AS INT)) AS LastSeason,\n\n SUM(p.GamesPlayed) AS GamesPlayed,\n SUM(p.GamesStarted) AS GamesStarted,\n SUM(p.TotalPoints) AS TotalPoints,\n SUM(p.TotalRebounds) AS TotalRebounds,\n SUM(p.OffensiveRebounds) AS OffensiveRebounds,\n -- Maintenance note: The defensive-rebound cutoff is encoded here to match other\n -- record sections; verify the intended historical availability rule before changing.\n SUM(CASE WHEN p.Season >= '1985' THEN p.DefensiveRebounds ELSE 0 END) AS DefensiveRebounds,\n SUM(p.Assists) AS Assists,\n SUM(p.Steals) AS Steals,\n SUM(p.Blocks) AS Blocks,\n SUM(p.ThreePointersMade) AS ThreePointersMade,\n SUM(p.FreeThrowsMade) AS FreeThrowsMade,\n SUM(p.Turnovers) AS Turnovers,\n SUM(p.FieldGoalsMade) AS FieldGoalsMade,\n SUM(p.FieldGoalsAttempted) AS FieldGoalsAttempted,\n SUM(p.ThreePointersAttempted) AS ThreePointersAttempted,\n SUM(p.FreeThrowsAttempted) AS FreeThrowsAttempted,\n (SUM(p.GamesPlayed)*5) AS MinFieldGoalsMade,\n (SUM(p.GamesPlayed)*2) AS MinThreePointersAttempted,\n (SUM(p.GamesPlayed)*2) AS MinFreeThrowsAttempted\nFROM (-- Applies the career section filters before aggregation so career totals, percentages,\n-- and per-game values share the same season-type and opponent context.\nSELECT\n p.PlayerName,\n p.Opponent,\n p.Season,\n p.GamesPlayed,\n p.GamesStarted,\n p.TotalPoints,\n p.TotalRebounds,\n p.OffensiveRebounds,\n p.DefensiveRebounds,\n p.Assists,\n p.Steals,\n p.Blocks,\n p.ThreePointersMade,\n p.FreeThrowsMade,\n p.Turnovers,\n p.FieldGoalsMade,\n p.FieldGoalsAttempted,\n p.ThreePointersAttempted,\n p.FreeThrowsAttempted,\n CASE\n WHEN p.PlayerName IN ('Amanda Frist','Amanda White') THEN 'Amanda Frist'\n WHEN p.PlayerName IN ('Julie Larson','Julie L. Brickley') THEN 'Julie Brickley'\n ELSE p.PlayerName\n END AS CanonicalPlayerName,\n CASE\n WHEN '${inputs.season_type_button}' IN ('All', 'All Season') THEN 'All'\n WHEN '${inputs.season_type_button}' = 'POST' THEN 'POST'\n ELSE p.SeasonType\n END AS CareerSeasonType\nFROM SPORTS_INFO_DW_REPORTING.vw_WBB_player_stats_by_game p\nWHERE p.IsClemson = 1\n AND (\n '${inputs.season_type_button}' IN ('All', 'All Season')\n OR (\n '${inputs.season_type_button}' = 'POST'\n AND p.SeasonType IN ('ACC', 'NCAA', 'NWIT', 'AIAW', 'WNIT')\n )\n OR p.SeasonType = '${inputs.season_type_button}'\n )) p\nCROSS JOIN (SELECT\n COUNT(*) AS SelectedOpponentCount\n FROM (-- Career records use their own selected-opponent context so career filters can differ\n-- from the game and season record sections.\nSELECT Opponent\nFROM (-- Shared opponent dropdown. The '__ALL__' row is preserved so filters can detect\n-- \"all opponents\" without building a separate query path.\nSELECT DISTINCT\n Opponent,\n OpponentLabel,\n sort_order\nFROM SPORTS_INFO_DW_REPORTING.opponent_options\nWHERE Opponent = '__ALL__'\n OR '${inputs.season_type_button}' IN ('All', 'All Season')\n OR (\n '${inputs.season_type_button}' = 'POST'\n AND SeasonType IN ('ACC', 'NCAA', 'AIAW', 'NWIT', 'WNIT')\n )\n OR SeasonType = '${inputs.season_type_button}'\nORDER BY sort_order, OpponentLabel)\nWHERE Opponent <> '__ALL__'\n AND '__ALL__' NOT IN ${inputs.opponent_dropdown_career.value}\n AND Opponent IN ${inputs.opponent_dropdown_career.value})) sc\nWHERE sc.SelectedOpponentCount = 0\n OR p.Opponent IN (\n SELECT Opponent\n FROM (-- Career records use their own selected-opponent context so career filters can differ\n-- from the game and season record sections.\nSELECT Opponent\nFROM (-- Shared opponent dropdown. The '__ALL__' row is preserved so filters can detect\n-- \"all opponents\" without building a separate query path.\nSELECT DISTINCT\n Opponent,\n OpponentLabel,\n sort_order\nFROM SPORTS_INFO_DW_REPORTING.opponent_options\nWHERE Opponent = '__ALL__'\n OR '${inputs.season_type_button}' IN ('All', 'All Season')\n OR (\n '${inputs.season_type_button}' = 'POST'\n AND SeasonType IN ('ACC', 'NCAA', 'AIAW', 'NWIT', 'WNIT')\n )\n OR SeasonType = '${inputs.season_type_button}'\nORDER BY sort_order, OpponentLabel)\nWHERE Opponent <> '__ALL__'\n AND '__ALL__' NOT IN ${inputs.opponent_dropdown_career.value}\n AND Opponent IN ${inputs.opponent_dropdown_career.value})\n )\nGROUP BY\n p.CanonicalPlayerName,\n p.CareerSeasonType,\n sc.SelectedOpponentCount) c\n CROSS JOIN (SELECT *\nFROM (-- Defines career total, percentage, and per-game dropdown metrics for the career section.\nSELECT *\nFROM (\n VALUES\n (1, 'Total', 'Total', 'Total_GamesPlayed', 'GP', 'Top 100 Career Games Played', 'No.'),\n (2, 'Total', 'Total', 'Total_GamesStarted', 'GS', 'Top 100 Career Games Started', 'No.'),\n (3, 'Total', 'Total', 'Total_TotalPoints', 'Points', 'Top 100 Career Total Points', 'No.'),\n (4, 'Total', 'Total', 'Total_TotalRebounds', 'Rebounds', 'Top 100 Career Total Rebounds', 'No.'),\n (5, 'Total', 'Total', 'Total_OffensiveRebounds', 'Offensive Rebounds', 'Top 100 Career Total Offensive Rebounds', 'No.'),\n (6, 'Total', 'Total', 'Total_DefensiveRebounds', 'Defensive Rebounds', 'Top 100 Career Total Defensive Rebounds', 'No.'),\n (7, 'Total', 'Total', 'Total_Assists', 'Assists', 'Top 100 Career Total Assists', 'No.'),\n (8, 'Total', 'Total', 'Total_Steals', 'Steals', 'Top 100 Career Total Steals', 'No.'),\n (9, 'Total', 'Total', 'Total_Blocks', 'Blocks', 'Top 100 Career Total Blocks', 'No.'),\n (10, 'Total', 'Total', 'Total_ThreePointersMade', 'Three Pointers Made', 'Top 100 Career Total Three Pointers Made', 'No.'),\n (11, 'Total', 'Total', 'Total_FreeThrowsMade', 'Free Throws Made', 'Top 100 Career Total Free Throws Made', 'No.'),\n (12, 'Total', 'Total', 'Total_Turnovers', 'TO', 'Top 100 Career Total Turnovers', 'No.'),\n (13, 'Total', 'Total', 'Total_FieldGoalsMade', 'Field Goals Made', 'Top 100 Career Total Field Goals Made', 'No.'),\n (14, 'Total', 'Total', 'Total_FieldGoalsAttempted', 'Field Goals Attempted', 'Top 100 Career Total Field Goals Attempted', 'No.'),\n (15, 'Total', 'Total', 'Total_ThreePointersAttempted', 'Three Pointers Attempted', 'Top 100 Career Total Three Pointers Attempted', 'No.'),\n (16, 'Total', 'Total', 'Total_FreeThrowsAttempted', 'Free Throws Attempted', 'Top 100 Career Total Free Throws Attempted', 'No.'),\n\n (17, 'PerGame', 'PerGame', 'Average_TotalPoints', 'Points', 'Top 100 Career Points Per Game', 'No.'),\n (18, 'PerGame', 'PerGame', 'Average_TotalRebounds', 'Rebounds', 'Top 100 Career Rebounds Per Game', 'No.'),\n (19, 'PerGame', 'PerGame', 'Average_OffensiveRebounds', 'Offensive Rebounds', 'Top 100 Career Offensive Rebounds Per Game', 'No.'),\n (20, 'PerGame', 'PerGame', 'Average_DefensiveRebounds', 'Defensive Rebounds', 'Top 100 Career Defensive Rebounds Per Game', 'No.'),\n (21, 'PerGame', 'PerGame', 'Average_Assists', 'Assists', 'Top 100 Career Assists Per Game', 'No.'),\n (22, 'PerGame', 'PerGame', 'Average_Steals', 'Steals', 'Top 100 Career Steals Per Game', 'No.'),\n (23, 'PerGame', 'PerGame', 'Average_Blocks', 'Blocks', 'Top 100 Career Blocks Per Game', 'No.'),\n (24, 'PerGame', 'PerGame', 'Average_ThreePointersMade', 'Three Pointers Made', 'Top 100 Career Three Pointers Made Per Game', 'No.'),\n (25, 'PerGame', 'PerGame', 'Average_FreeThrowsMade', 'Free Throws Made', 'Top 100 Career Free Throws Made Per Game', 'No.'),\n (26, 'PerGame', 'PerGame', 'Average_Turnovers', 'TO', 'Top 100 Career Turnovers Per Game', 'No.'),\n (27, 'PerGame', 'PerGame', 'Average_FieldGoalsMade', 'Field Goals Made', 'Top 100 Career Field Goals Made Per Game', 'No.'),\n (28, 'PerGame', 'PerGame', 'Average_FieldGoalsAttempted', 'Field Goals Attempted', 'Top 100 Career Field Goals Attempted Per Game', 'No.'),\n (29, 'PerGame', 'PerGame', 'Average_ThreePointersAttempted', 'Three Pointers Attempted', 'Top 100 Career Three Pointers Attempted Per Game', 'No.'),\n (30, 'PerGame', 'PerGame', 'Average_FreeThrowsAttempted', 'Free Throws Attempted', 'Top 100 Career Free Throws Attempted Per Game', 'No.'),\n (31, 'PerGame', 'PerGame', 'Average_FieldGoalPercentage', 'Field Goal Percentage', 'Top 100 Career Field Goal Percentage', 'No.'),\n (32, 'PerGame', 'PerGame', 'Average_ThreePointerPercentage', 'Three Pointer Percentage', 'Top 100 Career Three Point Percentage', 'No.'),\n (33, 'PerGame', 'PerGame', 'Average_FreeThrowPercentage', 'Free Throw Percentage', 'Top 100 Career Free Throw Percentage', 'No.')\n) AS t(metric_order, metric_type, metric_display_group, metric_value, metric_label, table_title, column_title))\nWHERE metric_value = '${inputs.career_per_game_record_metric.value}') o\n WHERE c.GamesPlayed >= 5\n AND (\n o.metric_value != 'Average_FieldGoalPercentage'\n OR c.FieldGoalsAttempted >= 200\n )\n AND (\n o.metric_value != 'Average_ThreePointerPercentage'\n OR c.ThreePointersAttempted >= c.MinThreePointersAttempted\n )\n AND (\n o.metric_value != 'Average_FreeThrowPercentage'\n OR c.FreeThrowsAttempted >= c.MinFreeThrowsAttempted\n )\n),\n\ncareer_ranked AS (\n SELECT\n *,\n CAST(\n RANK() OVER (\n ORDER BY CareerRecordValue DESC NULLS LAST\n ) AS INT\n ) AS CareerRanking\n FROM career_metrics\n WHERE MetricDisplayGroup = 'PerGame'\n AND MetricValue = '${inputs.career_per_game_record_metric.value}'\n)\n\nSELECT *\nFROM career_ranked\nORDER BY CareerRanking\nLIMIT 100","inputQueryString":"-- Ranks career per-game metrics after applying the same career games/attempt eligibility\n-- checks used by the total/percentage ranking.\nWITH career_metrics AS (\n SELECT\n c.PlayerName,\n '/player_profiles/' || replace(replace(c.PlayerName, ' ', '%20'), '''', '%27') AS link,\n c.FirstSeason || ' - ' || c.LastSeason AS CareerSeasons,\n c.GamesPlayed,\n c.SeasonType,\n c.Opponent,\n c.SelectedOpponentCount,\n c.MinFieldGoalsMade,\n c.MinThreePointersAttempted,\n c.MinFreeThrowsAttempted,\n c.FieldGoalsMade,\n c.FieldGoalsAttempted,\n c.ThreePointersMade,\n c.ThreePointersAttempted,\n c.FreeThrowsMade,\n c.FreeThrowsAttempted,\n o.metric_type AS MetricType,\n o.metric_display_group AS MetricDisplayGroup,\n o.metric_value AS MetricValue,\n o.metric_label AS MetricLabel,\n o.table_title AS TableTitle,\n o.column_title AS ColumnTitle,\n CASE o.metric_value\n WHEN 'Average_TotalPoints' THEN c.TotalPoints * 1.0 / NULLIF(c.GamesPlayed, 0)\n WHEN 'Average_TotalRebounds' THEN c.TotalRebounds * 1.0 / NULLIF(c.GamesPlayed, 0)\n WHEN 'Average_OffensiveRebounds' THEN c.OffensiveRebounds * 1.0 / NULLIF(c.GamesPlayed, 0)\n WHEN 'Average_DefensiveRebounds' THEN c.DefensiveRebounds * 1.0 / NULLIF(c.GamesPlayed, 0)\n WHEN 'Average_Assists' THEN c.Assists * 1.0 / NULLIF(c.GamesPlayed, 0)\n WHEN 'Average_Steals' THEN c.Steals * 1.0 / NULLIF(c.GamesPlayed, 0)\n WHEN 'Average_Blocks' THEN c.Blocks * 1.0 / NULLIF(c.GamesPlayed, 0)\n WHEN 'Average_ThreePointersMade' THEN c.ThreePointersMade * 1.0 / NULLIF(c.GamesPlayed, 0)\n WHEN 'Average_FreeThrowsMade' THEN c.FreeThrowsMade * 1.0 / NULLIF(c.GamesPlayed, 0)\n WHEN 'Average_Turnovers' THEN c.Turnovers * 1.0 / NULLIF(c.GamesPlayed, 0)\n WHEN 'Average_FieldGoalsMade' THEN c.FieldGoalsMade * 1.0 / NULLIF(c.GamesPlayed, 0)\n WHEN 'Average_FieldGoalsAttempted' THEN c.FieldGoalsAttempted * 1.0 / NULLIF(c.GamesPlayed, 0)\n WHEN 'Average_ThreePointersAttempted' THEN c.ThreePointersAttempted * 1.0 / NULLIF(c.GamesPlayed, 0)\n WHEN 'Average_FreeThrowsAttempted' THEN c.FreeThrowsAttempted * 1.0 / NULLIF(c.GamesPlayed, 0)\n WHEN 'Average_FieldGoalPercentage' THEN c.FieldGoalsMade * 1.0 / NULLIF(c.FieldGoalsAttempted, 0)\n WHEN 'Average_ThreePointerPercentage' THEN c.ThreePointersMade * 1.0 / NULLIF(c.ThreePointersAttempted, 0)\n WHEN 'Average_FreeThrowPercentage' THEN c.FreeThrowsMade * 1.0 / NULLIF(c.FreeThrowsAttempted, 0)\n END AS CareerRecordValue\n FROM ${player_career_base} c\n CROSS JOIN ${selected_career_per_game_record_metric} o\n WHERE c.GamesPlayed >= 5\n AND (\n o.metric_value != 'Average_FieldGoalPercentage'\n OR c.FieldGoalsAttempted >= 200\n )\n AND (\n o.metric_value != 'Average_ThreePointerPercentage'\n OR c.ThreePointersAttempted >= c.MinThreePointersAttempted\n )\n AND (\n o.metric_value != 'Average_FreeThrowPercentage'\n OR c.FreeThrowsAttempted >= c.MinFreeThrowsAttempted\n )\n),\n\ncareer_ranked AS (\n SELECT\n *,\n CAST(\n RANK() OVER (\n ORDER BY CareerRecordValue DESC NULLS LAST\n ) AS INT\n ) AS CareerRanking\n FROM career_metrics\n WHERE MetricDisplayGroup = 'PerGame'\n AND MetricValue = '${inputs.career_per_game_record_metric.value}'\n)\n\nSELECT *\nFROM career_ranked\nORDER BY CareerRanking\nLIMIT 100","compiled":true,"inline":true},{"id":"opponent_single_game_selected_opponents","compiledQueryString":"-- Opponent record filters are separate from Clemson filters so each section can maintain\n-- its own selected opponent state.\nSELECT Opponent\nFROM (-- Shared opponent dropdown. The '__ALL__' row is preserved so filters can detect\n-- \"all opponents\" without building a separate query path.\nSELECT DISTINCT\n Opponent,\n OpponentLabel,\n sort_order\nFROM SPORTS_INFO_DW_REPORTING.opponent_options\nWHERE Opponent = '__ALL__'\n OR '${inputs.season_type_button}' IN ('All', 'All Season')\n OR (\n '${inputs.season_type_button}' = 'POST'\n AND SeasonType IN ('ACC', 'NCAA', 'AIAW', 'NWIT', 'WNIT')\n )\n OR SeasonType = '${inputs.season_type_button}'\nORDER BY sort_order, OpponentLabel)\nWHERE Opponent <> '__ALL__'\n AND '__ALL__' NOT IN ${inputs.opponent_dropdown_opp_game.value}\n AND Opponent IN ${inputs.opponent_dropdown_opp_game.value}","inputQueryString":"-- Opponent record filters are separate from Clemson filters so each section can maintain\n-- its own selected opponent state.\nSELECT Opponent\nFROM ${opponent_options}\nWHERE Opponent <> '__ALL__'\n AND '__ALL__' NOT IN ${inputs.opponent_dropdown_opp_game.value}\n AND Opponent IN ${inputs.opponent_dropdown_opp_game.value}","compiled":true,"inline":true},{"id":"opponent_single_game_selection_context","compiledQueryString":"SELECT\n COUNT(*) AS SelectedOpponentCount\nFROM (-- Opponent record filters are separate from Clemson filters so each section can maintain\n-- its own selected opponent state.\nSELECT Opponent\nFROM (-- Shared opponent dropdown. The '__ALL__' row is preserved so filters can detect\n-- \"all opponents\" without building a separate query path.\nSELECT DISTINCT\n Opponent,\n OpponentLabel,\n sort_order\nFROM SPORTS_INFO_DW_REPORTING.opponent_options\nWHERE Opponent = '__ALL__'\n OR '${inputs.season_type_button}' IN ('All', 'All Season')\n OR (\n '${inputs.season_type_button}' = 'POST'\n AND SeasonType IN ('ACC', 'NCAA', 'AIAW', 'NWIT', 'WNIT')\n )\n OR SeasonType = '${inputs.season_type_button}'\nORDER BY sort_order, OpponentLabel)\nWHERE Opponent <> '__ALL__'\n AND '__ALL__' NOT IN ${inputs.opponent_dropdown_opp_game.value}\n AND Opponent IN ${inputs.opponent_dropdown_opp_game.value})","inputQueryString":"SELECT\n COUNT(*) AS SelectedOpponentCount\nFROM ${opponent_single_game_selected_opponents}","compiled":true,"inline":true},{"id":"selected_single_game_metric_opp","compiledQueryString":"-- Builds the page title for the selected opponent single-game metric.\nSELECT\n metric_value,\n metric_label,\n CASE\n WHEN metric_value = 'PerfectFreeThrowGame' THEN metric_label\n ELSE 'Opponent Single Game Record for ' || metric_label\n END AS table_title,\n 'No.' AS column_title\nFROM (-- Defines the metrics available in the single-game dropdown. The metric_value entries\n-- are later matched to source columns in the ranking query.\nSELECT *\nFROM (\n VALUES\n ('TotalPoints', 'Points'),\n ('TotalRebounds', 'Rebounds'),\n ('OffensiveRebounds', 'Offensive Rebounds'),\n ('DefensiveRebounds', 'Defensive Rebounds'),\n ('Assists', 'Assists'),\n ('Steals', 'Steals'),\n ('Blocks', 'Blocks'),\n ('ThreePointersMade', 'Three Pointers Made'),\n ('FreeThrowsMade', 'Free Throws Made'),\n ('Turnovers', 'Turnovers'),\n ('FieldGoalsMade', 'Field Goals Made'),\n ('FieldGoalsAttempted', 'Field Goals Attempted'),\n ('ThreePointersAttempted', 'Three Pointers Attempted'),\n ('FreeThrowsAttempted', 'Free Throws Attempted'),\n ('FieldGoalPercentage', 'Field Goal Percentage'),\n ('ThreePointerPercentage', 'Three Pointer Percentage'),\n ('PerfectFreeThrowGame', 'Perfect Free Throw Games')\n) AS t(metric_value, metric_label))\nWHERE metric_value = '${inputs.opponent_single_game_record_metric.value}'","inputQueryString":"-- Builds the page title for the selected opponent single-game metric.\nSELECT\n metric_value,\n metric_label,\n CASE\n WHEN metric_value = 'PerfectFreeThrowGame' THEN metric_label\n ELSE 'Opponent Single Game Record for ' || metric_label\n END AS table_title,\n 'No.' AS column_title\nFROM ${single_game_metric_options}\nWHERE metric_value = '${inputs.opponent_single_game_record_metric.value}'","compiled":true,"inline":true},{"id":"game_opponent_ranking","compiledQueryString":"-- Builds opponent single-game leaderboards against Clemson. RANK handles ties, and\n-- IsClemson = 0 keeps the source limited to opponent player rows.\nWITH selection_context AS (\n SELECT *\n FROM (SELECT\n COUNT(*) AS SelectedOpponentCount\nFROM (-- Opponent record filters are separate from Clemson filters so each section can maintain\n-- its own selected opponent state.\nSELECT Opponent\nFROM (-- Shared opponent dropdown. The '__ALL__' row is preserved so filters can detect\n-- \"all opponents\" without building a separate query path.\nSELECT DISTINCT\n Opponent,\n OpponentLabel,\n sort_order\nFROM SPORTS_INFO_DW_REPORTING.opponent_options\nWHERE Opponent = '__ALL__'\n OR '${inputs.season_type_button}' IN ('All', 'All Season')\n OR (\n '${inputs.season_type_button}' = 'POST'\n AND SeasonType IN ('ACC', 'NCAA', 'AIAW', 'NWIT', 'WNIT')\n )\n OR SeasonType = '${inputs.season_type_button}'\nORDER BY sort_order, OpponentLabel)\nWHERE Opponent <> '__ALL__'\n AND '__ALL__' NOT IN ${inputs.opponent_dropdown_opp_game.value}\n AND Opponent IN ${inputs.opponent_dropdown_opp_game.value}))\n),\n\nsingle_game_stats AS (\n -- Percentages use attempt minimums before ranking; perfect free throw games require\n -- makes to equal attempts with at least the encoded attempt minimum.\n SELECT\n CASE\n WHEN PlayerName IN ('Amanda Frist','Amanda White') THEN 'Amanda Frist'\n WHEN PlayerName IN ('Julie Larson','Julie L. Brickley') THEN 'Julie Brickley'\n ELSE PlayerName END AS PlayerName,\n Season,\n GameDate,\n TeamName,\n\n SUM(FieldGoalsMade) AS FieldGoalsMade,\n SUM(FieldGoalsAttempted) AS FieldGoalsAttempted,\n SUM(ThreePointersMade) AS ThreePointersMade,\n SUM(ThreePointersAttempted) AS ThreePointersAttempted,\n SUM(FreeThrowsMade) AS FreeThrowsMade,\n SUM(FreeThrowsAttempted) AS FreeThrowsAttempted,\n\n CASE\n WHEN '${inputs.opponent_single_game_record_metric.value}' = 'FieldGoalPercentage'\n THEN\n CASE\n WHEN SUM(FieldGoalsAttempted) >= 10\n THEN SUM(FieldGoalsMade) * 1.0 / NULLIF(SUM(FieldGoalsAttempted), 0)\n ELSE NULL\n END\n\n WHEN '${inputs.opponent_single_game_record_metric.value}' = 'ThreePointerPercentage'\n THEN\n CASE\n WHEN SUM(ThreePointersAttempted) >= 10\n THEN SUM(ThreePointersMade) * 1.0 / NULLIF(SUM(ThreePointersAttempted), 0)\n ELSE NULL\n END\n\n WHEN '${inputs.opponent_single_game_record_metric.value}' = 'FreeThrowPercentage'\n THEN\n CASE\n WHEN SUM(FreeThrowsAttempted) >= 40\n THEN SUM(FreeThrowsMade) * 1.0 / NULLIF(SUM(FreeThrowsAttempted), 0)\n ELSE NULL\n END\n\n WHEN '${inputs.opponent_single_game_record_metric.value}' = 'PerfectFreeThrowGame'\n THEN\n CASE\n WHEN SUM(FreeThrowsAttempted) >= 10\n AND SUM(FreeThrowsMade) = SUM(FreeThrowsAttempted)\n THEN SUM(FreeThrowsAttempted)\n ELSE NULL\n END\n\n ELSE ANY_VALUE(${inputs.opponent_single_game_record_metric.value})\n END AS SingleGameStatisticOpp\n FROM (\n SELECT\n *,\n CAST(NULL AS DOUBLE) AS PerfectFreeThrowGame\n FROM SPORTS_INFO_DW_REPORTING.vw_WBB_player_stats_by_game\n ) stats\n CROSS JOIN selection_context sc\n WHERE IsClemson = 0\n AND CAST(LEFT(Season, 4) AS INT) >= 1976\n AND (\n '${inputs.season_type_button}' IN ('All', 'All Season')\n OR (\n '${inputs.season_type_button}' = 'POST'\n AND SeasonType IN ('ACC', 'NCAA', 'AIAW', 'NWIT', 'WNIT')\n )\n OR SeasonType = '${inputs.season_type_button}'\n )\n AND (\n sc.SelectedOpponentCount = 0\n OR TeamName IN (\n SELECT Opponent\n FROM (-- Opponent record filters are separate from Clemson filters so each section can maintain\n-- its own selected opponent state.\nSELECT Opponent\nFROM (-- Shared opponent dropdown. The '__ALL__' row is preserved so filters can detect\n-- \"all opponents\" without building a separate query path.\nSELECT DISTINCT\n Opponent,\n OpponentLabel,\n sort_order\nFROM SPORTS_INFO_DW_REPORTING.opponent_options\nWHERE Opponent = '__ALL__'\n OR '${inputs.season_type_button}' IN ('All', 'All Season')\n OR (\n '${inputs.season_type_button}' = 'POST'\n AND SeasonType IN ('ACC', 'NCAA', 'AIAW', 'NWIT', 'WNIT')\n )\n OR SeasonType = '${inputs.season_type_button}'\nORDER BY sort_order, OpponentLabel)\nWHERE Opponent <> '__ALL__'\n AND '__ALL__' NOT IN ${inputs.opponent_dropdown_opp_game.value}\n AND Opponent IN ${inputs.opponent_dropdown_opp_game.value})\n )\n )\n GROUP BY PlayerName, Season, GameDate, TeamName\n HAVING\n '${inputs.opponent_single_game_record_metric.value}' <> 'PerfectFreeThrowGame'\n OR (\n SUM(FreeThrowsAttempted) >= 10\n AND SUM(FreeThrowsMade) = SUM(FreeThrowsAttempted)\n )\n),\n\nranked AS (\n -- Highest opponent values rank first for the selected metric.\n SELECT\n *,\n RANK() OVER (\n ORDER BY SingleGameStatisticOpp DESC NULLS LAST\n ) AS OpponentRanking\n FROM single_game_stats\n)\n\nSELECT *\nFROM ranked\nORDER BY OpponentRanking\nLIMIT 100","inputQueryString":"-- Builds opponent single-game leaderboards against Clemson. RANK handles ties, and\n-- IsClemson = 0 keeps the source limited to opponent player rows.\nWITH selection_context AS (\n SELECT *\n FROM ${opponent_single_game_selection_context}\n),\n\nsingle_game_stats AS (\n -- Percentages use attempt minimums before ranking; perfect free throw games require\n -- makes to equal attempts with at least the encoded attempt minimum.\n SELECT\n CASE\n WHEN PlayerName IN ('Amanda Frist','Amanda White') THEN 'Amanda Frist'\n WHEN PlayerName IN ('Julie Larson','Julie L. Brickley') THEN 'Julie Brickley'\n ELSE PlayerName END AS PlayerName,\n Season,\n GameDate,\n TeamName,\n\n SUM(FieldGoalsMade) AS FieldGoalsMade,\n SUM(FieldGoalsAttempted) AS FieldGoalsAttempted,\n SUM(ThreePointersMade) AS ThreePointersMade,\n SUM(ThreePointersAttempted) AS ThreePointersAttempted,\n SUM(FreeThrowsMade) AS FreeThrowsMade,\n SUM(FreeThrowsAttempted) AS FreeThrowsAttempted,\n\n CASE\n WHEN '${inputs.opponent_single_game_record_metric.value}' = 'FieldGoalPercentage'\n THEN\n CASE\n WHEN SUM(FieldGoalsAttempted) >= 10\n THEN SUM(FieldGoalsMade) * 1.0 / NULLIF(SUM(FieldGoalsAttempted), 0)\n ELSE NULL\n END\n\n WHEN '${inputs.opponent_single_game_record_metric.value}' = 'ThreePointerPercentage'\n THEN\n CASE\n WHEN SUM(ThreePointersAttempted) >= 10\n THEN SUM(ThreePointersMade) * 1.0 / NULLIF(SUM(ThreePointersAttempted), 0)\n ELSE NULL\n END\n\n WHEN '${inputs.opponent_single_game_record_metric.value}' = 'FreeThrowPercentage'\n THEN\n CASE\n WHEN SUM(FreeThrowsAttempted) >= 40\n THEN SUM(FreeThrowsMade) * 1.0 / NULLIF(SUM(FreeThrowsAttempted), 0)\n ELSE NULL\n END\n\n WHEN '${inputs.opponent_single_game_record_metric.value}' = 'PerfectFreeThrowGame'\n THEN\n CASE\n WHEN SUM(FreeThrowsAttempted) >= 10\n AND SUM(FreeThrowsMade) = SUM(FreeThrowsAttempted)\n THEN SUM(FreeThrowsAttempted)\n ELSE NULL\n END\n\n ELSE ANY_VALUE(${inputs.opponent_single_game_record_metric.value})\n END AS SingleGameStatisticOpp\n FROM (\n SELECT\n *,\n CAST(NULL AS DOUBLE) AS PerfectFreeThrowGame\n FROM SPORTS_INFO_DW_REPORTING.vw_WBB_player_stats_by_game\n ) stats\n CROSS JOIN selection_context sc\n WHERE IsClemson = 0\n AND CAST(LEFT(Season, 4) AS INT) >= 1976\n AND (\n '${inputs.season_type_button}' IN ('All', 'All Season')\n OR (\n '${inputs.season_type_button}' = 'POST'\n AND SeasonType IN ('ACC', 'NCAA', 'AIAW', 'NWIT', 'WNIT')\n )\n OR SeasonType = '${inputs.season_type_button}'\n )\n AND (\n sc.SelectedOpponentCount = 0\n OR TeamName IN (\n SELECT Opponent\n FROM ${opponent_single_game_selected_opponents}\n )\n )\n GROUP BY PlayerName, Season, GameDate, TeamName\n HAVING\n '${inputs.opponent_single_game_record_metric.value}' <> 'PerfectFreeThrowGame'\n OR (\n SUM(FreeThrowsAttempted) >= 10\n AND SUM(FreeThrowsMade) = SUM(FreeThrowsAttempted)\n )\n),\n\nranked AS (\n -- Highest opponent values rank first for the selected metric.\n SELECT\n *,\n RANK() OVER (\n ORDER BY SingleGameStatisticOpp DESC NULLS LAST\n ) AS OpponentRanking\n FROM single_game_stats\n)\n\nSELECT *\nFROM ranked\nORDER BY OpponentRanking\nLIMIT 100","compiled":true,"inline":true}]}

Individual Records

Game Records

Season Records

Career Records

Opponent Records