{"queries":[{"id":"team_high_scores","compiledQueryString":"SELECT RANK() OVER (ORDER BY Score DESC) Rank,\n Season,\n Date,\n MeetName, \n Score,\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,\n CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_team_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,\n Season,\n Date,\n MeetName, \n Score,\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,\n CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_team_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":"team_highest_vault","compiledQueryString":"SELECT RANK() OVER (ORDER BY Score DESC) Rank,\n Season,\n Date,\n MeetName, \n Score,\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,\n CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_team_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,\n Season,\n Date,\n MeetName, \n Score,\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,\n CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_team_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":"team_highest_bars","compiledQueryString":"SELECT RANK() OVER (ORDER BY Score DESC) Rank,\n Season,\n Date,\n MeetName, \n Score,\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,\n CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_team_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,\n Season,\n Date,\n MeetName, \n Score,\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,\n CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_team_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":"team_highest_beam","compiledQueryString":"SELECT RANK() OVER (ORDER BY Score DESC) Rank,\n Season,\n Date,\n MeetName, \n Score,\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,\n CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_team_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,\n Season,\n Date,\n MeetName, \n Score,\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,\n CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_team_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":"team_highest_floor","compiledQueryString":"SELECT RANK() OVER (ORDER BY Score DESC) Rank,\n Season,\n Date,\n MeetName, \n Score,\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,\n CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_team_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,\n Season,\n Date,\n MeetName, \n Score,\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,\n CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_team_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":"team_high_scores_opp","compiledQueryString":"SELECT RANK() OVER (ORDER BY Score DESC) Rank,\n Season,\n Date,\n School,\n MeetName, \n Score,\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,\n CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_team_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,\n Season,\n Date,\n School,\n MeetName, \n Score,\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,\n CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_team_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":"team_highest_vault_opp","compiledQueryString":"SELECT RANK() OVER (ORDER BY Score DESC) Rank,\n Season,\n Date,\n School,\n MeetName, \n Score,\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,\n CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_team_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,\n Season,\n Date,\n School,\n MeetName, \n Score,\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,\n CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_team_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":"team_highest_bars_opp","compiledQueryString":"SELECT RANK() OVER (ORDER BY Score DESC) Rank,\n Season,\n Date,\n School,\n MeetName, \n Score,\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,\n CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_team_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,\n Season,\n Date,\n School,\n MeetName, \n Score,\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,\n CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_team_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":"team_highest_beam_opp","compiledQueryString":"SELECT RANK() OVER (ORDER BY Score DESC) Rank,\n Season,\n Date,\n School,\n MeetName, \n Score,\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,\n CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_team_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,\n Season,\n Date,\n School,\n MeetName, \n Score,\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,\n CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_team_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":"team_highest_floor_opp","compiledQueryString":"SELECT RANK() OVER (ORDER BY Score DESC) Rank,\n Season,\n Date,\n School,\n MeetName, \n Score,\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,\n CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_team_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,\n Season,\n Date,\n School,\n MeetName, \n Score,\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,\n CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_team_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":"dd_season","compiledQueryString":"SELECT DISTINCT Season\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_team_stats_by_meet","inputQueryString":"SELECT DISTINCT Season\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_team_stats_by_meet","compiled":false,"inline":true},{"id":"dd_season_type","compiledQueryString":"SELECT DISTINCT SeasonType\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_team_stats_by_meet","inputQueryString":"SELECT DISTINCT SeasonType\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_team_stats_by_meet","compiled":false,"inline":true}]}

Clemson Performances

Opponent Performances