{"queries":[{"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},{"id":"dd_date_meet","compiledQueryString":"SELECT DISTINCT RANK() OVER (ORDER BY Date ASC) AS Rank,\n CONCAT(LEFT(CAST(Date AS VARCHAR(10)), 10), ' | ', MeetName) AS Date_Meet,\n MeetName\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE Season = '${inputs.Season.value}' AND SeasonType = '${inputs.SeasonType.value}'","inputQueryString":"SELECT DISTINCT RANK() OVER (ORDER BY Date ASC) AS Rank,\n CONCAT(LEFT(CAST(Date AS VARCHAR(10)), 10), ' | ', MeetName) AS Date_Meet,\n MeetName\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE Season = '${inputs.Season.value}' AND SeasonType = '${inputs.SeasonType.value}'","compiled":false,"inline":true},{"id":"cu_data","compiledQueryString":"SELECT Date, MeetName, Opponent, PlayerName, School, Event, Score, Place, EventOrder, CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner, 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 Season = '${inputs.Season.value}' AND SeasonType = '${inputs.SeasonType.value}' \n AND CONCAT(LEFT(CAST(Date AS VARCHAR(10)), 10), ' | ', MeetName) = '${inputs.Date_Meet.value}'\n AND Event <> 'ALL-AROUND' AND School = 'Clemson'\n ORDER BY Event, EventOrder ASC","inputQueryString":"SELECT Date, MeetName, Opponent, PlayerName, School, Event, Score, Place, EventOrder, CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner, 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 Season = '${inputs.Season.value}' AND SeasonType = '${inputs.SeasonType.value}' \n AND CONCAT(LEFT(CAST(Date AS VARCHAR(10)), 10), ' | ', MeetName) = '${inputs.Date_Meet.value}'\n AND Event <> 'ALL-AROUND' AND School = 'Clemson'\n ORDER BY Event, EventOrder ASC","compiled":false,"inline":true},{"id":"cu_total","compiledQueryString":"WITH Base AS (SELECT Date, MeetName, School, Event, Score, ROW_NUMBER() OVER (PARTITION BY School, Event ORDER BY Score DESC) RowNumber\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE Season = '${inputs.Season.value}' AND SeasonType = '${inputs.SeasonType.value}' \n AND CONCAT(LEFT(CAST(Date AS VARCHAR(10)), 10), ' | ', MeetName) = '${inputs.Date_Meet.value}'\n AND Event <> 'ALL-AROUND' AND School = 'Clemson')\n , RowNumber AS (SELECT Date, MeetName, School, Event, Score\n FROM Base\n WHERE RowNumber <= 5)\n\n SELECT Date, MeetName, School, CONCAT(School, ': ') AS Title, SUM(Score) AS TotalScore\n FROM RowNumber\n GROUP BY Date, MeetName, School, CONCAT(School, ': ')","inputQueryString":"WITH Base AS (SELECT Date, MeetName, School, Event, Score, ROW_NUMBER() OVER (PARTITION BY School, Event ORDER BY Score DESC) RowNumber\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE Season = '${inputs.Season.value}' AND SeasonType = '${inputs.SeasonType.value}' \n AND CONCAT(LEFT(CAST(Date AS VARCHAR(10)), 10), ' | ', MeetName) = '${inputs.Date_Meet.value}'\n AND Event <> 'ALL-AROUND' AND School = 'Clemson')\n , RowNumber AS (SELECT Date, MeetName, School, Event, Score\n FROM Base\n WHERE RowNumber <= 5)\n\n SELECT Date, MeetName, School, CONCAT(School, ': ') AS Title, SUM(Score) AS TotalScore\n FROM RowNumber\n GROUP BY Date, MeetName, School, CONCAT(School, ': ')","compiled":false,"inline":true},{"id":"multiple_opps","compiledQueryString":"WITH Base AS (SELECT Date, MeetName, School, Event, Score, ROW_NUMBER() OVER (PARTITION BY School, Event ORDER BY Score DESC) RowNumber\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE Season = '${inputs.Season.value}' AND SeasonType = '${inputs.SeasonType.value}' \n AND CONCAT(LEFT(CAST(Date AS VARCHAR(10)), 10), ' | ', MeetName) = '${inputs.Date_Meet.value}'\n AND Event <> 'ALL-AROUND' AND School <> 'Clemson')\n , RowNumber AS (SELECT Date, MeetName, School, Event, Score\n FROM Base\n WHERE RowNumber <= 5)\n \n SELECT DISTINCT School\n FROM RowNumber","inputQueryString":"WITH Base AS (SELECT Date, MeetName, School, Event, Score, ROW_NUMBER() OVER (PARTITION BY School, Event ORDER BY Score DESC) RowNumber\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE Season = '${inputs.Season.value}' AND SeasonType = '${inputs.SeasonType.value}' \n AND CONCAT(LEFT(CAST(Date AS VARCHAR(10)), 10), ' | ', MeetName) = '${inputs.Date_Meet.value}'\n AND Event <> 'ALL-AROUND' AND School <> 'Clemson')\n , RowNumber AS (SELECT Date, MeetName, School, Event, Score\n FROM Base\n WHERE RowNumber <= 5)\n \n SELECT DISTINCT School\n FROM RowNumber","compiled":false,"inline":true},{"id":"opp_data","compiledQueryString":"SELECT Date, MeetName, Opponent, PlayerName, School, Event, Score, Place, EventOrder, CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE Season = '${inputs.Season.value}' AND SeasonType = '${inputs.SeasonType.value}' \n AND CONCAT(LEFT(CAST(Date AS VARCHAR(10)), 10), ' | ', MeetName) = '${inputs.Date_Meet.value}'\n AND Event <> 'ALL-AROUND' AND School <> 'Clemson'\n AND (\n ((SELECT COUNT(*) FROM (WITH Base AS (SELECT Date, MeetName, School, Event, Score, ROW_NUMBER() OVER (PARTITION BY School, Event ORDER BY Score DESC) RowNumber\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE Season = '${inputs.Season.value}' AND SeasonType = '${inputs.SeasonType.value}' \n AND CONCAT(LEFT(CAST(Date AS VARCHAR(10)), 10), ' | ', MeetName) = '${inputs.Date_Meet.value}'\n AND Event <> 'ALL-AROUND' AND School <> 'Clemson')\n , RowNumber AS (SELECT Date, MeetName, School, Event, Score\n FROM Base\n WHERE RowNumber <= 5)\n \n SELECT DISTINCT School\n FROM RowNumber) AS _opp_cnt) = 1 AND School = (SELECT School FROM (WITH Base AS (SELECT Date, MeetName, School, Event, Score, ROW_NUMBER() OVER (PARTITION BY School, Event ORDER BY Score DESC) RowNumber\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE Season = '${inputs.Season.value}' AND SeasonType = '${inputs.SeasonType.value}' \n AND CONCAT(LEFT(CAST(Date AS VARCHAR(10)), 10), ' | ', MeetName) = '${inputs.Date_Meet.value}'\n AND Event <> 'ALL-AROUND' AND School <> 'Clemson')\n , RowNumber AS (SELECT Date, MeetName, School, Event, Score\n FROM Base\n WHERE RowNumber <= 5)\n \n SELECT DISTINCT School\n FROM RowNumber) AS _opp_one LIMIT 1))\n OR ((SELECT COUNT(*) FROM (WITH Base AS (SELECT Date, MeetName, School, Event, Score, ROW_NUMBER() OVER (PARTITION BY School, Event ORDER BY Score DESC) RowNumber\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE Season = '${inputs.Season.value}' AND SeasonType = '${inputs.SeasonType.value}' \n AND CONCAT(LEFT(CAST(Date AS VARCHAR(10)), 10), ' | ', MeetName) = '${inputs.Date_Meet.value}'\n AND Event <> 'ALL-AROUND' AND School <> 'Clemson')\n , RowNumber AS (SELECT Date, MeetName, School, Event, Score\n FROM Base\n WHERE RowNumber <= 5)\n \n SELECT DISTINCT School\n FROM RowNumber) AS _opp_cnt2) > 1 AND School = '${inputs.Mult_Opps}')\n )\n ORDER BY Event, EventOrder ASC","inputQueryString":"SELECT Date, MeetName, Opponent, PlayerName, School, Event, Score, Place, EventOrder, CASE WHEN EventWinner = 'true' THEN '🏆' ELSE '' END EventWinner\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE Season = '${inputs.Season.value}' AND SeasonType = '${inputs.SeasonType.value}' \n AND CONCAT(LEFT(CAST(Date AS VARCHAR(10)), 10), ' | ', MeetName) = '${inputs.Date_Meet.value}'\n AND Event <> 'ALL-AROUND' AND School <> 'Clemson'\n AND (\n ((SELECT COUNT(*) FROM ${multiple_opps} AS _opp_cnt) = 1 AND School = (SELECT School FROM ${multiple_opps} AS _opp_one LIMIT 1))\n OR ((SELECT COUNT(*) FROM ${multiple_opps} AS _opp_cnt2) > 1 AND School = '${inputs.Mult_Opps}')\n )\n ORDER BY Event, EventOrder ASC","compiled":true,"inline":true},{"id":"opp_total","compiledQueryString":"WITH Base AS (SELECT Date, MeetName, School, Event, Score, ROW_NUMBER() OVER (PARTITION BY School, Event ORDER BY Score DESC) RowNumber\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE Season = '${inputs.Season.value}' AND SeasonType = '${inputs.SeasonType.value}' \n AND CONCAT(LEFT(CAST(Date AS VARCHAR(10)), 10), ' | ', MeetName) = '${inputs.Date_Meet.value}'\n AND Event <> 'ALL-AROUND' AND School <> 'Clemson')\n , RowNumber AS (SELECT Date, MeetName, School, Event, Score\n FROM Base\n WHERE RowNumber <= 5)\n\n SELECT Date, MeetName, School, CONCAT(School, ': ') AS Title, SUM(Score) AS TotalScore\n FROM RowNumber\n WHERE (\n ((SELECT COUNT(*) FROM (WITH Base AS (SELECT Date, MeetName, School, Event, Score, ROW_NUMBER() OVER (PARTITION BY School, Event ORDER BY Score DESC) RowNumber\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE Season = '${inputs.Season.value}' AND SeasonType = '${inputs.SeasonType.value}' \n AND CONCAT(LEFT(CAST(Date AS VARCHAR(10)), 10), ' | ', MeetName) = '${inputs.Date_Meet.value}'\n AND Event <> 'ALL-AROUND' AND School <> 'Clemson')\n , RowNumber AS (SELECT Date, MeetName, School, Event, Score\n FROM Base\n WHERE RowNumber <= 5)\n \n SELECT DISTINCT School\n FROM RowNumber) AS _opp_cnt) = 1 AND School = (SELECT School FROM (WITH Base AS (SELECT Date, MeetName, School, Event, Score, ROW_NUMBER() OVER (PARTITION BY School, Event ORDER BY Score DESC) RowNumber\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE Season = '${inputs.Season.value}' AND SeasonType = '${inputs.SeasonType.value}' \n AND CONCAT(LEFT(CAST(Date AS VARCHAR(10)), 10), ' | ', MeetName) = '${inputs.Date_Meet.value}'\n AND Event <> 'ALL-AROUND' AND School <> 'Clemson')\n , RowNumber AS (SELECT Date, MeetName, School, Event, Score\n FROM Base\n WHERE RowNumber <= 5)\n \n SELECT DISTINCT School\n FROM RowNumber) AS _opp_one LIMIT 1))\n OR ((SELECT COUNT(*) FROM (WITH Base AS (SELECT Date, MeetName, School, Event, Score, ROW_NUMBER() OVER (PARTITION BY School, Event ORDER BY Score DESC) RowNumber\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE Season = '${inputs.Season.value}' AND SeasonType = '${inputs.SeasonType.value}' \n AND CONCAT(LEFT(CAST(Date AS VARCHAR(10)), 10), ' | ', MeetName) = '${inputs.Date_Meet.value}'\n AND Event <> 'ALL-AROUND' AND School <> 'Clemson')\n , RowNumber AS (SELECT Date, MeetName, School, Event, Score\n FROM Base\n WHERE RowNumber <= 5)\n \n SELECT DISTINCT School\n FROM RowNumber) AS _opp_cnt2) > 1 AND School = '${inputs.Mult_Opps}')\n )\n GROUP BY Date, MeetName, School, CONCAT(School, ': ')","inputQueryString":"WITH Base AS (SELECT Date, MeetName, School, Event, Score, ROW_NUMBER() OVER (PARTITION BY School, Event ORDER BY Score DESC) RowNumber\n FROM SPORTS_INFO_DW_REPORTING.vw_WGYM_player_stats_by_meet\n WHERE Season = '${inputs.Season.value}' AND SeasonType = '${inputs.SeasonType.value}' \n AND CONCAT(LEFT(CAST(Date AS VARCHAR(10)), 10), ' | ', MeetName) = '${inputs.Date_Meet.value}'\n AND Event <> 'ALL-AROUND' AND School <> 'Clemson')\n , RowNumber AS (SELECT Date, MeetName, School, Event, Score\n FROM Base\n WHERE RowNumber <= 5)\n\n SELECT Date, MeetName, School, CONCAT(School, ': ') AS Title, SUM(Score) AS TotalScore\n FROM RowNumber\n WHERE (\n ((SELECT COUNT(*) FROM ${multiple_opps} AS _opp_cnt) = 1 AND School = (SELECT School FROM ${multiple_opps} AS _opp_one LIMIT 1))\n OR ((SELECT COUNT(*) FROM ${multiple_opps} AS _opp_cnt2) > 1 AND School = '${inputs.Mult_Opps}')\n )\n GROUP BY Date, MeetName, School, CONCAT(School, ': ')","compiled":true,"inline":true}]}

Meet Data