{"queries":[{"id":"single_season_impact","compiledQueryString":"WITH Points AS (SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n Season,\n SUM(Score) TotalPoints,\n 'All' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event <> 'ALL-AROUND'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n Season,\n SUM(Score) TotalPoints,\n 'Vault' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'VAULT'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n Season,\n SUM(Score) TotalPoints,\n 'Bars' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BARS'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n Season,\n SUM(Score) TotalPoints,\n 'Beam' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BEAM'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n Season,\n SUM(Score) TotalPoints,\n 'Floor' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'FLOOR'\n GROUP BY PlayerName, Season\n )\n, Routines AS (SELECT PlayerName,\n Season,\n COUNT(Event) Routines,\n 'All' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event <> 'ALL-AROUND'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT PlayerName,\n Season,\n COUNT(Event) Routines,\n 'Vault' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'VAULT'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT PlayerName,\n Season,\n COUNT(Event) Routines,\n 'Bars' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BARS'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT PlayerName,\n Season,\n COUNT(Event) Routines,\n 'Beam' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BEAM'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT PlayerName,\n Season,\n COUNT(Event) Routines,\n 'Floor' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'FLOOR'\n GROUP BY PlayerName, Season\n )\n\nSELECT P.Event,\n P.Rank,\n P.PlayerName,\n P.Season,\n TotalPoints,\n Routines,\n TotalPoints / Routines Average\nFROM Points P\nLEFT JOIN Routines R\nON P.PlayerName = R.PlayerName AND P.Season = R.Season AND P.Event = R.Event","inputQueryString":"WITH Points AS (SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n Season,\n SUM(Score) TotalPoints,\n 'All' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event <> 'ALL-AROUND'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n Season,\n SUM(Score) TotalPoints,\n 'Vault' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'VAULT'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n Season,\n SUM(Score) TotalPoints,\n 'Bars' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BARS'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n Season,\n SUM(Score) TotalPoints,\n 'Beam' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BEAM'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n Season,\n SUM(Score) TotalPoints,\n 'Floor' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'FLOOR'\n GROUP BY PlayerName, Season\n )\n, Routines AS (SELECT PlayerName,\n Season,\n COUNT(Event) Routines,\n 'All' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event <> 'ALL-AROUND'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT PlayerName,\n Season,\n COUNT(Event) Routines,\n 'Vault' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'VAULT'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT PlayerName,\n Season,\n COUNT(Event) Routines,\n 'Bars' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BARS'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT PlayerName,\n Season,\n COUNT(Event) Routines,\n 'Beam' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BEAM'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT PlayerName,\n Season,\n COUNT(Event) Routines,\n 'Floor' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'FLOOR'\n GROUP BY PlayerName, Season\n )\n\nSELECT P.Event,\n P.Rank,\n P.PlayerName,\n P.Season,\n TotalPoints,\n Routines,\n TotalPoints / Routines Average\nFROM Points P\nLEFT JOIN Routines R\nON P.PlayerName = R.PlayerName AND P.Season = R.Season AND P.Event = R.Event","compiled":false,"inline":false},{"id":"career_impact","compiledQueryString":"WITH Points AS (SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n SUM(Score) TotalPoints,\n 'All' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event <> 'ALL-AROUND'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n SUM(Score) TotalPoints,\n 'Vault' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'VAULT'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n SUM(Score) TotalPoints,\n 'Bars' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BARS'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n SUM(Score) TotalPoints,\n 'Beam' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BEAM'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n SUM(Score) TotalPoints,\n 'Floor' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'FLOOR'\n GROUP BY PlayerName\n )\n, Routines AS (SELECT PlayerName,\n COUNT(Event) Routines,\n 'All' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event <> 'ALL-AROUND'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT PlayerName,\n COUNT(Event) Routines,\n 'Vault' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'VAULT'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT PlayerName,\n COUNT(Event) Routines,\n 'Bars' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BARS'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT PlayerName,\n COUNT(Event) Routines,\n 'Beam' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BEAM'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT PlayerName,\n COUNT(Event) Routines,\n 'Floor' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'FLOOR'\n GROUP BY PlayerName\n )\n\nSELECT P.Event,\n P.Rank,\n P.PlayerName,\n TotalPoints,\n Routines,\n TotalPoints / Routines Average\nFROM Points P\nLEFT JOIN Routines R\nON P.PlayerName = R.PlayerName AND P.Event = R.Event","inputQueryString":"WITH Points AS (SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n SUM(Score) TotalPoints,\n 'All' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event <> 'ALL-AROUND'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n SUM(Score) TotalPoints,\n 'Vault' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'VAULT'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n SUM(Score) TotalPoints,\n 'Bars' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BARS'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n SUM(Score) TotalPoints,\n 'Beam' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BEAM'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n SUM(Score) TotalPoints,\n 'Floor' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'FLOOR'\n GROUP BY PlayerName\n )\n, Routines AS (SELECT PlayerName,\n COUNT(Event) Routines,\n 'All' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event <> 'ALL-AROUND'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT PlayerName,\n COUNT(Event) Routines,\n 'Vault' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'VAULT'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT PlayerName,\n COUNT(Event) Routines,\n 'Bars' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BARS'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT PlayerName,\n COUNT(Event) Routines,\n 'Beam' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BEAM'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT PlayerName,\n COUNT(Event) Routines,\n 'Floor' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'FLOOR'\n GROUP BY PlayerName\n )\n\nSELECT P.Event,\n P.Rank,\n P.PlayerName,\n TotalPoints,\n Routines,\n TotalPoints / Routines Average\nFROM Points P\nLEFT JOIN Routines R\nON P.PlayerName = R.PlayerName AND P.Event = R.Event","compiled":false,"inline":false},{"id":"player_stats_all","compiledQueryString":"SELECT RANK() OVER (ORDER BY Score DESC) Rank, PlayerName, Season, Date, MeetName, Event, Score, Place, \n CASE WHEN IsConference = 'true' THEN '/Atlantic_Coast_Conference_logo.png'\n WHEN MeetName LIKE '%ACC%' THEN '/Atlantic_Coast_Conference_logo.png'\n ELSE '/Non-Conference.png' END IsConference, CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner, '/gymnast_profiles/' || PlayerName as link\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE Event <> 'ALL-AROUND' AND School = 'Clemson' AND Season IN ${inputs.Season.value} AND SeasonType IN ${inputs.SeasonType.value}","inputQueryString":"SELECT RANK() OVER (ORDER BY Score DESC) Rank, PlayerName, Season, Date, MeetName, Event, Score, Place, \n CASE WHEN IsConference = 'true' THEN '/Atlantic_Coast_Conference_logo.png'\n WHEN MeetName LIKE '%ACC%' THEN '/Atlantic_Coast_Conference_logo.png'\n ELSE '/Non-Conference.png' END IsConference, CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner, '/gymnast_profiles/' || PlayerName as link\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE Event <> 'ALL-AROUND' AND School = 'Clemson' AND Season IN ${inputs.Season.value} AND SeasonType IN ${inputs.SeasonType.value}","compiled":false,"inline":true},{"id":"player_stats_all_around","compiledQueryString":"SELECT RANK() OVER (ORDER BY Score DESC) Rank, PlayerName, Season, Date, MeetName, Score, Place, \n CASE WHEN IsConference = 'true' THEN '/Atlantic_Coast_Conference_logo.png' \n WHEN MeetName LIKE '%ACC%' THEN '/Atlantic_Coast_Conference_logo.png'\n ELSE '/Non-Conference.png' END IsConference, CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner, '/gymnast_profiles/' || PlayerName as link\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE Event = 'ALL-AROUND' AND School = 'Clemson' AND Season IN ${inputs.Season.value} AND SeasonType IN ${inputs.SeasonType.value}","inputQueryString":"SELECT RANK() OVER (ORDER BY Score DESC) Rank, PlayerName, Season, Date, MeetName, Score, Place, \n CASE WHEN IsConference = 'true' THEN '/Atlantic_Coast_Conference_logo.png' \n WHEN MeetName LIKE '%ACC%' THEN '/Atlantic_Coast_Conference_logo.png'\n ELSE '/Non-Conference.png' END IsConference, CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner, '/gymnast_profiles/' || PlayerName as link\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE Event = 'ALL-AROUND' AND School = 'Clemson' AND Season IN ${inputs.Season.value} AND SeasonType IN ${inputs.SeasonType.value}","compiled":false,"inline":true},{"id":"player_stats_vault","compiledQueryString":"SELECT RANK() OVER (ORDER BY Score DESC) Rank, PlayerName, Season, Date, MeetName, Score, Place, \n CASE WHEN IsConference = 'true' THEN '/Atlantic_Coast_Conference_logo.png' \n WHEN MeetName LIKE '%ACC%' THEN '/Atlantic_Coast_Conference_logo.png'\n ELSE '/Non-Conference.png' END IsConference, CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner, '/gymnast_profiles/' || PlayerName as link\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE Event = 'VAULT' AND School = 'Clemson' AND Season IN ${inputs.Season.value} AND SeasonType IN ${inputs.SeasonType.value}","inputQueryString":"SELECT RANK() OVER (ORDER BY Score DESC) Rank, PlayerName, Season, Date, MeetName, Score, Place, \n CASE WHEN IsConference = 'true' THEN '/Atlantic_Coast_Conference_logo.png' \n WHEN MeetName LIKE '%ACC%' THEN '/Atlantic_Coast_Conference_logo.png'\n ELSE '/Non-Conference.png' END IsConference, CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner, '/gymnast_profiles/' || PlayerName as link\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE Event = 'VAULT' AND School = 'Clemson' AND Season IN ${inputs.Season.value} AND SeasonType IN ${inputs.SeasonType.value}","compiled":false,"inline":true},{"id":"player_stats_bars","compiledQueryString":"SELECT RANK() OVER (ORDER BY Score DESC) Rank, PlayerName, Season, Date, MeetName, Score, Place, \n CASE WHEN IsConference = 'true' THEN '/Atlantic_Coast_Conference_logo.png'\n WHEN MeetName LIKE '%ACC%' THEN '/Atlantic_Coast_Conference_logo.png' \n ELSE '/Non-Conference.png' END IsConference, CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner, '/gymnast_profiles/' || PlayerName as link\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE Event = 'BARS' AND School = 'Clemson' AND Season IN ${inputs.Season.value} AND SeasonType IN ${inputs.SeasonType.value}","inputQueryString":"SELECT RANK() OVER (ORDER BY Score DESC) Rank, PlayerName, Season, Date, MeetName, Score, Place, \n CASE WHEN IsConference = 'true' THEN '/Atlantic_Coast_Conference_logo.png'\n WHEN MeetName LIKE '%ACC%' THEN '/Atlantic_Coast_Conference_logo.png' \n ELSE '/Non-Conference.png' END IsConference, CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner, '/gymnast_profiles/' || PlayerName as link\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE Event = 'BARS' AND School = 'Clemson' AND Season IN ${inputs.Season.value} AND SeasonType IN ${inputs.SeasonType.value}","compiled":false,"inline":true},{"id":"player_stats_beam","compiledQueryString":"SELECT RANK() OVER (ORDER BY Score DESC) Rank, PlayerName, Season, Date, MeetName, Score, Place, \n CASE WHEN IsConference = 'true' THEN '/Atlantic_Coast_Conference_logo.png' \n WHEN MeetName LIKE '%ACC%' THEN '/Atlantic_Coast_Conference_logo.png'\n ELSE '/Non-Conference.png' END IsConference, CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner, '/gymnast_profiles/' || PlayerName as link\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE Event = 'BEAM' AND School = 'Clemson' AND Season IN ${inputs.Season.value} AND SeasonType IN ${inputs.SeasonType.value}","inputQueryString":"SELECT RANK() OVER (ORDER BY Score DESC) Rank, PlayerName, Season, Date, MeetName, Score, Place, \n CASE WHEN IsConference = 'true' THEN '/Atlantic_Coast_Conference_logo.png' \n WHEN MeetName LIKE '%ACC%' THEN '/Atlantic_Coast_Conference_logo.png'\n ELSE '/Non-Conference.png' END IsConference, CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner, '/gymnast_profiles/' || PlayerName as link\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE Event = 'BEAM' AND School = 'Clemson' AND Season IN ${inputs.Season.value} AND SeasonType IN ${inputs.SeasonType.value}","compiled":false,"inline":true},{"id":"player_stats_floor","compiledQueryString":"SELECT RANK() OVER (ORDER BY Score DESC) Rank, PlayerName, Season, Date, MeetName, Score, Place, \n CASE WHEN IsConference = 'true' THEN '/Atlantic_Coast_Conference_logo.png'\n WHEN MeetName LIKE '%ACC%' THEN '/Atlantic_Coast_Conference_logo.png' \n ELSE '/Non-Conference.png' END IsConference, CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner, '/gymnast_profiles/' || PlayerName as link\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE Event = 'FLOOR' AND School = 'Clemson' AND Season IN ${inputs.Season.value} AND SeasonType IN ${inputs.SeasonType.value}","inputQueryString":"SELECT RANK() OVER (ORDER BY Score DESC) Rank, PlayerName, Season, Date, MeetName, Score, Place, \n CASE WHEN IsConference = 'true' THEN '/Atlantic_Coast_Conference_logo.png'\n WHEN MeetName LIKE '%ACC%' THEN '/Atlantic_Coast_Conference_logo.png' \n ELSE '/Non-Conference.png' END IsConference, CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner, '/gymnast_profiles/' || PlayerName as link\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE Event = 'FLOOR' AND School = 'Clemson' AND Season IN ${inputs.Season.value} AND SeasonType IN ${inputs.SeasonType.value}","compiled":false,"inline":true},{"id":"player_stats_all_around_opp","compiledQueryString":"SELECT RANK() OVER (ORDER BY Score DESC) Rank, PlayerName, School, Season, Date, MeetName, Score, Place, \n CASE WHEN IsConference = 'true' THEN '/Atlantic_Coast_Conference_logo.png' \n WHEN MeetName LIKE '%ACC%' THEN '/Atlantic_Coast_Conference_logo.png'\n ELSE '/Non-Conference.png' END IsConference, CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE Event = 'ALL-AROUND' AND School <> 'Clemson' AND Season IN ${inputs.Season.value} AND SeasonType IN ${inputs.SeasonType.value}","inputQueryString":"SELECT RANK() OVER (ORDER BY Score DESC) Rank, PlayerName, School, Season, Date, MeetName, Score, Place, \n CASE WHEN IsConference = 'true' THEN '/Atlantic_Coast_Conference_logo.png' \n WHEN MeetName LIKE '%ACC%' THEN '/Atlantic_Coast_Conference_logo.png'\n ELSE '/Non-Conference.png' END IsConference, CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE Event = 'ALL-AROUND' AND School <> 'Clemson' AND Season IN ${inputs.Season.value} AND SeasonType IN ${inputs.SeasonType.value}","compiled":false,"inline":true},{"id":"player_stats_vault_opp","compiledQueryString":"SELECT RANK() OVER (ORDER BY Score DESC) Rank, PlayerName, School, Season, Date, MeetName, Score, Place, \n CASE WHEN IsConference = 'true' THEN '/Atlantic_Coast_Conference_logo.png' \n WHEN MeetName LIKE '%ACC%' THEN '/Atlantic_Coast_Conference_logo.png'\n ELSE '/Non-Conference.png' END IsConference, CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE Event = 'VAULT' AND School <> 'Clemson' AND Season IN ${inputs.Season.value} AND SeasonType IN ${inputs.SeasonType.value}","inputQueryString":"SELECT RANK() OVER (ORDER BY Score DESC) Rank, PlayerName, School, Season, Date, MeetName, Score, Place, \n CASE WHEN IsConference = 'true' THEN '/Atlantic_Coast_Conference_logo.png' \n WHEN MeetName LIKE '%ACC%' THEN '/Atlantic_Coast_Conference_logo.png'\n ELSE '/Non-Conference.png' END IsConference, CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE Event = 'VAULT' AND School <> 'Clemson' AND Season IN ${inputs.Season.value} AND SeasonType IN ${inputs.SeasonType.value}","compiled":false,"inline":true},{"id":"player_stats_bars_opp","compiledQueryString":"SELECT RANK() OVER (ORDER BY Score DESC) Rank, PlayerName, School, Season, Date, MeetName, Score, Place, \n CASE WHEN IsConference = 'true' THEN '/Atlantic_Coast_Conference_logo.png' \n WHEN MeetName LIKE '%ACC%' THEN '/Atlantic_Coast_Conference_logo.png'\n ELSE '/Non-Conference.png' END IsConference, CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE Event = 'BARS' AND School <> 'Clemson' AND Season IN ${inputs.Season.value} AND SeasonType IN ${inputs.SeasonType.value}","inputQueryString":"SELECT RANK() OVER (ORDER BY Score DESC) Rank, PlayerName, School, Season, Date, MeetName, Score, Place, \n CASE WHEN IsConference = 'true' THEN '/Atlantic_Coast_Conference_logo.png' \n WHEN MeetName LIKE '%ACC%' THEN '/Atlantic_Coast_Conference_logo.png'\n ELSE '/Non-Conference.png' END IsConference, CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE Event = 'BARS' AND School <> 'Clemson' AND Season IN ${inputs.Season.value} AND SeasonType IN ${inputs.SeasonType.value}","compiled":false,"inline":true},{"id":"player_stats_beam_opp","compiledQueryString":"SELECT RANK() OVER (ORDER BY Score DESC) Rank, PlayerName, School, Season, Date, MeetName, Score, Place, \n CASE WHEN IsConference = 'true' THEN '/Atlantic_Coast_Conference_logo.png' \n WHEN MeetName LIKE '%ACC%' THEN '/Atlantic_Coast_Conference_logo.png'\n ELSE '/Non-Conference.png' END IsConference, CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE Event = 'BEAM' AND School <> 'Clemson' AND Season IN ${inputs.Season.value} AND SeasonType IN ${inputs.SeasonType.value}","inputQueryString":"SELECT RANK() OVER (ORDER BY Score DESC) Rank, PlayerName, School, Season, Date, MeetName, Score, Place, \n CASE WHEN IsConference = 'true' THEN '/Atlantic_Coast_Conference_logo.png' \n WHEN MeetName LIKE '%ACC%' THEN '/Atlantic_Coast_Conference_logo.png'\n ELSE '/Non-Conference.png' END IsConference, CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE Event = 'BEAM' AND School <> 'Clemson' AND Season IN ${inputs.Season.value} AND SeasonType IN ${inputs.SeasonType.value}","compiled":false,"inline":true},{"id":"player_stats_floor_opp","compiledQueryString":"SELECT RANK() OVER (ORDER BY Score DESC) Rank, PlayerName, School, Season, Date, MeetName, Score, Place, \n CASE WHEN IsConference = 'true' THEN '/Atlantic_Coast_Conference_logo.png'\n WHEN MeetName LIKE '%ACC%' THEN '/Atlantic_Coast_Conference_logo.png'\n ELSE '/Non-Conference.png' END IsConference, CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE Event = 'FLOOR' AND School <> 'Clemson' AND Season IN ${inputs.Season.value} AND SeasonType IN ${inputs.SeasonType.value}","inputQueryString":"SELECT RANK() OVER (ORDER BY Score DESC) Rank, PlayerName, School, Season, Date, MeetName, Score, Place, \n CASE WHEN IsConference = 'true' THEN '/Atlantic_Coast_Conference_logo.png'\n WHEN MeetName LIKE '%ACC%' THEN '/Atlantic_Coast_Conference_logo.png'\n ELSE '/Non-Conference.png' END IsConference, CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE Event = 'FLOOR' AND School <> 'Clemson' AND Season IN ${inputs.Season.value} AND SeasonType IN ${inputs.SeasonType.value}","compiled":false,"inline":true},{"id":"ss_impact_all","compiledQueryString":"SELECT Event, Rank, PlayerName, Season, TotalPoints, Routines, Average, '/gymnast_profiles/' || PlayerName as link\n FROM (WITH Points AS (SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n Season,\n SUM(Score) TotalPoints,\n 'All' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event <> 'ALL-AROUND'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n Season,\n SUM(Score) TotalPoints,\n 'Vault' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'VAULT'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n Season,\n SUM(Score) TotalPoints,\n 'Bars' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BARS'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n Season,\n SUM(Score) TotalPoints,\n 'Beam' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BEAM'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n Season,\n SUM(Score) TotalPoints,\n 'Floor' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'FLOOR'\n GROUP BY PlayerName, Season\n )\n, Routines AS (SELECT PlayerName,\n Season,\n COUNT(Event) Routines,\n 'All' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event <> 'ALL-AROUND'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT PlayerName,\n Season,\n COUNT(Event) Routines,\n 'Vault' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'VAULT'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT PlayerName,\n Season,\n COUNT(Event) Routines,\n 'Bars' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BARS'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT PlayerName,\n Season,\n COUNT(Event) Routines,\n 'Beam' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BEAM'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT PlayerName,\n Season,\n COUNT(Event) Routines,\n 'Floor' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'FLOOR'\n GROUP BY PlayerName, Season\n )\n\nSELECT P.Event,\n P.Rank,\n P.PlayerName,\n P.Season,\n TotalPoints,\n Routines,\n TotalPoints / Routines Average\nFROM Points P\nLEFT JOIN Routines R\nON P.PlayerName = R.PlayerName AND P.Season = R.Season AND P.Event = R.Event)\n WHERE Event = 'All'","inputQueryString":"SELECT Event, Rank, PlayerName, Season, TotalPoints, Routines, Average, '/gymnast_profiles/' || PlayerName as link\n FROM ${single_season_impact}\n WHERE Event = 'All'","compiled":true,"inline":true},{"id":"ss_impact_vault","compiledQueryString":"SELECT Event, Rank, PlayerName, Season, TotalPoints, Routines, Average, '/gymnast_profiles/' || PlayerName as link\n FROM (WITH Points AS (SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n Season,\n SUM(Score) TotalPoints,\n 'All' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event <> 'ALL-AROUND'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n Season,\n SUM(Score) TotalPoints,\n 'Vault' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'VAULT'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n Season,\n SUM(Score) TotalPoints,\n 'Bars' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BARS'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n Season,\n SUM(Score) TotalPoints,\n 'Beam' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BEAM'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n Season,\n SUM(Score) TotalPoints,\n 'Floor' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'FLOOR'\n GROUP BY PlayerName, Season\n )\n, Routines AS (SELECT PlayerName,\n Season,\n COUNT(Event) Routines,\n 'All' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event <> 'ALL-AROUND'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT PlayerName,\n Season,\n COUNT(Event) Routines,\n 'Vault' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'VAULT'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT PlayerName,\n Season,\n COUNT(Event) Routines,\n 'Bars' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BARS'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT PlayerName,\n Season,\n COUNT(Event) Routines,\n 'Beam' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BEAM'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT PlayerName,\n Season,\n COUNT(Event) Routines,\n 'Floor' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'FLOOR'\n GROUP BY PlayerName, Season\n )\n\nSELECT P.Event,\n P.Rank,\n P.PlayerName,\n P.Season,\n TotalPoints,\n Routines,\n TotalPoints / Routines Average\nFROM Points P\nLEFT JOIN Routines R\nON P.PlayerName = R.PlayerName AND P.Season = R.Season AND P.Event = R.Event)\n WHERE Event = 'Vault'","inputQueryString":"SELECT Event, Rank, PlayerName, Season, TotalPoints, Routines, Average, '/gymnast_profiles/' || PlayerName as link\n FROM ${single_season_impact}\n WHERE Event = 'Vault'","compiled":true,"inline":true},{"id":"ss_impact_bars","compiledQueryString":"SELECT Event, Rank, PlayerName, Season, TotalPoints, Routines, Average, '/gymnast_profiles/' || PlayerName as link\n FROM (WITH Points AS (SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n Season,\n SUM(Score) TotalPoints,\n 'All' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event <> 'ALL-AROUND'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n Season,\n SUM(Score) TotalPoints,\n 'Vault' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'VAULT'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n Season,\n SUM(Score) TotalPoints,\n 'Bars' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BARS'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n Season,\n SUM(Score) TotalPoints,\n 'Beam' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BEAM'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n Season,\n SUM(Score) TotalPoints,\n 'Floor' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'FLOOR'\n GROUP BY PlayerName, Season\n )\n, Routines AS (SELECT PlayerName,\n Season,\n COUNT(Event) Routines,\n 'All' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event <> 'ALL-AROUND'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT PlayerName,\n Season,\n COUNT(Event) Routines,\n 'Vault' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'VAULT'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT PlayerName,\n Season,\n COUNT(Event) Routines,\n 'Bars' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BARS'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT PlayerName,\n Season,\n COUNT(Event) Routines,\n 'Beam' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BEAM'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT PlayerName,\n Season,\n COUNT(Event) Routines,\n 'Floor' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'FLOOR'\n GROUP BY PlayerName, Season\n )\n\nSELECT P.Event,\n P.Rank,\n P.PlayerName,\n P.Season,\n TotalPoints,\n Routines,\n TotalPoints / Routines Average\nFROM Points P\nLEFT JOIN Routines R\nON P.PlayerName = R.PlayerName AND P.Season = R.Season AND P.Event = R.Event)\n WHERE Event = 'Bars'","inputQueryString":"SELECT Event, Rank, PlayerName, Season, TotalPoints, Routines, Average, '/gymnast_profiles/' || PlayerName as link\n FROM ${single_season_impact}\n WHERE Event = 'Bars'","compiled":true,"inline":true},{"id":"ss_impact_beam","compiledQueryString":"SELECT Event, Rank, PlayerName, Season, TotalPoints, Routines, Average, '/gymnast_profiles/' || PlayerName as link\n FROM (WITH Points AS (SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n Season,\n SUM(Score) TotalPoints,\n 'All' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event <> 'ALL-AROUND'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n Season,\n SUM(Score) TotalPoints,\n 'Vault' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'VAULT'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n Season,\n SUM(Score) TotalPoints,\n 'Bars' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BARS'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n Season,\n SUM(Score) TotalPoints,\n 'Beam' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BEAM'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n Season,\n SUM(Score) TotalPoints,\n 'Floor' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'FLOOR'\n GROUP BY PlayerName, Season\n )\n, Routines AS (SELECT PlayerName,\n Season,\n COUNT(Event) Routines,\n 'All' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event <> 'ALL-AROUND'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT PlayerName,\n Season,\n COUNT(Event) Routines,\n 'Vault' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'VAULT'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT PlayerName,\n Season,\n COUNT(Event) Routines,\n 'Bars' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BARS'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT PlayerName,\n Season,\n COUNT(Event) Routines,\n 'Beam' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BEAM'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT PlayerName,\n Season,\n COUNT(Event) Routines,\n 'Floor' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'FLOOR'\n GROUP BY PlayerName, Season\n )\n\nSELECT P.Event,\n P.Rank,\n P.PlayerName,\n P.Season,\n TotalPoints,\n Routines,\n TotalPoints / Routines Average\nFROM Points P\nLEFT JOIN Routines R\nON P.PlayerName = R.PlayerName AND P.Season = R.Season AND P.Event = R.Event)\n WHERE Event = 'Beam'","inputQueryString":"SELECT Event, Rank, PlayerName, Season, TotalPoints, Routines, Average, '/gymnast_profiles/' || PlayerName as link\n FROM ${single_season_impact}\n WHERE Event = 'Beam'","compiled":true,"inline":true},{"id":"ss_impact_floor","compiledQueryString":"SELECT Event, Rank, PlayerName, Season, TotalPoints, Routines, Average, '/gymnast_profiles/' || PlayerName as link\n FROM (WITH Points AS (SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n Season,\n SUM(Score) TotalPoints,\n 'All' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event <> 'ALL-AROUND'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n Season,\n SUM(Score) TotalPoints,\n 'Vault' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'VAULT'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n Season,\n SUM(Score) TotalPoints,\n 'Bars' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BARS'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n Season,\n SUM(Score) TotalPoints,\n 'Beam' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BEAM'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n Season,\n SUM(Score) TotalPoints,\n 'Floor' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'FLOOR'\n GROUP BY PlayerName, Season\n )\n, Routines AS (SELECT PlayerName,\n Season,\n COUNT(Event) Routines,\n 'All' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event <> 'ALL-AROUND'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT PlayerName,\n Season,\n COUNT(Event) Routines,\n 'Vault' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'VAULT'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT PlayerName,\n Season,\n COUNT(Event) Routines,\n 'Bars' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BARS'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT PlayerName,\n Season,\n COUNT(Event) Routines,\n 'Beam' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BEAM'\n GROUP BY PlayerName, Season\n\n UNION ALL\n\n SELECT PlayerName,\n Season,\n COUNT(Event) Routines,\n 'Floor' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'FLOOR'\n GROUP BY PlayerName, Season\n )\n\nSELECT P.Event,\n P.Rank,\n P.PlayerName,\n P.Season,\n TotalPoints,\n Routines,\n TotalPoints / Routines Average\nFROM Points P\nLEFT JOIN Routines R\nON P.PlayerName = R.PlayerName AND P.Season = R.Season AND P.Event = R.Event)\n WHERE Event = 'Floor'","inputQueryString":"SELECT Event, Rank, PlayerName, Season, TotalPoints, Routines, Average, '/gymnast_profiles/' || PlayerName as link\n FROM ${single_season_impact}\n WHERE Event = 'Floor'","compiled":true,"inline":true},{"id":"career_impact_all","compiledQueryString":"SELECT Event, Rank, PlayerName, TotalPoints, Routines, Average, '/gymnast_profiles/' || PlayerName as link\n FROM (WITH Points AS (SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n SUM(Score) TotalPoints,\n 'All' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event <> 'ALL-AROUND'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n SUM(Score) TotalPoints,\n 'Vault' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'VAULT'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n SUM(Score) TotalPoints,\n 'Bars' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BARS'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n SUM(Score) TotalPoints,\n 'Beam' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BEAM'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n SUM(Score) TotalPoints,\n 'Floor' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'FLOOR'\n GROUP BY PlayerName\n )\n, Routines AS (SELECT PlayerName,\n COUNT(Event) Routines,\n 'All' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event <> 'ALL-AROUND'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT PlayerName,\n COUNT(Event) Routines,\n 'Vault' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'VAULT'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT PlayerName,\n COUNT(Event) Routines,\n 'Bars' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BARS'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT PlayerName,\n COUNT(Event) Routines,\n 'Beam' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BEAM'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT PlayerName,\n COUNT(Event) Routines,\n 'Floor' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'FLOOR'\n GROUP BY PlayerName\n )\n\nSELECT P.Event,\n P.Rank,\n P.PlayerName,\n TotalPoints,\n Routines,\n TotalPoints / Routines Average\nFROM Points P\nLEFT JOIN Routines R\nON P.PlayerName = R.PlayerName AND P.Event = R.Event)\n WHERE Event = 'All'","inputQueryString":"SELECT Event, Rank, PlayerName, TotalPoints, Routines, Average, '/gymnast_profiles/' || PlayerName as link\n FROM ${career_impact}\n WHERE Event = 'All'","compiled":true,"inline":true},{"id":"career_impact_vault","compiledQueryString":"SELECT Event, Rank, PlayerName, TotalPoints, Routines, Average, '/gymnast_profiles/' || PlayerName as link\n FROM (WITH Points AS (SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n SUM(Score) TotalPoints,\n 'All' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event <> 'ALL-AROUND'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n SUM(Score) TotalPoints,\n 'Vault' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'VAULT'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n SUM(Score) TotalPoints,\n 'Bars' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BARS'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n SUM(Score) TotalPoints,\n 'Beam' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BEAM'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n SUM(Score) TotalPoints,\n 'Floor' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'FLOOR'\n GROUP BY PlayerName\n )\n, Routines AS (SELECT PlayerName,\n COUNT(Event) Routines,\n 'All' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event <> 'ALL-AROUND'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT PlayerName,\n COUNT(Event) Routines,\n 'Vault' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'VAULT'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT PlayerName,\n COUNT(Event) Routines,\n 'Bars' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BARS'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT PlayerName,\n COUNT(Event) Routines,\n 'Beam' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BEAM'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT PlayerName,\n COUNT(Event) Routines,\n 'Floor' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'FLOOR'\n GROUP BY PlayerName\n )\n\nSELECT P.Event,\n P.Rank,\n P.PlayerName,\n TotalPoints,\n Routines,\n TotalPoints / Routines Average\nFROM Points P\nLEFT JOIN Routines R\nON P.PlayerName = R.PlayerName AND P.Event = R.Event)\n WHERE Event = 'Vault'","inputQueryString":"SELECT Event, Rank, PlayerName, TotalPoints, Routines, Average, '/gymnast_profiles/' || PlayerName as link\n FROM ${career_impact}\n WHERE Event = 'Vault'","compiled":true,"inline":true},{"id":"career_impact_bars","compiledQueryString":"SELECT Event, Rank, PlayerName, TotalPoints, Routines, Average, '/gymnast_profiles/' || PlayerName as link\n FROM (WITH Points AS (SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n SUM(Score) TotalPoints,\n 'All' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event <> 'ALL-AROUND'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n SUM(Score) TotalPoints,\n 'Vault' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'VAULT'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n SUM(Score) TotalPoints,\n 'Bars' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BARS'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n SUM(Score) TotalPoints,\n 'Beam' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BEAM'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n SUM(Score) TotalPoints,\n 'Floor' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'FLOOR'\n GROUP BY PlayerName\n )\n, Routines AS (SELECT PlayerName,\n COUNT(Event) Routines,\n 'All' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event <> 'ALL-AROUND'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT PlayerName,\n COUNT(Event) Routines,\n 'Vault' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'VAULT'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT PlayerName,\n COUNT(Event) Routines,\n 'Bars' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BARS'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT PlayerName,\n COUNT(Event) Routines,\n 'Beam' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BEAM'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT PlayerName,\n COUNT(Event) Routines,\n 'Floor' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'FLOOR'\n GROUP BY PlayerName\n )\n\nSELECT P.Event,\n P.Rank,\n P.PlayerName,\n TotalPoints,\n Routines,\n TotalPoints / Routines Average\nFROM Points P\nLEFT JOIN Routines R\nON P.PlayerName = R.PlayerName AND P.Event = R.Event)\n WHERE Event = 'Bars'","inputQueryString":"SELECT Event, Rank, PlayerName, TotalPoints, Routines, Average, '/gymnast_profiles/' || PlayerName as link\n FROM ${career_impact}\n WHERE Event = 'Bars'","compiled":true,"inline":true},{"id":"career_impact_beam","compiledQueryString":"SELECT Event, Rank, PlayerName, TotalPoints, Routines, Average, '/gymnast_profiles/' || PlayerName as link\n FROM (WITH Points AS (SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n SUM(Score) TotalPoints,\n 'All' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event <> 'ALL-AROUND'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n SUM(Score) TotalPoints,\n 'Vault' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'VAULT'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n SUM(Score) TotalPoints,\n 'Bars' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BARS'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n SUM(Score) TotalPoints,\n 'Beam' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BEAM'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n SUM(Score) TotalPoints,\n 'Floor' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'FLOOR'\n GROUP BY PlayerName\n )\n, Routines AS (SELECT PlayerName,\n COUNT(Event) Routines,\n 'All' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event <> 'ALL-AROUND'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT PlayerName,\n COUNT(Event) Routines,\n 'Vault' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'VAULT'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT PlayerName,\n COUNT(Event) Routines,\n 'Bars' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BARS'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT PlayerName,\n COUNT(Event) Routines,\n 'Beam' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BEAM'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT PlayerName,\n COUNT(Event) Routines,\n 'Floor' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'FLOOR'\n GROUP BY PlayerName\n )\n\nSELECT P.Event,\n P.Rank,\n P.PlayerName,\n TotalPoints,\n Routines,\n TotalPoints / Routines Average\nFROM Points P\nLEFT JOIN Routines R\nON P.PlayerName = R.PlayerName AND P.Event = R.Event)\n WHERE Event = 'Beam'","inputQueryString":"SELECT Event, Rank, PlayerName, TotalPoints, Routines, Average, '/gymnast_profiles/' || PlayerName as link\n FROM ${career_impact}\n WHERE Event = 'Beam'","compiled":true,"inline":true},{"id":"career_impact_floor","compiledQueryString":"SELECT Event, Rank, PlayerName, TotalPoints, Routines, Average, '/gymnast_profiles/' || PlayerName as link\n FROM (WITH Points AS (SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n SUM(Score) TotalPoints,\n 'All' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event <> 'ALL-AROUND'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n SUM(Score) TotalPoints,\n 'Vault' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'VAULT'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n SUM(Score) TotalPoints,\n 'Bars' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BARS'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n SUM(Score) TotalPoints,\n 'Beam' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BEAM'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT RANK() OVER (ORDER BY SUM(Score) DESC) Rank,\n PlayerName,\n SUM(Score) TotalPoints,\n 'Floor' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'FLOOR'\n GROUP BY PlayerName\n )\n, Routines AS (SELECT PlayerName,\n COUNT(Event) Routines,\n 'All' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event <> 'ALL-AROUND'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT PlayerName,\n COUNT(Event) Routines,\n 'Vault' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'VAULT'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT PlayerName,\n COUNT(Event) Routines,\n 'Bars' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BARS'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT PlayerName,\n COUNT(Event) Routines,\n 'Beam' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'BEAM'\n GROUP BY PlayerName\n\n UNION ALL\n\n SELECT PlayerName,\n COUNT(Event) Routines,\n 'Floor' AS Event\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE School = 'Clemson' AND Event = 'FLOOR'\n GROUP BY PlayerName\n )\n\nSELECT P.Event,\n P.Rank,\n P.PlayerName,\n TotalPoints,\n Routines,\n TotalPoints / Routines Average\nFROM Points P\nLEFT JOIN Routines R\nON P.PlayerName = R.PlayerName AND P.Event = R.Event)\n WHERE Event = 'Floor'","inputQueryString":"SELECT Event, Rank, PlayerName, TotalPoints, Routines, Average, '/gymnast_profiles/' || PlayerName as link\n FROM ${career_impact}\n WHERE Event = 'Floor'","compiled":true,"inline":true},{"id":"dd_season","compiledQueryString":"SELECT DISTINCT Season\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet","inputQueryString":"SELECT DISTINCT Season\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet","compiled":false,"inline":true},{"id":"dd_season_type","compiledQueryString":"SELECT DISTINCT SeasonType\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet","inputQueryString":"SELECT DISTINCT SeasonType\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet","compiled":false,"inline":true}]}

Clemson Performances

Season Scoring Impact

Career Scoring Impact

Opponent Performances