{"queries":[{"id":"profile_pages","compiledQueryString":"-- Builds the master Clemson softball roster/profile list with player photos and jersey numbers.\n\nWITH Rosters AS (SELECT CONCAT(FirstName,' ', Lastname) AS PlayerName,\n LastName,\n PlayerId,\n LastSeason\n FROM SPORTS_INFO_DW_REPORTING.vw_cuad_player\n WHERE SportCode = 'SFTB')\n, Rosters_Photos AS (SELECT PlayerName,\n LastName,\n PlayerId,\n LastSeason,\n CASE WHEN PlayerName = 'Valerie Frank' THEN 'https://clemsontigers.com/imgproxy/_SDRTKiAMRcL8x8-R4eaoVPPMaIXGGvJHk2ThxOfhWM/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjAvMDIvRnJhbmtWYWxlcmllLmpwZw.jpg'\n WHEN PlayerName = 'JoJo Hyatt' THEN 'https://clemsontigers.com/imgproxy/rj-vD9Szk-ZXMiVObQ1-rBz9SC2TGGLNIT-16FoCvPE/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMTAvMjNfSHlhdHRKb0pvLnBuZw.png'\n WHEN PlayerName = 'Arielle Oda' THEN 'https://clemsontigers.com/imgproxy/rco96zwtFS0uLCiV_egQQb7rGJy0CFw8gcjWRSWdF0Y/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMTAvMjRfT2RhQXJpZWxsZS5wbmc.png'\n WHEN PlayerName = 'Marissa Guimbarda' THEN 'https://clemsontigers.com/imgproxy/EEriqZMajrWHXOZmbizKjWQff160UPMKvMJExBH3fvE/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjEvMTIvR3VpbWJhcmRhTWFyaXNzYS5wbmc.png'\n WHEN PlayerName = 'Grace Mattimore' THEN 'https://clemsontigers.com/imgproxy/V-3PFwwxL0sUvCp58AtqYQXC1pVk1Nnpjv8SqL-ylwM/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjEvMTIvTWF0dGltb3JlR3JhY2UucG5n.png'\n WHEN PlayerName = 'MK Bonamy' THEN 'https://clemsontigers.com/imgproxy/zzFHaJ6dW_FTBJzSykX4v6tbe_2ScW2Lmo5hIpcPM6I/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjAvMDEvQm9uYW15TUstMi5qcGc.jpg'\n WHEN PlayerName = 'Logan Caymol' THEN 'https://clemsontigers.com/imgproxy/fx_F2oRHwxK5FN760IdDqE6qRTE9c4_Kfn2y0D7zwqw/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjAvMDEvQ2F5bW9sTG9nYW4tc2NhbGVkLWUxNjA1NTM2MDkzNjY0LmpwZw.jpg'\n WHEN PlayerName = 'Morgan Johnson' THEN 'https://clemsontigers.com/imgproxy/Oykbh0iw1gZxo0tEqskDl7VIRNfpCwpQqreQfxFgeIE/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjIvMTAvSm9obnNvbk1vcmdhbi5wbmc.png'\n WHEN PlayerName = 'Kyah Keller' THEN 'https://clemsontigers.com/imgproxy/bZ2CGXzfjPodTc26LmpYVuRNlRGEXlImx5Zd7vg8Vcg/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjIvMTAvS2VsbGVyS3lhaC5wbmc.png'\n WHEN PlayerName = 'Valerie Cagle' THEN 'https://clemsontigers.com/imgproxy/3wY6Z5spr4CBFLEFzeAww65beeNlbtgsgrSV_9sLOxY/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMTAvNzJfQ2FnbGVWYWxlcmllLnBuZw.png'\n WHEN PlayerName = 'Hannah Goodwin' THEN 'https://clemsontigers.com/imgproxy/jceToqu-OOoPaH_yrg6hLf9ikPmRyOqVlCdXhSbifSc/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMTkvMDgvR29vZHdpbkhhbm5haC5wbmc.png'\n WHEN PlayerName = 'Carlee Shannon' THEN 'https://clemsontigers.com/imgproxy/2LdwlS4oE09Hba7--hGVqpD2jNFMpbJj9xrR7ljnjAQ/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjEvMTIvU2hhbm5vbkNhcmxlZS5wbmc.png'\n WHEN PlayerName = 'Casey Bigham' THEN 'https://clemsontigers.com/imgproxy/zqtEIsiwnKd7WEsJaINH_Pc7g-9AiX1O4DPD1KW-GOk/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjAvMDgvQmlnaGFtQ2FzZXkuanBn.jpg'\n WHEN PlayerName = 'Ansley Houston' THEN 'https://clemsontigers.com/imgproxy/eEW8frgRRaZ0Ub1jzTFE1SgHT6xdennVU7ORYdAbMgY/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjIvMTAvSG91c3RvbkFuc2xleS5wbmc.png'\n WHEN PlayerName = 'McKenzie Clark' THEN 'https://clemsontigers.com/imgproxy/sW4TF2laF_wV4G7h3dmiYS8cmfnvwfi1NBGYiA6fbJM/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMTAvN19DbGFya01jS2VuemllLnBuZw.png'\n WHEN PlayerName = 'Sarah Howell' THEN 'https://clemsontigers.com/imgproxy/NZQpcTEhHvT1xH786vm7ogV37i4rEVX-Cnt-Us1xizU/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjIvMTAvSG93ZWxsU2FyYWgucG5n.png'\n WHEN PlayerName = 'Regan Spencer' THEN 'https://clemsontigers.com/imgproxy/EHMz_AFgrGDgBkAsFCUE0wHzkkYzIIelQZyqqZ7cNr4/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMTAvMTlfU3BlbmNlclJlZ2FuLnBuZw.png'\n WHEN PlayerName = 'Jaden Cheek' THEN 'https://clemsontigers.com/imgproxy/AaRXcy6qe3EXX7nl-banBpdusiQ7vpLOW-88IRJ6G3c/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjEvMTIvQ2hlZWtKYWRlbi5wbmc.png'\n WHEN PlayerName = 'Carsten Puckett' THEN 'https://clemsontigers.com/imgproxy/IjDeGGQxHQMzMF6e1qvFUUX1Z4T8w-rQCi1Jn7gfw48/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjAvMDgvUHVja2V0dENhcnN0ZW4uanBn.jpg'\n WHEN PlayerName = 'Millie Thompson' THEN 'https://clemsontigers.com/imgproxy/e3RUq7wmuZUAkCIXOd2ZS60Ujr0GtluBWpoI3Wgr8yM/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMTAvODdfVGhvbXBzb25NaWxsaWUucG5n.png'\n WHEN PlayerName = 'Rachel Gibson' THEN 'https://clemsontigers.com/imgproxy/DHoBapuuSa9-3hL6-CKFHWa_O1G6McdMPLIgaZx6H4I/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjIvMTAvR2lic29uUmFjaGVsLnBuZw.png'\n WHEN PlayerName = 'Brooke McCubbin' THEN 'https://clemsontigers.com/imgproxy/RZs988wLvb-vUplaYWDxVVADnxF3ptp1tE33KifXrVs/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMTEvTWNDdWJiaW5Ccm9va2UucG5n.png'\n WHEN PlayerName = 'Ansley Gilstrap' THEN 'https://clemsontigers.com/imgproxy/Xl2jfHrlEBtF4Y5n5CWW15D7EzQYjaieHBaRtF7a-zU/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjAvMDgvR2lsc3RyYXBBbnNsZXkuanBn.jpg'\n WHEN PlayerName = 'Sam Russ' THEN 'https://clemsontigers.com/imgproxy/HkQ86kq6ChH_R8JMoRLD8Z68ximka91ddhPlv3lGpJA/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjEvMTIvUnVzc1NhbS5wbmc.png'\n WHEN PlayerName = 'Aby Vieira' THEN 'https://clemsontigers.com/imgproxy/1VkzI7qYH7-UzY85RaYHPMgA1tKSiNJb815JVlxR2mQ/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMTEvVmllaXJhQWJ5LnBuZw.png'\n WHEN PlayerName = 'Grace Hiller' THEN 'https://clemsontigers.com/imgproxy/Kt4K-FFLsTWTS-fO4_we31dmVJZjcs3ehMuTIJ1789Y/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMTAvOF9IaWxsZXJHcmFjZS5wbmc.png'\n WHEN PlayerName = 'Haylee Whitesides' THEN 'https://clemsontigers.com/imgproxy/YFSk3qR6Ji4u10CYN-py_exw2ev7qqfIkNZj4l4k6Z4/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMTEvV2hpdGVzaWRlc0hheWxlZS5wbmc.png'\n WHEN PlayerName = 'Jadeyn Ruszkowski' THEN 'https://clemsontigers.com/imgproxy/lZJlwRnlGjvpzXaUbZydpnrzX8cxT66PV0MVhs4aekI/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMTEvUnVzemtvd3NraUphZGV5bi5wbmc.png'\n WHEN PlayerName = 'Maddie Moore' THEN 'https://clemsontigers.com/imgproxy/K20BP0TZo5mTOUWIa7qrdzccoRvgR7wXMA0qz4X19QY/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMTEvTW9vcmVNYWRkaWUucG5n.png'\n WHEN PlayerName = 'Marena Knowles' THEN 'https://clemsontigers.com/imgproxy/5Y1SKUWe3c-inR44fp1P6AUNmSK0Q5dzWNnb4gb1VYM/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMTAvMDBfS25vd2xlc01hcmVuYS5wbmc.png'\n WHEN PlayerName = 'Reedy Davenport' THEN 'https://clemsontigers.com/imgproxy/bSveNNjrKlt-Tg0rZereASni4ZwNCJZqtIcXPBX7kB4/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjIvMTAvRGF2ZW5wb3J0UmVlZHkucG5n.png'\n WHEN PlayerName = 'Julia Bomhardt' THEN 'https://clemsontigers.com/imgproxy/0rfuv7ORU8ow1z9uNs4QeitY_nI7ZlruH6c-pQJicWM/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMTAvNl9Cb21oYXJkdEp1bGlhLnBuZw.png'\n WHEN PlayerName = 'Caroline Jacobsen' THEN 'https://clemsontigers.com/imgproxy/VfxK0GODvXkRKd_Z0wgzY_WiHeFiX-PaVBbwCq8H2Eg/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjIvMTAvSmFjb2JzZW5DYXJvbGluZS5wbmc.png'\n WHEN PlayerName = 'Emma Whitfield' THEN 'https://clemsontigers.com/imgproxy/mFSGMWLTh8p0t4LKIsCWGOVskCeoqkfyPbWNkN_-rLw/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjEvMTIvV2hpdGZpZWxkRW1tYS5wbmc.png'\n WHEN PlayerName = 'Ally Miklesh' THEN 'https://clemsontigers.com/imgproxy/W6Aa7KV5_TqtoY60eODJ1ePdriNfuud29dzmchRTdeI/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjIvMTAvTWlrbGVzaEFsbHkucG5n.png'\n WHEN PlayerName = 'Kennedy Ariail' THEN 'https://clemsontigers.com/imgproxy/IyKb_pyJO7G79b8T-Nb8mLA3t6rc614q4B2eO9JbUns/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMDcvMS1BcmlhaWxLZW5uZWR5LnBuZw.png'\n WHEN PlayerName = 'Kylee Johnson' THEN 'https://clemsontigers.com/imgproxy/Lh2mJnZu5I4MF69x-pY8MlciDsH7RAEryB8LDpSLH5I/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMDcvMy1Kb2huc29uS3lsZWUucG5n.png'\n WHEN PlayerName = 'Lindsey Garcia' THEN 'https://clemsontigers.com/imgproxy/lRWyT_w25ETYDclBkJxWgzEteGAPmKi8uAyetJl_l2E/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMTAvNV9HYXJjaWFMaW5kc2V5LnBuZw.png'\n WHEN PlayerName = 'Riley Burton' THEN 'https://clemsontigers.com/imgproxy/Kesv3KqvqNV0UO8KPFmw8BHnmxB_9OFC0zuaIcetjF4/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMDcvMTAtQnVydG9uUmlsZXkucG5n.png'\n WHEN PlayerName = 'Julia Knowler' THEN 'https://clemsontigers.com/imgproxy/z1FUMpbNvU0x8d99rMPbQHR6pnSGoyaR1_tD65H4oKo/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMDcvMTItS25vd2xlckp1bGlhLnBuZw.png'\n WHEN PlayerName = 'Alex Brown' THEN 'https://clemsontigers.com/imgproxy/Bb0Hp33SD2kPTkCKR-1aGq6gIWJ--286c1rxaz3VYvM/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMTEvQnJvd25BbGV4LnBuZw.png'\n WHEN PlayerName = 'Olivia Duncan' THEN 'https://clemsontigers.com/imgproxy/8xS3im1ri8ynbEuegxHSIGEzelYV9TmrKeqT01TUuzg/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMDcvNDQtRHVuY2FuT2xpdmlhLnBuZw.png'\n WHEN PlayerName = 'Marian Collins' THEN 'https://clemsontigers.com/imgproxy/6QG-u2hTH1PsSwmPql6WweORJzrRjpLn4r1tMjAaFEw/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMDcvNS1Db2xsaW5zTWFyaWFuLnBuZw.png'\n WHEN PlayerName = 'Reese Basinger' THEN 'https://clemsontigers.com/imgproxy/GjXfLiiHe6NNf7KzRwTqvI2-2U60W4h98_sRMlTFWw0/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMTEvQmFzaW5nZXJSZWVzZS5wbmc.png'\n WHEN PlayerName = 'Cammy Pereira' THEN 'https://clemsontigers.com/imgproxy/LU7g5mLLPFNeUb54I1PSp745yocrza0f6sQhnviXUqc/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjEvMTIvUGVyZWlyYUNhbW15LnBuZw.png'\n WHEN PlayerName = 'Madi Lardizabal' THEN 'https://clemsontigers.com/imgproxy/KvTZJft0qGQBEYAwsLPZPh0VM1pge228zOoShCcuZ40/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMDcvOC1MYXJkaXphYmFsTWFkaS5wbmc.png'\n WHEN PlayerName = 'Jamison Brockenbrough' THEN 'https://clemsontigers.com/imgproxy/XMiyXsGSPBVvZuMd5SZUR6X44sL1nN9yQDaAVxiL_HE/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMDcvOS1Ccm9ja2VuYnJvdWdoSmFtaXNvbi5wbmc.png'\n WHEN PlayerName = 'Macey Cintron' THEN 'https://clemsontigers.com/imgproxy/HBV23UtucImkSFTw1dGbgrZxZOmRkosLBgOs_LxF_Tk/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMDcvMTYtQ2ludHJvbk1hY2V5LnBuZw.png'\n WHEN PlayerName = 'Ava Wilson' THEN 'https://clemsontigers.com/imgproxy/RbwWlFgOYd7hgi5m_WCzxojtUDPK-3CWgXpqgrH6ybA/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMDcvMTctV2lsc29uQXZhLnBuZw.png'\n WHEN PlayerName = 'Brook Melnychuk' THEN 'https://clemsontigers.com/imgproxy/LTvmV9Odxi0m3F-GNArM7vvqLz7v8iuSoGz57L7Yos8/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMTEvTWVsbnljaHVrQnJvb2sucG5n.png'\n WHEN PlayerName = 'Sam Minish' THEN 'https://clemsontigers.com/imgproxy/TQkRaZ3gmisU_Q3PIfOkmwUaa7cngnzEfYryPk3m4vM/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMDcvMjAtTWluaXNoU2FtLnBuZw.png'\n WHEN PlayerName = 'Taylor Pipkins' THEN 'https://clemsontigers.com/imgproxy/Aeq8qsNTBYANXgvQArpIrLhOIl6VVt22OngiuAVcTH4/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMDcvMjItUGlwa2luc1RheWxvci5wbmc.png'\n WHEN PlayerName = 'Riley Fennell' THEN 'https://clemsontigers.com/imgproxy/uR9YArgDvZLc6RoMirk3EUlqzQxZESKQy0UFxKjoWiI/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMDcvMjctRmVubmVsbFJpbGV5LnBuZw.png'\n WHEN PlayerName = 'Kiley Channell' THEN 'https://clemsontigers.com/imgproxy/yhjD_jYrQIfI--8mwBd_EXqjEgofiybe13ywJXJffCc/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjUvMDcvMi1DaGFubmVsbEtpbGV5LnBuZw.png'\n WHEN PlayerName = 'Abby Dunning' THEN 'https://clemsontigers.com/imgproxy/RA-e_-B6FlWqyNjRIhzfTmxgvqN4TeuQZeBDEv5W2HY/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjUvMDcvNC1EdW5uaW5nQWJieS5wbmc.png'\n WHEN PlayerName = 'Abi Stuart' THEN 'https://clemsontigers.com/imgproxy/IjW8DCFbXiGSPPRONiwyHh6ARa42hBZvQxVaXbYgBUk/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMTEvU3R1YXJ0QWJpLnBuZw.png'\n WHEN PlayerName = 'Sierra Maness' THEN 'https://clemsontigers.com/imgproxy/wnVAXaaZacRNbeWN9E9hSzOdjjyYJQnfV8mbQPIp94Y/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjUvMDcvNy1NYW5lc3NTaWVycmEucG5n.png'\n WHEN PlayerName = 'Mac Pavese' THEN 'https://clemsontigers.com/imgproxy/RLvKX6to3e5qvrOc-flBMxZ6ulFwkVuglAsxf8ze1MI/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjUvMDYvMTEtUGF2ZXNlTWFjLnBuZw.png'\n WHEN PlayerName = 'Maddie Johnson' THEN 'https://clemsontigers.com/imgproxy/EW7Bo0Yp22-kpYFG-i-0H-Ucfd6vXyz6syr_3e7oAnU/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjUvMDYvMTUtSm9obnNvbk1hZGRpZS5wbmc.png'\n WHEN PlayerName = 'Sophia Burmeister' THEN 'https://clemsontigers.com/imgproxy/HNnmh4BFSM4oJ5dxrq--el97qPCiP5J1Gz0S8oYgsZ0/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjUvMDYvMjMtQnVybWVpc3RlclNvcGhpYS5wbmc.png'\n WHEN PlayerName = 'Lexie Hames' THEN 'https://clemsontigers.com/imgproxy/0HTAsV9gQgfGLDMJPn1c9_-L3VE-cqxmsT4lGvk_-jA/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjUvMDYvMzMtSGFtZXNMZXhpZS5wbmc.png'\n WHEN PlayerName = 'Sarah Rocheleau' THEN 'https://clemsontigers.com/imgproxy/Elc6QDX9RJWUlz5i_I65ISj9K6uJXyBZftvqOb61unw/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjUvMDYvMzctUm9jaGVsZWF1U2FyYWgucG5n.png'\n WHEN PlayerName = 'Keira Crosby' THEN 'https://clemsontigers.com/imgproxy/4jzGey11_L3_KMjGKuEbtHajyoO8_F0rRgbzc6_JiBk/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjUvMDYvNDMtQ3Jvc2J5S2VpcmEucG5n.png'\n WHEN PlayerName = 'Sarah Breaux' THEN 'https://clemsontigers.com/imgproxy/mEruwy8vdlWDFdnMkTYcAdZRhjxvcyVLKoazUub6YTE/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjUvMDYvNjYtQnJlYXV4U2FyYWgucG5n.png'\n WHEN PlayerName = 'Corri Hicks' THEN 'https://clemsontigers.com/imgproxy/S4wNlyuZgrYqYLtqJBTsHNJgp2FbAlHPJupLoaXt31g/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjUvMDcvOTktSGlja3NDb3JyaS5wbmc.png'\n WHEN PlayerName = 'Madison May' THEN 'https://clemsontigers.com/imgproxy/SGKMk7T8bt3SjlEMVyV7t-CQS4HCawiiX7WOCe8OUXs/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjIvMTAvTWF5TWFkaXNvbi5wbmc.png'\n WHEN PlayerName = 'Alia Logoleo' THEN 'https://clemsontigers.com/imgproxy/VnJFNRLFxcnoVXjyyFVywWLo4OJKiMT86V83kS7X52I/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMTAvMTZfTG9nb2xlb0FsaWEucG5n.png'\n WHEN PlayerName = 'Bailey Taylor' THEN 'https://clemsontigers.com/imgproxy/g-1eJJc5DHoMpLim2If_yA9CIJ_apOM0oh101-d43bU/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjEvMTIvVGF5bG9yQmFpbGV5LnBuZw.png'\n END AS Photo_URL\n FROM Rosters)\n, JerseyNumbers AS (SELECT PlayerID,\n PlayerName,\n mode(PlayerNumber) AS PlayerNumber\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE SchoolId = 279 \n AND PlayerNumber IS NOT NULL AND CAST(PlayerNumber AS VARCHAR) <> ''\n GROUP BY PlayerID, PlayerName)\nSELECT DISTINCT\n RP.PlayerName,\n RP.LastName,\n RP.PlayerID,\n RP.LastSeason,\n RP.Photo_URL,\n JN.PlayerNumber\n FROM Rosters_Photos AS RP\n LEFT JOIN JerseyNumbers AS JN\n ON RP.PlayerID = JN.PlayerID\n ORDER BY RP.LastName","inputQueryString":"-- Builds the master Clemson softball roster/profile list with player photos and jersey numbers.\n\nWITH Rosters AS (SELECT CONCAT(FirstName,' ', Lastname) AS PlayerName,\n LastName,\n PlayerId,\n LastSeason\n FROM SPORTS_INFO_DW_REPORTING.vw_cuad_player\n WHERE SportCode = 'SFTB')\n, Rosters_Photos AS (SELECT PlayerName,\n LastName,\n PlayerId,\n LastSeason,\n CASE WHEN PlayerName = 'Valerie Frank' THEN 'https://clemsontigers.com/imgproxy/_SDRTKiAMRcL8x8-R4eaoVPPMaIXGGvJHk2ThxOfhWM/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjAvMDIvRnJhbmtWYWxlcmllLmpwZw.jpg'\n WHEN PlayerName = 'JoJo Hyatt' THEN 'https://clemsontigers.com/imgproxy/rj-vD9Szk-ZXMiVObQ1-rBz9SC2TGGLNIT-16FoCvPE/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMTAvMjNfSHlhdHRKb0pvLnBuZw.png'\n WHEN PlayerName = 'Arielle Oda' THEN 'https://clemsontigers.com/imgproxy/rco96zwtFS0uLCiV_egQQb7rGJy0CFw8gcjWRSWdF0Y/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMTAvMjRfT2RhQXJpZWxsZS5wbmc.png'\n WHEN PlayerName = 'Marissa Guimbarda' THEN 'https://clemsontigers.com/imgproxy/EEriqZMajrWHXOZmbizKjWQff160UPMKvMJExBH3fvE/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjEvMTIvR3VpbWJhcmRhTWFyaXNzYS5wbmc.png'\n WHEN PlayerName = 'Grace Mattimore' THEN 'https://clemsontigers.com/imgproxy/V-3PFwwxL0sUvCp58AtqYQXC1pVk1Nnpjv8SqL-ylwM/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjEvMTIvTWF0dGltb3JlR3JhY2UucG5n.png'\n WHEN PlayerName = 'MK Bonamy' THEN 'https://clemsontigers.com/imgproxy/zzFHaJ6dW_FTBJzSykX4v6tbe_2ScW2Lmo5hIpcPM6I/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjAvMDEvQm9uYW15TUstMi5qcGc.jpg'\n WHEN PlayerName = 'Logan Caymol' THEN 'https://clemsontigers.com/imgproxy/fx_F2oRHwxK5FN760IdDqE6qRTE9c4_Kfn2y0D7zwqw/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjAvMDEvQ2F5bW9sTG9nYW4tc2NhbGVkLWUxNjA1NTM2MDkzNjY0LmpwZw.jpg'\n WHEN PlayerName = 'Morgan Johnson' THEN 'https://clemsontigers.com/imgproxy/Oykbh0iw1gZxo0tEqskDl7VIRNfpCwpQqreQfxFgeIE/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjIvMTAvSm9obnNvbk1vcmdhbi5wbmc.png'\n WHEN PlayerName = 'Kyah Keller' THEN 'https://clemsontigers.com/imgproxy/bZ2CGXzfjPodTc26LmpYVuRNlRGEXlImx5Zd7vg8Vcg/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjIvMTAvS2VsbGVyS3lhaC5wbmc.png'\n WHEN PlayerName = 'Valerie Cagle' THEN 'https://clemsontigers.com/imgproxy/3wY6Z5spr4CBFLEFzeAww65beeNlbtgsgrSV_9sLOxY/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMTAvNzJfQ2FnbGVWYWxlcmllLnBuZw.png'\n WHEN PlayerName = 'Hannah Goodwin' THEN 'https://clemsontigers.com/imgproxy/jceToqu-OOoPaH_yrg6hLf9ikPmRyOqVlCdXhSbifSc/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMTkvMDgvR29vZHdpbkhhbm5haC5wbmc.png'\n WHEN PlayerName = 'Carlee Shannon' THEN 'https://clemsontigers.com/imgproxy/2LdwlS4oE09Hba7--hGVqpD2jNFMpbJj9xrR7ljnjAQ/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjEvMTIvU2hhbm5vbkNhcmxlZS5wbmc.png'\n WHEN PlayerName = 'Casey Bigham' THEN 'https://clemsontigers.com/imgproxy/zqtEIsiwnKd7WEsJaINH_Pc7g-9AiX1O4DPD1KW-GOk/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjAvMDgvQmlnaGFtQ2FzZXkuanBn.jpg'\n WHEN PlayerName = 'Ansley Houston' THEN 'https://clemsontigers.com/imgproxy/eEW8frgRRaZ0Ub1jzTFE1SgHT6xdennVU7ORYdAbMgY/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjIvMTAvSG91c3RvbkFuc2xleS5wbmc.png'\n WHEN PlayerName = 'McKenzie Clark' THEN 'https://clemsontigers.com/imgproxy/sW4TF2laF_wV4G7h3dmiYS8cmfnvwfi1NBGYiA6fbJM/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMTAvN19DbGFya01jS2VuemllLnBuZw.png'\n WHEN PlayerName = 'Sarah Howell' THEN 'https://clemsontigers.com/imgproxy/NZQpcTEhHvT1xH786vm7ogV37i4rEVX-Cnt-Us1xizU/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjIvMTAvSG93ZWxsU2FyYWgucG5n.png'\n WHEN PlayerName = 'Regan Spencer' THEN 'https://clemsontigers.com/imgproxy/EHMz_AFgrGDgBkAsFCUE0wHzkkYzIIelQZyqqZ7cNr4/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMTAvMTlfU3BlbmNlclJlZ2FuLnBuZw.png'\n WHEN PlayerName = 'Jaden Cheek' THEN 'https://clemsontigers.com/imgproxy/AaRXcy6qe3EXX7nl-banBpdusiQ7vpLOW-88IRJ6G3c/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjEvMTIvQ2hlZWtKYWRlbi5wbmc.png'\n WHEN PlayerName = 'Carsten Puckett' THEN 'https://clemsontigers.com/imgproxy/IjDeGGQxHQMzMF6e1qvFUUX1Z4T8w-rQCi1Jn7gfw48/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjAvMDgvUHVja2V0dENhcnN0ZW4uanBn.jpg'\n WHEN PlayerName = 'Millie Thompson' THEN 'https://clemsontigers.com/imgproxy/e3RUq7wmuZUAkCIXOd2ZS60Ujr0GtluBWpoI3Wgr8yM/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMTAvODdfVGhvbXBzb25NaWxsaWUucG5n.png'\n WHEN PlayerName = 'Rachel Gibson' THEN 'https://clemsontigers.com/imgproxy/DHoBapuuSa9-3hL6-CKFHWa_O1G6McdMPLIgaZx6H4I/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjIvMTAvR2lic29uUmFjaGVsLnBuZw.png'\n WHEN PlayerName = 'Brooke McCubbin' THEN 'https://clemsontigers.com/imgproxy/RZs988wLvb-vUplaYWDxVVADnxF3ptp1tE33KifXrVs/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMTEvTWNDdWJiaW5Ccm9va2UucG5n.png'\n WHEN PlayerName = 'Ansley Gilstrap' THEN 'https://clemsontigers.com/imgproxy/Xl2jfHrlEBtF4Y5n5CWW15D7EzQYjaieHBaRtF7a-zU/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjAvMDgvR2lsc3RyYXBBbnNsZXkuanBn.jpg'\n WHEN PlayerName = 'Sam Russ' THEN 'https://clemsontigers.com/imgproxy/HkQ86kq6ChH_R8JMoRLD8Z68ximka91ddhPlv3lGpJA/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjEvMTIvUnVzc1NhbS5wbmc.png'\n WHEN PlayerName = 'Aby Vieira' THEN 'https://clemsontigers.com/imgproxy/1VkzI7qYH7-UzY85RaYHPMgA1tKSiNJb815JVlxR2mQ/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMTEvVmllaXJhQWJ5LnBuZw.png'\n WHEN PlayerName = 'Grace Hiller' THEN 'https://clemsontigers.com/imgproxy/Kt4K-FFLsTWTS-fO4_we31dmVJZjcs3ehMuTIJ1789Y/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMTAvOF9IaWxsZXJHcmFjZS5wbmc.png'\n WHEN PlayerName = 'Haylee Whitesides' THEN 'https://clemsontigers.com/imgproxy/YFSk3qR6Ji4u10CYN-py_exw2ev7qqfIkNZj4l4k6Z4/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMTEvV2hpdGVzaWRlc0hheWxlZS5wbmc.png'\n WHEN PlayerName = 'Jadeyn Ruszkowski' THEN 'https://clemsontigers.com/imgproxy/lZJlwRnlGjvpzXaUbZydpnrzX8cxT66PV0MVhs4aekI/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMTEvUnVzemtvd3NraUphZGV5bi5wbmc.png'\n WHEN PlayerName = 'Maddie Moore' THEN 'https://clemsontigers.com/imgproxy/K20BP0TZo5mTOUWIa7qrdzccoRvgR7wXMA0qz4X19QY/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMTEvTW9vcmVNYWRkaWUucG5n.png'\n WHEN PlayerName = 'Marena Knowles' THEN 'https://clemsontigers.com/imgproxy/5Y1SKUWe3c-inR44fp1P6AUNmSK0Q5dzWNnb4gb1VYM/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMTAvMDBfS25vd2xlc01hcmVuYS5wbmc.png'\n WHEN PlayerName = 'Reedy Davenport' THEN 'https://clemsontigers.com/imgproxy/bSveNNjrKlt-Tg0rZereASni4ZwNCJZqtIcXPBX7kB4/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjIvMTAvRGF2ZW5wb3J0UmVlZHkucG5n.png'\n WHEN PlayerName = 'Julia Bomhardt' THEN 'https://clemsontigers.com/imgproxy/0rfuv7ORU8ow1z9uNs4QeitY_nI7ZlruH6c-pQJicWM/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMTAvNl9Cb21oYXJkdEp1bGlhLnBuZw.png'\n WHEN PlayerName = 'Caroline Jacobsen' THEN 'https://clemsontigers.com/imgproxy/VfxK0GODvXkRKd_Z0wgzY_WiHeFiX-PaVBbwCq8H2Eg/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjIvMTAvSmFjb2JzZW5DYXJvbGluZS5wbmc.png'\n WHEN PlayerName = 'Emma Whitfield' THEN 'https://clemsontigers.com/imgproxy/mFSGMWLTh8p0t4LKIsCWGOVskCeoqkfyPbWNkN_-rLw/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjEvMTIvV2hpdGZpZWxkRW1tYS5wbmc.png'\n WHEN PlayerName = 'Ally Miklesh' THEN 'https://clemsontigers.com/imgproxy/W6Aa7KV5_TqtoY60eODJ1ePdriNfuud29dzmchRTdeI/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjIvMTAvTWlrbGVzaEFsbHkucG5n.png'\n WHEN PlayerName = 'Kennedy Ariail' THEN 'https://clemsontigers.com/imgproxy/IyKb_pyJO7G79b8T-Nb8mLA3t6rc614q4B2eO9JbUns/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMDcvMS1BcmlhaWxLZW5uZWR5LnBuZw.png'\n WHEN PlayerName = 'Kylee Johnson' THEN 'https://clemsontigers.com/imgproxy/Lh2mJnZu5I4MF69x-pY8MlciDsH7RAEryB8LDpSLH5I/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMDcvMy1Kb2huc29uS3lsZWUucG5n.png'\n WHEN PlayerName = 'Lindsey Garcia' THEN 'https://clemsontigers.com/imgproxy/lRWyT_w25ETYDclBkJxWgzEteGAPmKi8uAyetJl_l2E/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMTAvNV9HYXJjaWFMaW5kc2V5LnBuZw.png'\n WHEN PlayerName = 'Riley Burton' THEN 'https://clemsontigers.com/imgproxy/Kesv3KqvqNV0UO8KPFmw8BHnmxB_9OFC0zuaIcetjF4/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMDcvMTAtQnVydG9uUmlsZXkucG5n.png'\n WHEN PlayerName = 'Julia Knowler' THEN 'https://clemsontigers.com/imgproxy/z1FUMpbNvU0x8d99rMPbQHR6pnSGoyaR1_tD65H4oKo/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMDcvMTItS25vd2xlckp1bGlhLnBuZw.png'\n WHEN PlayerName = 'Alex Brown' THEN 'https://clemsontigers.com/imgproxy/Bb0Hp33SD2kPTkCKR-1aGq6gIWJ--286c1rxaz3VYvM/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMTEvQnJvd25BbGV4LnBuZw.png'\n WHEN PlayerName = 'Olivia Duncan' THEN 'https://clemsontigers.com/imgproxy/8xS3im1ri8ynbEuegxHSIGEzelYV9TmrKeqT01TUuzg/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMDcvNDQtRHVuY2FuT2xpdmlhLnBuZw.png'\n WHEN PlayerName = 'Marian Collins' THEN 'https://clemsontigers.com/imgproxy/6QG-u2hTH1PsSwmPql6WweORJzrRjpLn4r1tMjAaFEw/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMDcvNS1Db2xsaW5zTWFyaWFuLnBuZw.png'\n WHEN PlayerName = 'Reese Basinger' THEN 'https://clemsontigers.com/imgproxy/GjXfLiiHe6NNf7KzRwTqvI2-2U60W4h98_sRMlTFWw0/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMTEvQmFzaW5nZXJSZWVzZS5wbmc.png'\n WHEN PlayerName = 'Cammy Pereira' THEN 'https://clemsontigers.com/imgproxy/LU7g5mLLPFNeUb54I1PSp745yocrza0f6sQhnviXUqc/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjEvMTIvUGVyZWlyYUNhbW15LnBuZw.png'\n WHEN PlayerName = 'Madi Lardizabal' THEN 'https://clemsontigers.com/imgproxy/KvTZJft0qGQBEYAwsLPZPh0VM1pge228zOoShCcuZ40/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMDcvOC1MYXJkaXphYmFsTWFkaS5wbmc.png'\n WHEN PlayerName = 'Jamison Brockenbrough' THEN 'https://clemsontigers.com/imgproxy/XMiyXsGSPBVvZuMd5SZUR6X44sL1nN9yQDaAVxiL_HE/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMDcvOS1Ccm9ja2VuYnJvdWdoSmFtaXNvbi5wbmc.png'\n WHEN PlayerName = 'Macey Cintron' THEN 'https://clemsontigers.com/imgproxy/HBV23UtucImkSFTw1dGbgrZxZOmRkosLBgOs_LxF_Tk/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMDcvMTYtQ2ludHJvbk1hY2V5LnBuZw.png'\n WHEN PlayerName = 'Ava Wilson' THEN 'https://clemsontigers.com/imgproxy/RbwWlFgOYd7hgi5m_WCzxojtUDPK-3CWgXpqgrH6ybA/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMDcvMTctV2lsc29uQXZhLnBuZw.png'\n WHEN PlayerName = 'Brook Melnychuk' THEN 'https://clemsontigers.com/imgproxy/LTvmV9Odxi0m3F-GNArM7vvqLz7v8iuSoGz57L7Yos8/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMTEvTWVsbnljaHVrQnJvb2sucG5n.png'\n WHEN PlayerName = 'Sam Minish' THEN 'https://clemsontigers.com/imgproxy/TQkRaZ3gmisU_Q3PIfOkmwUaa7cngnzEfYryPk3m4vM/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMDcvMjAtTWluaXNoU2FtLnBuZw.png'\n WHEN PlayerName = 'Taylor Pipkins' THEN 'https://clemsontigers.com/imgproxy/Aeq8qsNTBYANXgvQArpIrLhOIl6VVt22OngiuAVcTH4/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMDcvMjItUGlwa2luc1RheWxvci5wbmc.png'\n WHEN PlayerName = 'Riley Fennell' THEN 'https://clemsontigers.com/imgproxy/uR9YArgDvZLc6RoMirk3EUlqzQxZESKQy0UFxKjoWiI/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMDcvMjctRmVubmVsbFJpbGV5LnBuZw.png'\n WHEN PlayerName = 'Kiley Channell' THEN 'https://clemsontigers.com/imgproxy/yhjD_jYrQIfI--8mwBd_EXqjEgofiybe13ywJXJffCc/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjUvMDcvMi1DaGFubmVsbEtpbGV5LnBuZw.png'\n WHEN PlayerName = 'Abby Dunning' THEN 'https://clemsontigers.com/imgproxy/RA-e_-B6FlWqyNjRIhzfTmxgvqN4TeuQZeBDEv5W2HY/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjUvMDcvNC1EdW5uaW5nQWJieS5wbmc.png'\n WHEN PlayerName = 'Abi Stuart' THEN 'https://clemsontigers.com/imgproxy/IjW8DCFbXiGSPPRONiwyHh6ARa42hBZvQxVaXbYgBUk/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMTEvU3R1YXJ0QWJpLnBuZw.png'\n WHEN PlayerName = 'Sierra Maness' THEN 'https://clemsontigers.com/imgproxy/wnVAXaaZacRNbeWN9E9hSzOdjjyYJQnfV8mbQPIp94Y/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjUvMDcvNy1NYW5lc3NTaWVycmEucG5n.png'\n WHEN PlayerName = 'Mac Pavese' THEN 'https://clemsontigers.com/imgproxy/RLvKX6to3e5qvrOc-flBMxZ6ulFwkVuglAsxf8ze1MI/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjUvMDYvMTEtUGF2ZXNlTWFjLnBuZw.png'\n WHEN PlayerName = 'Maddie Johnson' THEN 'https://clemsontigers.com/imgproxy/EW7Bo0Yp22-kpYFG-i-0H-Ucfd6vXyz6syr_3e7oAnU/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjUvMDYvMTUtSm9obnNvbk1hZGRpZS5wbmc.png'\n WHEN PlayerName = 'Sophia Burmeister' THEN 'https://clemsontigers.com/imgproxy/HNnmh4BFSM4oJ5dxrq--el97qPCiP5J1Gz0S8oYgsZ0/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjUvMDYvMjMtQnVybWVpc3RlclNvcGhpYS5wbmc.png'\n WHEN PlayerName = 'Lexie Hames' THEN 'https://clemsontigers.com/imgproxy/0HTAsV9gQgfGLDMJPn1c9_-L3VE-cqxmsT4lGvk_-jA/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjUvMDYvMzMtSGFtZXNMZXhpZS5wbmc.png'\n WHEN PlayerName = 'Sarah Rocheleau' THEN 'https://clemsontigers.com/imgproxy/Elc6QDX9RJWUlz5i_I65ISj9K6uJXyBZftvqOb61unw/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjUvMDYvMzctUm9jaGVsZWF1U2FyYWgucG5n.png'\n WHEN PlayerName = 'Keira Crosby' THEN 'https://clemsontigers.com/imgproxy/4jzGey11_L3_KMjGKuEbtHajyoO8_F0rRgbzc6_JiBk/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjUvMDYvNDMtQ3Jvc2J5S2VpcmEucG5n.png'\n WHEN PlayerName = 'Sarah Breaux' THEN 'https://clemsontigers.com/imgproxy/mEruwy8vdlWDFdnMkTYcAdZRhjxvcyVLKoazUub6YTE/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjUvMDYvNjYtQnJlYXV4U2FyYWgucG5n.png'\n WHEN PlayerName = 'Corri Hicks' THEN 'https://clemsontigers.com/imgproxy/S4wNlyuZgrYqYLtqJBTsHNJgp2FbAlHPJupLoaXt31g/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjUvMDcvOTktSGlja3NDb3JyaS5wbmc.png'\n WHEN PlayerName = 'Madison May' THEN 'https://clemsontigers.com/imgproxy/SGKMk7T8bt3SjlEMVyV7t-CQS4HCawiiX7WOCe8OUXs/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjIvMTAvTWF5TWFkaXNvbi5wbmc.png'\n WHEN PlayerName = 'Alia Logoleo' THEN 'https://clemsontigers.com/imgproxy/VnJFNRLFxcnoVXjyyFVywWLo4OJKiMT86V83kS7X52I/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMTAvMTZfTG9nb2xlb0FsaWEucG5n.png'\n WHEN PlayerName = 'Bailey Taylor' THEN 'https://clemsontigers.com/imgproxy/g-1eJJc5DHoMpLim2If_yA9CIJ_apOM0oh101-d43bU/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjEvMTIvVGF5bG9yQmFpbGV5LnBuZw.png'\n END AS Photo_URL\n FROM Rosters)\n, JerseyNumbers AS (SELECT PlayerID,\n PlayerName,\n mode(PlayerNumber) AS PlayerNumber\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE SchoolId = 279 \n AND PlayerNumber IS NOT NULL AND CAST(PlayerNumber AS VARCHAR) <> ''\n GROUP BY PlayerID, PlayerName)\nSELECT DISTINCT\n RP.PlayerName,\n RP.LastName,\n RP.PlayerID,\n RP.LastSeason,\n RP.Photo_URL,\n JN.PlayerNumber\n FROM Rosters_Photos AS RP\n LEFT JOIN JerseyNumbers AS JN\n ON RP.PlayerID = JN.PlayerID\n ORDER BY RP.LastName","compiled":false,"inline":false},{"id":"player_radar_batting","compiledQueryString":"-- Builds selected-player, average-player, and max-player batting series for profile radar charts.\n\nWITH TargetPlayer AS (\n SELECT \n 'selected_player' AS series,\n SUM(Hitter_Hits) - SUM(Hitter_Doubles) - SUM(Hitter_Triples) - SUM(Hitter_HomeRun) AS singles,\n\n ROUND(1.0 * (SUM(COALESCE(Hitter_Hits, 0)) + SUM(COALESCE(Hitter_BaseOnBalls, 0)) \n + SUM(COALESCE(Hitter_HitbyPitch, 0))) / NULLIF(SUM(COALESCE(Hitter_AtBats, 0)) + \n SUM(COALESCE(Hitter_BaseOnBalls, 0)) + SUM(COALESCE(Hitter_HitbyPitch, 0)) + \n SUM(COALESCE(Hitter_SacrificeFlies, 0)), 0), 3) AS OBP,\n\n SUM(Hitter_HomeRun) AS HR,\n SUM(Hitter_Doubles) AS doubles,\n SUM(Hitter_Triples) AS triples\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE GamesPlayed > 0\n AND TeamName = 'Clemson'\n And PlayerName = '${params.PlayerName}'\n),\nAllPlayers AS (\n SELECT \n PlayerName,\n SUM(Hitter_Hits) - SUM(Hitter_Doubles) - SUM(Hitter_Triples) - SUM(Hitter_HomeRun) AS s,\n\n ROUND(1.0 * (SUM(COALESCE(Hitter_Hits, 0)) + SUM(COALESCE(Hitter_BaseOnBalls, 0)) \n + SUM(COALESCE(Hitter_HitbyPitch, 0))) / NULLIF(SUM(COALESCE(Hitter_AtBats, 0)) + \n SUM(COALESCE(Hitter_BaseOnBalls, 0)) + SUM(COALESCE(Hitter_HitbyPitch, 0)) + \n SUM(COALESCE(Hitter_SacrificeFlies, 0)), 0), 3) AS obp,\n\n SUM(Hitter_HomeRun) AS hr,\n SUM(Hitter_Doubles) AS d,\n SUM(Hitter_Triples) AS t\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE TeamName = 'Clemson' \n AND GamesPlayed > 0\n GROUP BY PlayerName\n),\nAverages AS (\n SELECT \n 'average' AS series,\n AVG(s) AS singles,\n AVG(obp) AS OBP,\n AVG(hr) AS HR,\n AVG(d) AS doubles,\n AVG(t) AS triples\n FROM AllPlayers\n),\nMaxValues AS (\n SELECT \n 'max' AS series,\n MAX(s) AS singles,\n MAX(obp) AS OBP,\n MAX(hr) AS HR,\n MAX(d) AS doubles,\n MAX(t) AS triples\n FROM AllPlayers\n)\nSELECT * FROM TargetPlayer\nUNION ALL\nSELECT * FROM Averages\nUNION ALL\nSELECT * FROM MaxValues","inputQueryString":"-- Builds selected-player, average-player, and max-player batting series for profile radar charts.\n\nWITH TargetPlayer AS (\n SELECT \n 'selected_player' AS series,\n SUM(Hitter_Hits) - SUM(Hitter_Doubles) - SUM(Hitter_Triples) - SUM(Hitter_HomeRun) AS singles,\n\n ROUND(1.0 * (SUM(COALESCE(Hitter_Hits, 0)) + SUM(COALESCE(Hitter_BaseOnBalls, 0)) \n + SUM(COALESCE(Hitter_HitbyPitch, 0))) / NULLIF(SUM(COALESCE(Hitter_AtBats, 0)) + \n SUM(COALESCE(Hitter_BaseOnBalls, 0)) + SUM(COALESCE(Hitter_HitbyPitch, 0)) + \n SUM(COALESCE(Hitter_SacrificeFlies, 0)), 0), 3) AS OBP,\n\n SUM(Hitter_HomeRun) AS HR,\n SUM(Hitter_Doubles) AS doubles,\n SUM(Hitter_Triples) AS triples\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE GamesPlayed > 0\n AND TeamName = 'Clemson'\n And PlayerName = '${params.PlayerName}'\n),\nAllPlayers AS (\n SELECT \n PlayerName,\n SUM(Hitter_Hits) - SUM(Hitter_Doubles) - SUM(Hitter_Triples) - SUM(Hitter_HomeRun) AS s,\n\n ROUND(1.0 * (SUM(COALESCE(Hitter_Hits, 0)) + SUM(COALESCE(Hitter_BaseOnBalls, 0)) \n + SUM(COALESCE(Hitter_HitbyPitch, 0))) / NULLIF(SUM(COALESCE(Hitter_AtBats, 0)) + \n SUM(COALESCE(Hitter_BaseOnBalls, 0)) + SUM(COALESCE(Hitter_HitbyPitch, 0)) + \n SUM(COALESCE(Hitter_SacrificeFlies, 0)), 0), 3) AS obp,\n\n SUM(Hitter_HomeRun) AS hr,\n SUM(Hitter_Doubles) AS d,\n SUM(Hitter_Triples) AS t\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE TeamName = 'Clemson' \n AND GamesPlayed > 0\n GROUP BY PlayerName\n),\nAverages AS (\n SELECT \n 'average' AS series,\n AVG(s) AS singles,\n AVG(obp) AS OBP,\n AVG(hr) AS HR,\n AVG(d) AS doubles,\n AVG(t) AS triples\n FROM AllPlayers\n),\nMaxValues AS (\n SELECT \n 'max' AS series,\n MAX(s) AS singles,\n MAX(obp) AS OBP,\n MAX(hr) AS HR,\n MAX(d) AS doubles,\n MAX(t) AS triples\n FROM AllPlayers\n)\nSELECT * FROM TargetPlayer\nUNION ALL\nSELECT * FROM Averages\nUNION ALL\nSELECT * FROM MaxValues","compiled":false,"inline":false},{"id":"player_radar_pitching","compiledQueryString":"-- Builds selected-player, average-player, and max-player pitching series for profile radar charts.\n\nWITH TargetPlayer AS (\n SELECT \n 'selected_player' AS series,\n SUM(Pitcher_StrikeOuts) AS strikeouts,\n SUM(Pitcher_BaseOnBalls) AS walks,\n SUM(Pitcher_BattersFaced) AS batters,\n SUM(Pitcher_Pitches) AS pitches\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE PlayerName = '${params.PlayerName}'\n AND TeamName = 'Clemson'\n AND GamesPlayed > 0\n AND Pitcher_Appearances > 0\n),\nAllPlayers AS (\n SELECT \n PlayerName,\n SUM(Pitcher_StrikeOuts) AS s,\n SUM(Pitcher_BaseOnBalls) AS w,\n SUM(Pitcher_BattersFaced) AS b,\n SUM(Pitcher_Pitches) AS p\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE TeamName = 'Clemson' \n AND GamesPlayed > 0\n AND Pitcher_Appearances > 0\n GROUP BY PlayerName\n),\nAverages AS (\n SELECT \n 'average' AS series,\n AVG(s) AS strikeouts,\n AVG(w) AS walks,\n AVG(b) AS batters,\n AVG(p) AS pitches\n FROM AllPlayers\n),\nMaxValues AS (\n SELECT \n 'max' AS series,\n MAX(s) AS strikeouts,\n MAX(w) AS walks,\n MAX(b) AS batters,\n MAX(p) AS pitches\n FROM AllPlayers\n)\nSELECT * FROM TargetPlayer\nUNION ALL\nSELECT * FROM Averages\nUNION ALL\nSELECT * FROM MaxValues","inputQueryString":"-- Builds selected-player, average-player, and max-player pitching series for profile radar charts.\n\nWITH TargetPlayer AS (\n SELECT \n 'selected_player' AS series,\n SUM(Pitcher_StrikeOuts) AS strikeouts,\n SUM(Pitcher_BaseOnBalls) AS walks,\n SUM(Pitcher_BattersFaced) AS batters,\n SUM(Pitcher_Pitches) AS pitches\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE PlayerName = '${params.PlayerName}'\n AND TeamName = 'Clemson'\n AND GamesPlayed > 0\n AND Pitcher_Appearances > 0\n),\nAllPlayers AS (\n SELECT \n PlayerName,\n SUM(Pitcher_StrikeOuts) AS s,\n SUM(Pitcher_BaseOnBalls) AS w,\n SUM(Pitcher_BattersFaced) AS b,\n SUM(Pitcher_Pitches) AS p\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE TeamName = 'Clemson' \n AND GamesPlayed > 0\n AND Pitcher_Appearances > 0\n GROUP BY PlayerName\n),\nAverages AS (\n SELECT \n 'average' AS series,\n AVG(s) AS strikeouts,\n AVG(w) AS walks,\n AVG(b) AS batters,\n AVG(p) AS pitches\n FROM AllPlayers\n),\nMaxValues AS (\n SELECT \n 'max' AS series,\n MAX(s) AS strikeouts,\n MAX(w) AS walks,\n MAX(b) AS batters,\n MAX(p) AS pitches\n FROM AllPlayers\n)\nSELECT * FROM TargetPlayer\nUNION ALL\nSELECT * FROM Averages\nUNION ALL\nSELECT * FROM MaxValues","compiled":false,"inline":false},{"id":"profile_pages_filtered","compiledQueryString":"-- Returns the roster/profile card row for the selected player profile.\n\nSELECT PlayerName, LastName, PlayerID, LastSeason, Photo_URL, PlayerNumber, '/player-profiles/' || PlayerName as link\nFROM (-- Builds the master Clemson softball roster/profile list with player photos and jersey numbers.\n\nWITH Rosters AS (SELECT CONCAT(FirstName,' ', Lastname) AS PlayerName,\n LastName,\n PlayerId,\n LastSeason\n FROM SPORTS_INFO_DW_REPORTING.vw_cuad_player\n WHERE SportCode = 'SFTB')\n, Rosters_Photos AS (SELECT PlayerName,\n LastName,\n PlayerId,\n LastSeason,\n CASE WHEN PlayerName = 'Valerie Frank' THEN 'https://clemsontigers.com/imgproxy/_SDRTKiAMRcL8x8-R4eaoVPPMaIXGGvJHk2ThxOfhWM/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjAvMDIvRnJhbmtWYWxlcmllLmpwZw.jpg'\n WHEN PlayerName = 'JoJo Hyatt' THEN 'https://clemsontigers.com/imgproxy/rj-vD9Szk-ZXMiVObQ1-rBz9SC2TGGLNIT-16FoCvPE/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMTAvMjNfSHlhdHRKb0pvLnBuZw.png'\n WHEN PlayerName = 'Arielle Oda' THEN 'https://clemsontigers.com/imgproxy/rco96zwtFS0uLCiV_egQQb7rGJy0CFw8gcjWRSWdF0Y/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMTAvMjRfT2RhQXJpZWxsZS5wbmc.png'\n WHEN PlayerName = 'Marissa Guimbarda' THEN 'https://clemsontigers.com/imgproxy/EEriqZMajrWHXOZmbizKjWQff160UPMKvMJExBH3fvE/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjEvMTIvR3VpbWJhcmRhTWFyaXNzYS5wbmc.png'\n WHEN PlayerName = 'Grace Mattimore' THEN 'https://clemsontigers.com/imgproxy/V-3PFwwxL0sUvCp58AtqYQXC1pVk1Nnpjv8SqL-ylwM/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjEvMTIvTWF0dGltb3JlR3JhY2UucG5n.png'\n WHEN PlayerName = 'MK Bonamy' THEN 'https://clemsontigers.com/imgproxy/zzFHaJ6dW_FTBJzSykX4v6tbe_2ScW2Lmo5hIpcPM6I/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjAvMDEvQm9uYW15TUstMi5qcGc.jpg'\n WHEN PlayerName = 'Logan Caymol' THEN 'https://clemsontigers.com/imgproxy/fx_F2oRHwxK5FN760IdDqE6qRTE9c4_Kfn2y0D7zwqw/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjAvMDEvQ2F5bW9sTG9nYW4tc2NhbGVkLWUxNjA1NTM2MDkzNjY0LmpwZw.jpg'\n WHEN PlayerName = 'Morgan Johnson' THEN 'https://clemsontigers.com/imgproxy/Oykbh0iw1gZxo0tEqskDl7VIRNfpCwpQqreQfxFgeIE/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjIvMTAvSm9obnNvbk1vcmdhbi5wbmc.png'\n WHEN PlayerName = 'Kyah Keller' THEN 'https://clemsontigers.com/imgproxy/bZ2CGXzfjPodTc26LmpYVuRNlRGEXlImx5Zd7vg8Vcg/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjIvMTAvS2VsbGVyS3lhaC5wbmc.png'\n WHEN PlayerName = 'Valerie Cagle' THEN 'https://clemsontigers.com/imgproxy/3wY6Z5spr4CBFLEFzeAww65beeNlbtgsgrSV_9sLOxY/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMTAvNzJfQ2FnbGVWYWxlcmllLnBuZw.png'\n WHEN PlayerName = 'Hannah Goodwin' THEN 'https://clemsontigers.com/imgproxy/jceToqu-OOoPaH_yrg6hLf9ikPmRyOqVlCdXhSbifSc/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMTkvMDgvR29vZHdpbkhhbm5haC5wbmc.png'\n WHEN PlayerName = 'Carlee Shannon' THEN 'https://clemsontigers.com/imgproxy/2LdwlS4oE09Hba7--hGVqpD2jNFMpbJj9xrR7ljnjAQ/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjEvMTIvU2hhbm5vbkNhcmxlZS5wbmc.png'\n WHEN PlayerName = 'Casey Bigham' THEN 'https://clemsontigers.com/imgproxy/zqtEIsiwnKd7WEsJaINH_Pc7g-9AiX1O4DPD1KW-GOk/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjAvMDgvQmlnaGFtQ2FzZXkuanBn.jpg'\n WHEN PlayerName = 'Ansley Houston' THEN 'https://clemsontigers.com/imgproxy/eEW8frgRRaZ0Ub1jzTFE1SgHT6xdennVU7ORYdAbMgY/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjIvMTAvSG91c3RvbkFuc2xleS5wbmc.png'\n WHEN PlayerName = 'McKenzie Clark' THEN 'https://clemsontigers.com/imgproxy/sW4TF2laF_wV4G7h3dmiYS8cmfnvwfi1NBGYiA6fbJM/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMTAvN19DbGFya01jS2VuemllLnBuZw.png'\n WHEN PlayerName = 'Sarah Howell' THEN 'https://clemsontigers.com/imgproxy/NZQpcTEhHvT1xH786vm7ogV37i4rEVX-Cnt-Us1xizU/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjIvMTAvSG93ZWxsU2FyYWgucG5n.png'\n WHEN PlayerName = 'Regan Spencer' THEN 'https://clemsontigers.com/imgproxy/EHMz_AFgrGDgBkAsFCUE0wHzkkYzIIelQZyqqZ7cNr4/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMTAvMTlfU3BlbmNlclJlZ2FuLnBuZw.png'\n WHEN PlayerName = 'Jaden Cheek' THEN 'https://clemsontigers.com/imgproxy/AaRXcy6qe3EXX7nl-banBpdusiQ7vpLOW-88IRJ6G3c/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjEvMTIvQ2hlZWtKYWRlbi5wbmc.png'\n WHEN PlayerName = 'Carsten Puckett' THEN 'https://clemsontigers.com/imgproxy/IjDeGGQxHQMzMF6e1qvFUUX1Z4T8w-rQCi1Jn7gfw48/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjAvMDgvUHVja2V0dENhcnN0ZW4uanBn.jpg'\n WHEN PlayerName = 'Millie Thompson' THEN 'https://clemsontigers.com/imgproxy/e3RUq7wmuZUAkCIXOd2ZS60Ujr0GtluBWpoI3Wgr8yM/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMTAvODdfVGhvbXBzb25NaWxsaWUucG5n.png'\n WHEN PlayerName = 'Rachel Gibson' THEN 'https://clemsontigers.com/imgproxy/DHoBapuuSa9-3hL6-CKFHWa_O1G6McdMPLIgaZx6H4I/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjIvMTAvR2lic29uUmFjaGVsLnBuZw.png'\n WHEN PlayerName = 'Brooke McCubbin' THEN 'https://clemsontigers.com/imgproxy/RZs988wLvb-vUplaYWDxVVADnxF3ptp1tE33KifXrVs/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMTEvTWNDdWJiaW5Ccm9va2UucG5n.png'\n WHEN PlayerName = 'Ansley Gilstrap' THEN 'https://clemsontigers.com/imgproxy/Xl2jfHrlEBtF4Y5n5CWW15D7EzQYjaieHBaRtF7a-zU/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjAvMDgvR2lsc3RyYXBBbnNsZXkuanBn.jpg'\n WHEN PlayerName = 'Sam Russ' THEN 'https://clemsontigers.com/imgproxy/HkQ86kq6ChH_R8JMoRLD8Z68ximka91ddhPlv3lGpJA/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjEvMTIvUnVzc1NhbS5wbmc.png'\n WHEN PlayerName = 'Aby Vieira' THEN 'https://clemsontigers.com/imgproxy/1VkzI7qYH7-UzY85RaYHPMgA1tKSiNJb815JVlxR2mQ/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMTEvVmllaXJhQWJ5LnBuZw.png'\n WHEN PlayerName = 'Grace Hiller' THEN 'https://clemsontigers.com/imgproxy/Kt4K-FFLsTWTS-fO4_we31dmVJZjcs3ehMuTIJ1789Y/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMTAvOF9IaWxsZXJHcmFjZS5wbmc.png'\n WHEN PlayerName = 'Haylee Whitesides' THEN 'https://clemsontigers.com/imgproxy/YFSk3qR6Ji4u10CYN-py_exw2ev7qqfIkNZj4l4k6Z4/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMTEvV2hpdGVzaWRlc0hheWxlZS5wbmc.png'\n WHEN PlayerName = 'Jadeyn Ruszkowski' THEN 'https://clemsontigers.com/imgproxy/lZJlwRnlGjvpzXaUbZydpnrzX8cxT66PV0MVhs4aekI/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMTEvUnVzemtvd3NraUphZGV5bi5wbmc.png'\n WHEN PlayerName = 'Maddie Moore' THEN 'https://clemsontigers.com/imgproxy/K20BP0TZo5mTOUWIa7qrdzccoRvgR7wXMA0qz4X19QY/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMTEvTW9vcmVNYWRkaWUucG5n.png'\n WHEN PlayerName = 'Marena Knowles' THEN 'https://clemsontigers.com/imgproxy/5Y1SKUWe3c-inR44fp1P6AUNmSK0Q5dzWNnb4gb1VYM/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMTAvMDBfS25vd2xlc01hcmVuYS5wbmc.png'\n WHEN PlayerName = 'Reedy Davenport' THEN 'https://clemsontigers.com/imgproxy/bSveNNjrKlt-Tg0rZereASni4ZwNCJZqtIcXPBX7kB4/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjIvMTAvRGF2ZW5wb3J0UmVlZHkucG5n.png'\n WHEN PlayerName = 'Julia Bomhardt' THEN 'https://clemsontigers.com/imgproxy/0rfuv7ORU8ow1z9uNs4QeitY_nI7ZlruH6c-pQJicWM/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMTAvNl9Cb21oYXJkdEp1bGlhLnBuZw.png'\n WHEN PlayerName = 'Caroline Jacobsen' THEN 'https://clemsontigers.com/imgproxy/VfxK0GODvXkRKd_Z0wgzY_WiHeFiX-PaVBbwCq8H2Eg/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjIvMTAvSmFjb2JzZW5DYXJvbGluZS5wbmc.png'\n WHEN PlayerName = 'Emma Whitfield' THEN 'https://clemsontigers.com/imgproxy/mFSGMWLTh8p0t4LKIsCWGOVskCeoqkfyPbWNkN_-rLw/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjEvMTIvV2hpdGZpZWxkRW1tYS5wbmc.png'\n WHEN PlayerName = 'Ally Miklesh' THEN 'https://clemsontigers.com/imgproxy/W6Aa7KV5_TqtoY60eODJ1ePdriNfuud29dzmchRTdeI/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjIvMTAvTWlrbGVzaEFsbHkucG5n.png'\n WHEN PlayerName = 'Kennedy Ariail' THEN 'https://clemsontigers.com/imgproxy/IyKb_pyJO7G79b8T-Nb8mLA3t6rc614q4B2eO9JbUns/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMDcvMS1BcmlhaWxLZW5uZWR5LnBuZw.png'\n WHEN PlayerName = 'Kylee Johnson' THEN 'https://clemsontigers.com/imgproxy/Lh2mJnZu5I4MF69x-pY8MlciDsH7RAEryB8LDpSLH5I/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMDcvMy1Kb2huc29uS3lsZWUucG5n.png'\n WHEN PlayerName = 'Lindsey Garcia' THEN 'https://clemsontigers.com/imgproxy/lRWyT_w25ETYDclBkJxWgzEteGAPmKi8uAyetJl_l2E/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMTAvNV9HYXJjaWFMaW5kc2V5LnBuZw.png'\n WHEN PlayerName = 'Riley Burton' THEN 'https://clemsontigers.com/imgproxy/Kesv3KqvqNV0UO8KPFmw8BHnmxB_9OFC0zuaIcetjF4/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMDcvMTAtQnVydG9uUmlsZXkucG5n.png'\n WHEN PlayerName = 'Julia Knowler' THEN 'https://clemsontigers.com/imgproxy/z1FUMpbNvU0x8d99rMPbQHR6pnSGoyaR1_tD65H4oKo/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMDcvMTItS25vd2xlckp1bGlhLnBuZw.png'\n WHEN PlayerName = 'Alex Brown' THEN 'https://clemsontigers.com/imgproxy/Bb0Hp33SD2kPTkCKR-1aGq6gIWJ--286c1rxaz3VYvM/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMTEvQnJvd25BbGV4LnBuZw.png'\n WHEN PlayerName = 'Olivia Duncan' THEN 'https://clemsontigers.com/imgproxy/8xS3im1ri8ynbEuegxHSIGEzelYV9TmrKeqT01TUuzg/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMDcvNDQtRHVuY2FuT2xpdmlhLnBuZw.png'\n WHEN PlayerName = 'Marian Collins' THEN 'https://clemsontigers.com/imgproxy/6QG-u2hTH1PsSwmPql6WweORJzrRjpLn4r1tMjAaFEw/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMDcvNS1Db2xsaW5zTWFyaWFuLnBuZw.png'\n WHEN PlayerName = 'Reese Basinger' THEN 'https://clemsontigers.com/imgproxy/GjXfLiiHe6NNf7KzRwTqvI2-2U60W4h98_sRMlTFWw0/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMTEvQmFzaW5nZXJSZWVzZS5wbmc.png'\n WHEN PlayerName = 'Cammy Pereira' THEN 'https://clemsontigers.com/imgproxy/LU7g5mLLPFNeUb54I1PSp745yocrza0f6sQhnviXUqc/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjEvMTIvUGVyZWlyYUNhbW15LnBuZw.png'\n WHEN PlayerName = 'Madi Lardizabal' THEN 'https://clemsontigers.com/imgproxy/KvTZJft0qGQBEYAwsLPZPh0VM1pge228zOoShCcuZ40/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMDcvOC1MYXJkaXphYmFsTWFkaS5wbmc.png'\n WHEN PlayerName = 'Jamison Brockenbrough' THEN 'https://clemsontigers.com/imgproxy/XMiyXsGSPBVvZuMd5SZUR6X44sL1nN9yQDaAVxiL_HE/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMDcvOS1Ccm9ja2VuYnJvdWdoSmFtaXNvbi5wbmc.png'\n WHEN PlayerName = 'Macey Cintron' THEN 'https://clemsontigers.com/imgproxy/HBV23UtucImkSFTw1dGbgrZxZOmRkosLBgOs_LxF_Tk/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMDcvMTYtQ2ludHJvbk1hY2V5LnBuZw.png'\n WHEN PlayerName = 'Ava Wilson' THEN 'https://clemsontigers.com/imgproxy/RbwWlFgOYd7hgi5m_WCzxojtUDPK-3CWgXpqgrH6ybA/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMDcvMTctV2lsc29uQXZhLnBuZw.png'\n WHEN PlayerName = 'Brook Melnychuk' THEN 'https://clemsontigers.com/imgproxy/LTvmV9Odxi0m3F-GNArM7vvqLz7v8iuSoGz57L7Yos8/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMTEvTWVsbnljaHVrQnJvb2sucG5n.png'\n WHEN PlayerName = 'Sam Minish' THEN 'https://clemsontigers.com/imgproxy/TQkRaZ3gmisU_Q3PIfOkmwUaa7cngnzEfYryPk3m4vM/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMDcvMjAtTWluaXNoU2FtLnBuZw.png'\n WHEN PlayerName = 'Taylor Pipkins' THEN 'https://clemsontigers.com/imgproxy/Aeq8qsNTBYANXgvQArpIrLhOIl6VVt22OngiuAVcTH4/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMDcvMjItUGlwa2luc1RheWxvci5wbmc.png'\n WHEN PlayerName = 'Riley Fennell' THEN 'https://clemsontigers.com/imgproxy/uR9YArgDvZLc6RoMirk3EUlqzQxZESKQy0UFxKjoWiI/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMDcvMjctRmVubmVsbFJpbGV5LnBuZw.png'\n WHEN PlayerName = 'Kiley Channell' THEN 'https://clemsontigers.com/imgproxy/yhjD_jYrQIfI--8mwBd_EXqjEgofiybe13ywJXJffCc/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjUvMDcvMi1DaGFubmVsbEtpbGV5LnBuZw.png'\n WHEN PlayerName = 'Abby Dunning' THEN 'https://clemsontigers.com/imgproxy/RA-e_-B6FlWqyNjRIhzfTmxgvqN4TeuQZeBDEv5W2HY/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjUvMDcvNC1EdW5uaW5nQWJieS5wbmc.png'\n WHEN PlayerName = 'Abi Stuart' THEN 'https://clemsontigers.com/imgproxy/IjW8DCFbXiGSPPRONiwyHh6ARa42hBZvQxVaXbYgBUk/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjQvMTEvU3R1YXJ0QWJpLnBuZw.png'\n WHEN PlayerName = 'Sierra Maness' THEN 'https://clemsontigers.com/imgproxy/wnVAXaaZacRNbeWN9E9hSzOdjjyYJQnfV8mbQPIp94Y/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjUvMDcvNy1NYW5lc3NTaWVycmEucG5n.png'\n WHEN PlayerName = 'Mac Pavese' THEN 'https://clemsontigers.com/imgproxy/RLvKX6to3e5qvrOc-flBMxZ6ulFwkVuglAsxf8ze1MI/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjUvMDYvMTEtUGF2ZXNlTWFjLnBuZw.png'\n WHEN PlayerName = 'Maddie Johnson' THEN 'https://clemsontigers.com/imgproxy/EW7Bo0Yp22-kpYFG-i-0H-Ucfd6vXyz6syr_3e7oAnU/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjUvMDYvMTUtSm9obnNvbk1hZGRpZS5wbmc.png'\n WHEN PlayerName = 'Sophia Burmeister' THEN 'https://clemsontigers.com/imgproxy/HNnmh4BFSM4oJ5dxrq--el97qPCiP5J1Gz0S8oYgsZ0/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjUvMDYvMjMtQnVybWVpc3RlclNvcGhpYS5wbmc.png'\n WHEN PlayerName = 'Lexie Hames' THEN 'https://clemsontigers.com/imgproxy/0HTAsV9gQgfGLDMJPn1c9_-L3VE-cqxmsT4lGvk_-jA/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjUvMDYvMzMtSGFtZXNMZXhpZS5wbmc.png'\n WHEN PlayerName = 'Sarah Rocheleau' THEN 'https://clemsontigers.com/imgproxy/Elc6QDX9RJWUlz5i_I65ISj9K6uJXyBZftvqOb61unw/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjUvMDYvMzctUm9jaGVsZWF1U2FyYWgucG5n.png'\n WHEN PlayerName = 'Keira Crosby' THEN 'https://clemsontigers.com/imgproxy/4jzGey11_L3_KMjGKuEbtHajyoO8_F0rRgbzc6_JiBk/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjUvMDYvNDMtQ3Jvc2J5S2VpcmEucG5n.png'\n WHEN PlayerName = 'Sarah Breaux' THEN 'https://clemsontigers.com/imgproxy/mEruwy8vdlWDFdnMkTYcAdZRhjxvcyVLKoazUub6YTE/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjUvMDYvNjYtQnJlYXV4U2FyYWgucG5n.png'\n WHEN PlayerName = 'Corri Hicks' THEN 'https://clemsontigers.com/imgproxy/S4wNlyuZgrYqYLtqJBTsHNJgp2FbAlHPJupLoaXt31g/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjUvMDcvOTktSGlja3NDb3JyaS5wbmc.png'\n WHEN PlayerName = 'Madison May' THEN 'https://clemsontigers.com/imgproxy/SGKMk7T8bt3SjlEMVyV7t-CQS4HCawiiX7WOCe8OUXs/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjIvMTAvTWF5TWFkaXNvbi5wbmc.png'\n WHEN PlayerName = 'Alia Logoleo' THEN 'https://clemsontigers.com/imgproxy/VnJFNRLFxcnoVXjyyFVywWLo4OJKiMT86V83kS7X52I/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjMvMTAvMTZfTG9nb2xlb0FsaWEucG5n.png'\n WHEN PlayerName = 'Bailey Taylor' THEN 'https://clemsontigers.com/imgproxy/g-1eJJc5DHoMpLim2If_yA9CIJ_apOM0oh101-d43bU/rs:fit:1980:0:0:0/g:ce:0:0/q:90/aHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL2NsZW1zb250aWdlcnMtY29tLzIwMjEvMTIvVGF5bG9yQmFpbGV5LnBuZw.png'\n END AS Photo_URL\n FROM Rosters)\n, JerseyNumbers AS (SELECT PlayerID,\n PlayerName,\n mode(PlayerNumber) AS PlayerNumber\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE SchoolId = 279 \n AND PlayerNumber IS NOT NULL AND CAST(PlayerNumber AS VARCHAR) <> ''\n GROUP BY PlayerID, PlayerName)\nSELECT DISTINCT\n RP.PlayerName,\n RP.LastName,\n RP.PlayerID,\n RP.LastSeason,\n RP.Photo_URL,\n JN.PlayerNumber\n FROM Rosters_Photos AS RP\n LEFT JOIN JerseyNumbers AS JN\n ON RP.PlayerID = JN.PlayerID\n ORDER BY RP.LastName)\nWHERE PlayerName = '${params.PlayerName}'","inputQueryString":"-- Returns the roster/profile card row for the selected player profile.\n\nSELECT PlayerName, LastName, PlayerID, LastSeason, Photo_URL, PlayerNumber, '/player-profiles/' || PlayerName as link\nFROM ${profile_pages}\nWHERE PlayerName = '${params.PlayerName}'","compiled":true,"inline":false},{"id":"player_career_stats","compiledQueryString":"-- Aggregates career batting, fielding, and pitching totals for the selected player profile.\n\nSELECT\n -- Career Totals\n SUM(CASE WHEN COALESCE(g.GamesPlayed, 0) = 1 THEN 1 ELSE 0 END) AS Career_GamesPlayed,\n SUM(CASE WHEN COALESCE(g.GamesStarted, 0) = 1 THEN 1 ELSE 0 END) AS Career_GamesStarted,\n \n -- Offense\n ROUND(1.0 * SUM(COALESCE(g.Hitter_Hits, 0))\n / NULLIF(SUM(COALESCE(g.Hitter_AtBats, 0)), 0), 3) AS Career_Bat_AVG,\n\n ROUND((1.0 * (SUM(COALESCE(g.Hitter_Hits, 0)) + SUM(COALESCE(g.Hitter_BaseOnBalls, 0)) + SUM(COALESCE(g.Hitter_HitbyPitch, 0)))\n / NULLIF(SUM(COALESCE(g.Hitter_AtBats, 0)) + SUM(COALESCE(g.Hitter_BaseOnBalls, 0)) + SUM(COALESCE(g.Hitter_HitbyPitch, 0)) + SUM(COALESCE(g.Hitter_SacrificeFlies, 0)), 0)\n + 1.0 * (SUM(COALESCE(g.Hitter_Hits, 0)) - SUM(COALESCE(g.Hitter_Doubles, 0)) - SUM(COALESCE(g.Hitter_Triples, 0)) - SUM(COALESCE(g.Hitter_HomeRun, 0))\n + 2 * SUM(COALESCE(g.Hitter_Doubles, 0)) + 3 * SUM(COALESCE(g.Hitter_Triples, 0)) + 4 * SUM(COALESCE(g.Hitter_HomeRun, 0)))\n / NULLIF(SUM(COALESCE(g.Hitter_AtBats, 0)), 0)), 3) AS Career_OPS,\n\n SUM(COALESCE(g.Hitter_AtBats, 0)) AS Career_AtBats,\n SUM(COALESCE(g.Hitter_Runs, 0)) AS Career_Runs,\n SUM(COALESCE(g.Hitter_Hits, 0)) AS Career_Hits,\n SUM(COALESCE(g.Hitter_Doubles, 0)) AS Career_Hitter_Doubles,\n SUM(COALESCE(g.Hitter_Triples, 0)) AS Career_Hitter_Triples,\n SUM(COALESCE(g.Hitter_HomeRun, 0)) AS Career_Hitter_HomeRun,\n SUM(COALESCE(g.Hitter_RunnersBattedIn, 0)) AS Career_Hitter_RunnersBattedIn,\n\n (\n SUM(COALESCE(g.Hitter_Hits, 0))\n - SUM(COALESCE(g.Hitter_Doubles, 0))\n - SUM(COALESCE(g.Hitter_Triples, 0))\n - SUM(COALESCE(g.Hitter_HomeRun, 0))\n + 2 * SUM(COALESCE(g.Hitter_Doubles, 0))\n + 3 * SUM(COALESCE(g.Hitter_Triples, 0))\n + 4 * SUM(COALESCE(g.Hitter_HomeRun, 0))\n ) AS Career_Hitter_TotalBases,\n\n ROUND(1.0 * (SUM(COALESCE(g.Hitter_Hits, 0)) - SUM(COALESCE(g.Hitter_Doubles, 0)) - SUM(COALESCE(g.Hitter_Triples, 0)) - SUM(COALESCE(g.Hitter_HomeRun, 0))\n + 2 * SUM(COALESCE(g.Hitter_Doubles, 0)) + 3 * SUM(COALESCE(g.Hitter_Triples, 0)) + 4 * SUM(COALESCE(g.Hitter_HomeRun, 0)))\n / NULLIF(SUM(COALESCE(g.Hitter_AtBats, 0)), 0), 3) AS Career_SLG,\n \n SUM(COALESCE(g.Hitter_BaseOnBalls, 0)) AS Career_Hitter_Walks,\n SUM(COALESCE(g.Hitter_HitbyPitch, 0)) AS Career_Hitter_HitByPitch,\n SUM(COALESCE(g.Hitter_Strikeouts, 0)) AS Career_Hitter_StrikeOuts,\n\n --Grounded into Double Play\n\n ROUND(1.0 * (SUM(COALESCE(g.Hitter_Hits, 0)) + SUM(COALESCE(g.Hitter_BaseOnBalls, 0)) + SUM(COALESCE(g.Hitter_HitbyPitch, 0)))\n / NULLIF(SUM(COALESCE(g.Hitter_AtBats, 0)) + SUM(COALESCE(g.Hitter_BaseOnBalls, 0)) + SUM(COALESCE(g.Hitter_HitbyPitch, 0)) + SUM(COALESCE(g.Hitter_SacrificeFlies, 0)), 0), 3) AS Career_OBP,\n\n SUM(COALESCE(g.Hitter_SacrificeFlies, 0)) AS Career_Hitter_SacFlies,\n SUM(COALESCE(sb.SacrificeBunts, 0)) AS Career_Hitter_SacBunts,\n\n CONCAT(\n CAST(SUM(COALESCE(g.Hitter_StolenBases, 0)) AS INT),\n '-',\n CAST(\n SUM(COALESCE(g.Hitter_CaughtStealing, 0)) +\n SUM(COALESCE(g.Hitter_StolenBases, 0))\n AS INT\n )\n ) AS Career_Hitter_Sb_Att,\n\n -- Defense\n SUM(COALESCE(g.Field_PutOuts, 0)) AS Career_Field_Putouts,\n\n (\n SUM(COALESCE(g.Field_PutOuts, 0))\n + SUM(COALESCE(g.Field_Assists, 0))\n + SUM(COALESCE(g.Field_Errors, 0))\n ) AS Career_Field_TotalChances,\n\n SUM(COALESCE(g.Field_Assists, 0)) AS Career_Field_Assists,\n SUM(COALESCE(g.Field_Errors, 0)) AS Career_Field_Errors,\n\n\n ROUND(1.0 * (SUM(COALESCE(g.Field_PutOuts, 0)) + SUM(COALESCE(g.Field_Assists, 0)))\n / NULLIF(SUM(COALESCE(g.Field_PutOuts, 0)) + SUM(COALESCE(g.Field_Assists, 0)) + SUM(COALESCE(g.Field_Errors, 0)), 0), 3) AS Career_FPCT,\n\n --Catcher Interference\n\n SUM(COALESCE(g.Field_PassedBall, 0)) AS Career_Field_PassedBall,\n SUM(COALESCE(g.Field_StolenBasesAllowed, 0)) AS Career_Field_StolenBasesAllowed,\n SUM(COALESCE(g.Field_CaughtStealingBase, 0)) AS Career_Field_CaughtStealing,\n\n --Triple Play Hit into\n\n -- Pitching\n\n CONCAT(\n CAST(SUM(CASE\n WHEN NULLIF(TRIM(CAST(g.Pitcher_Win AS VARCHAR)), '') IS NOT NULL THEN 1\n ELSE 0\n END) AS INT),\n '-',\n CAST(SUM(CASE\n WHEN NULLIF(TRIM(CAST(g.Pitcher_Loss AS VARCHAR)), '') IS NOT NULL THEN 1\n ELSE 0\n END) AS INT)\n ) AS Career_Pitcher_Record,\n\n CASE \n WHEN SUM(\n CAST(FLOOR(COALESCE(g.Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(g.Pitcher_InningsPitched, 0) - FLOOR(COALESCE(g.Pitcher_InningsPitched, 0))) * 10) AS INTEGER)\n ) > 0 THEN\n CAST(\n SUM(COALESCE(g.Pitcher_EarnedRuns, 0)) * 7.0 /\n NULLIF(\n SUM(\n CAST(FLOOR(COALESCE(g.Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(g.Pitcher_InningsPitched, 0) - FLOOR(COALESCE(g.Pitcher_InningsPitched, 0))) * 10) AS INTEGER)\n ) / 3.0,\n 0\n )\n AS DECIMAL(10,2)\n )\n ELSE NULL\n END AS Career_Pitcher_ERA,\n\n SUM(\n CASE\n WHEN COALESCE(g.Pitcher_Appearances, 0) >= 1 THEN 1\n ELSE 0\n END\n ) AS Career_Pitcher_Appearances,\n\n SUM(COALESCE(g.Pitcher_CompleteGames, 0)) AS Career_Pitcher_CompleteGame,\n SUM(CASE WHEN g.Pitcher_Save >= 1 THEN 1 ELSE 0 END) AS Career_Pitcher_Save,\n\n FLOOR(\n SUM(\n CAST(FLOOR(COALESCE(g.Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(g.Pitcher_InningsPitched, 0) - FLOOR(COALESCE(g.Pitcher_InningsPitched, 0))) * 10) AS INTEGER)\n ) / 3.0\n ) + (\n MOD(\n SUM(\n CAST(FLOOR(COALESCE(g.Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(g.Pitcher_InningsPitched, 0) - FLOOR(COALESCE(g.Pitcher_InningsPitched, 0))) * 10) AS INTEGER)\n ),\n 3\n ) / 10.0\n ) AS Career_Pitcher_InningsPitched,\n\n SUM(COALESCE(g.Pitcher_Hits, 0)) AS Career_Pitcher_Hits,\n SUM(COALESCE(g.Pitcher_Runs, 0)) AS Career_Pitcher_RunsAllowed,\n SUM(COALESCE(g.Pitcher_EarnedRuns, 0)) AS Career_Pitcher_EarnedRuns,\n SUM(COALESCE(g.Pitcher_HomeRun, 0)) AS Career_Pitcher_HomeRuns,\n SUM(COALESCE(g.Pitcher_SacrificeFliesAllowed, 0)) AS Career_Pitcher_SacFlies,\n SUM(COALESCE(g.Pitcher_BaseOnBalls, 0)) AS Career_Pitcher_Walks,\n SUM(COALESCE(g.Pitcher_StrikeOuts, 0)) AS Career_Pitcher_StrikeOuts,\n SUM(COALESCE(g.Pitcher_WildPitches, 0)) AS Career_Pitcher_WildPitches,\n\n --balks\n\n SUM(COALESCE(g.Pitcher_HitByPitch, 0)) AS Career_Pitcher_HitByPitch,\n SUM(COALESCE(g.Pitcher_BattersFaced, 0)) AS Career_Pitcher_BattersFaced,\n SUM(COALESCE(g.Pitcher_Doubles, 0)) AS Career_Pitcher_Doubles,\n SUM(COALESCE(g.Pitcher_Triples, 0)) AS Career_Pitcher_Triples,\n\n --flyouts\n\n --groundouts\n\n CONCAT(\n CAST(SUM(COALESCE(g.Pitcher_Pitches, 0)) AS INT),\n '-',\n CAST(SUM(COALESCE(g.Pitcher_Strikes, 0)) AS INT)\n ) AS Career_Pitcher_NP_STK,\n\nFROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game g\nLEFT JOIN (\n WITH sacrifice_bunt_plays AS (\n SELECT\n p.*,\n TRIM(regexp_extract(p.Batter, '^([^,]+)', 1)) AS BatterLastName,\n NULLIF(TRIM(regexp_extract(p.Batter, ',[[:space:]]*([A-Za-z])', 1)), '') AS BatterFirstInitial\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_play_by_play AS p\n WHERE p.InningNumber IS NOT NULL\n AND (\n LOWER(COALESCE(p.PlayDescription, '')) LIKE '%sac, bunt%'\n OR LOWER(COALESCE(p.PlayDescription, '')) LIKE '%bunt, sac%'\n )\n AND (\n (UPPER(p.HomeTeamName) = 'CLEMSON' AND p.BatterTeam = p.HomeTeamID)\n OR (UPPER(p.VisitorTeamName) = 'CLEMSON' AND p.BatterTeam = p.VisitingTeamID)\n )\n ),\n matched_sacrifice_bunts AS (\n SELECT *\n FROM (\n SELECT\n COALESCE(ps.PlayerName, p.Batter) AS PlayerName,\n p.GameID,\n p.Season,\n p.SeasonType,\n p.GameDate,\n ROW_NUMBER() OVER (\n PARTITION BY p.ID\n ORDER BY CASE WHEN ps.PlayerName IS NULL THEN 1 ELSE 0 END, ps.PlayerName\n ) AS MatchRank\n FROM sacrifice_bunt_plays AS p\n LEFT JOIN SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game AS ps\n ON ps.IsClemson = 1\n AND ps.GameID = p.GameID\n AND (\n LOWER(ps.LastName) = LOWER(p.BatterLastName)\n OR LOWER(ps.LastName) LIKE LOWER(p.BatterLastName) || '%'\n OR LOWER(p.BatterLastName) LIKE LOWER(ps.LastName) || '%'\n )\n AND (\n p.BatterFirstInitial IS NULL\n OR LOWER(LEFT(ps.FirstName, 1)) = LOWER(p.BatterFirstInitial)\n )\n )\n WHERE MatchRank = 1\n )\n SELECT\n PlayerName,\n GameID,\n MAX(Season) AS Season,\n MAX(SeasonType) AS SeasonType,\n MAX(GameDate) AS GameDate,\n COUNT(*) AS SacrificeBunts\n FROM matched_sacrifice_bunts\n GROUP BY PlayerName, GameID\n) AS sb\n ON g.PlayerName = sb.PlayerName\n AND g.GameID = sb.GameID\nWHERE g.PlayerName = '${params.PlayerName}' AND IsClemson = 1","inputQueryString":"-- Aggregates career batting, fielding, and pitching totals for the selected player profile.\n\nSELECT\n -- Career Totals\n SUM(CASE WHEN COALESCE(g.GamesPlayed, 0) = 1 THEN 1 ELSE 0 END) AS Career_GamesPlayed,\n SUM(CASE WHEN COALESCE(g.GamesStarted, 0) = 1 THEN 1 ELSE 0 END) AS Career_GamesStarted,\n \n -- Offense\n ROUND(1.0 * SUM(COALESCE(g.Hitter_Hits, 0))\n / NULLIF(SUM(COALESCE(g.Hitter_AtBats, 0)), 0), 3) AS Career_Bat_AVG,\n\n ROUND((1.0 * (SUM(COALESCE(g.Hitter_Hits, 0)) + SUM(COALESCE(g.Hitter_BaseOnBalls, 0)) + SUM(COALESCE(g.Hitter_HitbyPitch, 0)))\n / NULLIF(SUM(COALESCE(g.Hitter_AtBats, 0)) + SUM(COALESCE(g.Hitter_BaseOnBalls, 0)) + SUM(COALESCE(g.Hitter_HitbyPitch, 0)) + SUM(COALESCE(g.Hitter_SacrificeFlies, 0)), 0)\n + 1.0 * (SUM(COALESCE(g.Hitter_Hits, 0)) - SUM(COALESCE(g.Hitter_Doubles, 0)) - SUM(COALESCE(g.Hitter_Triples, 0)) - SUM(COALESCE(g.Hitter_HomeRun, 0))\n + 2 * SUM(COALESCE(g.Hitter_Doubles, 0)) + 3 * SUM(COALESCE(g.Hitter_Triples, 0)) + 4 * SUM(COALESCE(g.Hitter_HomeRun, 0)))\n / NULLIF(SUM(COALESCE(g.Hitter_AtBats, 0)), 0)), 3) AS Career_OPS,\n\n SUM(COALESCE(g.Hitter_AtBats, 0)) AS Career_AtBats,\n SUM(COALESCE(g.Hitter_Runs, 0)) AS Career_Runs,\n SUM(COALESCE(g.Hitter_Hits, 0)) AS Career_Hits,\n SUM(COALESCE(g.Hitter_Doubles, 0)) AS Career_Hitter_Doubles,\n SUM(COALESCE(g.Hitter_Triples, 0)) AS Career_Hitter_Triples,\n SUM(COALESCE(g.Hitter_HomeRun, 0)) AS Career_Hitter_HomeRun,\n SUM(COALESCE(g.Hitter_RunnersBattedIn, 0)) AS Career_Hitter_RunnersBattedIn,\n\n (\n SUM(COALESCE(g.Hitter_Hits, 0))\n - SUM(COALESCE(g.Hitter_Doubles, 0))\n - SUM(COALESCE(g.Hitter_Triples, 0))\n - SUM(COALESCE(g.Hitter_HomeRun, 0))\n + 2 * SUM(COALESCE(g.Hitter_Doubles, 0))\n + 3 * SUM(COALESCE(g.Hitter_Triples, 0))\n + 4 * SUM(COALESCE(g.Hitter_HomeRun, 0))\n ) AS Career_Hitter_TotalBases,\n\n ROUND(1.0 * (SUM(COALESCE(g.Hitter_Hits, 0)) - SUM(COALESCE(g.Hitter_Doubles, 0)) - SUM(COALESCE(g.Hitter_Triples, 0)) - SUM(COALESCE(g.Hitter_HomeRun, 0))\n + 2 * SUM(COALESCE(g.Hitter_Doubles, 0)) + 3 * SUM(COALESCE(g.Hitter_Triples, 0)) + 4 * SUM(COALESCE(g.Hitter_HomeRun, 0)))\n / NULLIF(SUM(COALESCE(g.Hitter_AtBats, 0)), 0), 3) AS Career_SLG,\n \n SUM(COALESCE(g.Hitter_BaseOnBalls, 0)) AS Career_Hitter_Walks,\n SUM(COALESCE(g.Hitter_HitbyPitch, 0)) AS Career_Hitter_HitByPitch,\n SUM(COALESCE(g.Hitter_Strikeouts, 0)) AS Career_Hitter_StrikeOuts,\n\n --Grounded into Double Play\n\n ROUND(1.0 * (SUM(COALESCE(g.Hitter_Hits, 0)) + SUM(COALESCE(g.Hitter_BaseOnBalls, 0)) + SUM(COALESCE(g.Hitter_HitbyPitch, 0)))\n / NULLIF(SUM(COALESCE(g.Hitter_AtBats, 0)) + SUM(COALESCE(g.Hitter_BaseOnBalls, 0)) + SUM(COALESCE(g.Hitter_HitbyPitch, 0)) + SUM(COALESCE(g.Hitter_SacrificeFlies, 0)), 0), 3) AS Career_OBP,\n\n SUM(COALESCE(g.Hitter_SacrificeFlies, 0)) AS Career_Hitter_SacFlies,\n SUM(COALESCE(sb.SacrificeBunts, 0)) AS Career_Hitter_SacBunts,\n\n CONCAT(\n CAST(SUM(COALESCE(g.Hitter_StolenBases, 0)) AS INT),\n '-',\n CAST(\n SUM(COALESCE(g.Hitter_CaughtStealing, 0)) +\n SUM(COALESCE(g.Hitter_StolenBases, 0))\n AS INT\n )\n ) AS Career_Hitter_Sb_Att,\n\n -- Defense\n SUM(COALESCE(g.Field_PutOuts, 0)) AS Career_Field_Putouts,\n\n (\n SUM(COALESCE(g.Field_PutOuts, 0))\n + SUM(COALESCE(g.Field_Assists, 0))\n + SUM(COALESCE(g.Field_Errors, 0))\n ) AS Career_Field_TotalChances,\n\n SUM(COALESCE(g.Field_Assists, 0)) AS Career_Field_Assists,\n SUM(COALESCE(g.Field_Errors, 0)) AS Career_Field_Errors,\n\n\n ROUND(1.0 * (SUM(COALESCE(g.Field_PutOuts, 0)) + SUM(COALESCE(g.Field_Assists, 0)))\n / NULLIF(SUM(COALESCE(g.Field_PutOuts, 0)) + SUM(COALESCE(g.Field_Assists, 0)) + SUM(COALESCE(g.Field_Errors, 0)), 0), 3) AS Career_FPCT,\n\n --Catcher Interference\n\n SUM(COALESCE(g.Field_PassedBall, 0)) AS Career_Field_PassedBall,\n SUM(COALESCE(g.Field_StolenBasesAllowed, 0)) AS Career_Field_StolenBasesAllowed,\n SUM(COALESCE(g.Field_CaughtStealingBase, 0)) AS Career_Field_CaughtStealing,\n\n --Triple Play Hit into\n\n -- Pitching\n\n CONCAT(\n CAST(SUM(CASE\n WHEN NULLIF(TRIM(CAST(g.Pitcher_Win AS VARCHAR)), '') IS NOT NULL THEN 1\n ELSE 0\n END) AS INT),\n '-',\n CAST(SUM(CASE\n WHEN NULLIF(TRIM(CAST(g.Pitcher_Loss AS VARCHAR)), '') IS NOT NULL THEN 1\n ELSE 0\n END) AS INT)\n ) AS Career_Pitcher_Record,\n\n CASE \n WHEN SUM(\n CAST(FLOOR(COALESCE(g.Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(g.Pitcher_InningsPitched, 0) - FLOOR(COALESCE(g.Pitcher_InningsPitched, 0))) * 10) AS INTEGER)\n ) > 0 THEN\n CAST(\n SUM(COALESCE(g.Pitcher_EarnedRuns, 0)) * 7.0 /\n NULLIF(\n SUM(\n CAST(FLOOR(COALESCE(g.Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(g.Pitcher_InningsPitched, 0) - FLOOR(COALESCE(g.Pitcher_InningsPitched, 0))) * 10) AS INTEGER)\n ) / 3.0,\n 0\n )\n AS DECIMAL(10,2)\n )\n ELSE NULL\n END AS Career_Pitcher_ERA,\n\n SUM(\n CASE\n WHEN COALESCE(g.Pitcher_Appearances, 0) >= 1 THEN 1\n ELSE 0\n END\n ) AS Career_Pitcher_Appearances,\n\n SUM(COALESCE(g.Pitcher_CompleteGames, 0)) AS Career_Pitcher_CompleteGame,\n SUM(CASE WHEN g.Pitcher_Save >= 1 THEN 1 ELSE 0 END) AS Career_Pitcher_Save,\n\n FLOOR(\n SUM(\n CAST(FLOOR(COALESCE(g.Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(g.Pitcher_InningsPitched, 0) - FLOOR(COALESCE(g.Pitcher_InningsPitched, 0))) * 10) AS INTEGER)\n ) / 3.0\n ) + (\n MOD(\n SUM(\n CAST(FLOOR(COALESCE(g.Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(g.Pitcher_InningsPitched, 0) - FLOOR(COALESCE(g.Pitcher_InningsPitched, 0))) * 10) AS INTEGER)\n ),\n 3\n ) / 10.0\n ) AS Career_Pitcher_InningsPitched,\n\n SUM(COALESCE(g.Pitcher_Hits, 0)) AS Career_Pitcher_Hits,\n SUM(COALESCE(g.Pitcher_Runs, 0)) AS Career_Pitcher_RunsAllowed,\n SUM(COALESCE(g.Pitcher_EarnedRuns, 0)) AS Career_Pitcher_EarnedRuns,\n SUM(COALESCE(g.Pitcher_HomeRun, 0)) AS Career_Pitcher_HomeRuns,\n SUM(COALESCE(g.Pitcher_SacrificeFliesAllowed, 0)) AS Career_Pitcher_SacFlies,\n SUM(COALESCE(g.Pitcher_BaseOnBalls, 0)) AS Career_Pitcher_Walks,\n SUM(COALESCE(g.Pitcher_StrikeOuts, 0)) AS Career_Pitcher_StrikeOuts,\n SUM(COALESCE(g.Pitcher_WildPitches, 0)) AS Career_Pitcher_WildPitches,\n\n --balks\n\n SUM(COALESCE(g.Pitcher_HitByPitch, 0)) AS Career_Pitcher_HitByPitch,\n SUM(COALESCE(g.Pitcher_BattersFaced, 0)) AS Career_Pitcher_BattersFaced,\n SUM(COALESCE(g.Pitcher_Doubles, 0)) AS Career_Pitcher_Doubles,\n SUM(COALESCE(g.Pitcher_Triples, 0)) AS Career_Pitcher_Triples,\n\n --flyouts\n\n --groundouts\n\n CONCAT(\n CAST(SUM(COALESCE(g.Pitcher_Pitches, 0)) AS INT),\n '-',\n CAST(SUM(COALESCE(g.Pitcher_Strikes, 0)) AS INT)\n ) AS Career_Pitcher_NP_STK,\n\nFROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game g\nLEFT JOIN (\n WITH sacrifice_bunt_plays AS (\n SELECT\n p.*,\n TRIM(regexp_extract(p.Batter, '^([^,]+)', 1)) AS BatterLastName,\n NULLIF(TRIM(regexp_extract(p.Batter, ',[[:space:]]*([A-Za-z])', 1)), '') AS BatterFirstInitial\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_play_by_play AS p\n WHERE p.InningNumber IS NOT NULL\n AND (\n LOWER(COALESCE(p.PlayDescription, '')) LIKE '%sac, bunt%'\n OR LOWER(COALESCE(p.PlayDescription, '')) LIKE '%bunt, sac%'\n )\n AND (\n (UPPER(p.HomeTeamName) = 'CLEMSON' AND p.BatterTeam = p.HomeTeamID)\n OR (UPPER(p.VisitorTeamName) = 'CLEMSON' AND p.BatterTeam = p.VisitingTeamID)\n )\n ),\n matched_sacrifice_bunts AS (\n SELECT *\n FROM (\n SELECT\n COALESCE(ps.PlayerName, p.Batter) AS PlayerName,\n p.GameID,\n p.Season,\n p.SeasonType,\n p.GameDate,\n ROW_NUMBER() OVER (\n PARTITION BY p.ID\n ORDER BY CASE WHEN ps.PlayerName IS NULL THEN 1 ELSE 0 END, ps.PlayerName\n ) AS MatchRank\n FROM sacrifice_bunt_plays AS p\n LEFT JOIN SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game AS ps\n ON ps.IsClemson = 1\n AND ps.GameID = p.GameID\n AND (\n LOWER(ps.LastName) = LOWER(p.BatterLastName)\n OR LOWER(ps.LastName) LIKE LOWER(p.BatterLastName) || '%'\n OR LOWER(p.BatterLastName) LIKE LOWER(ps.LastName) || '%'\n )\n AND (\n p.BatterFirstInitial IS NULL\n OR LOWER(LEFT(ps.FirstName, 1)) = LOWER(p.BatterFirstInitial)\n )\n )\n WHERE MatchRank = 1\n )\n SELECT\n PlayerName,\n GameID,\n MAX(Season) AS Season,\n MAX(SeasonType) AS SeasonType,\n MAX(GameDate) AS GameDate,\n COUNT(*) AS SacrificeBunts\n FROM matched_sacrifice_bunts\n GROUP BY PlayerName, GameID\n) AS sb\n ON g.PlayerName = sb.PlayerName\n AND g.GameID = sb.GameID\nWHERE g.PlayerName = '${params.PlayerName}' AND IsClemson = 1","compiled":false,"inline":false},{"id":"player_season_stats","compiledQueryString":"-- Aggregates batting, fielding, and pitching stats by season for the selected player profile.\n\nSELECT\n --Season\n g.Season,\n\n SUM(CASE WHEN COALESCE(g.GamesPlayed, 0) = 1 THEN 1 ELSE 0 END) AS Season_GamesPlayed,\n SUM(CASE WHEN COALESCE(g.GamesStarted, 0) = 1 THEN 1 ELSE 0 END) AS Season_GamesStarted,\n\n --Offense\n ROUND(1.0 * SUM(COALESCE(g.Hitter_Hits, 0))\n / NULLIF(SUM(COALESCE(g.Hitter_AtBats, 0)), 0), 3) AS Season_Bat_AVG,\n\n ROUND((1.0 * (SUM(COALESCE(g.Hitter_Hits, 0)) + SUM(COALESCE(g.Hitter_BaseOnBalls, 0)) + SUM(COALESCE(g.Hitter_HitbyPitch, 0)))\n / NULLIF(SUM(COALESCE(g.Hitter_AtBats, 0)) + SUM(COALESCE(g.Hitter_BaseOnBalls, 0)) + SUM(COALESCE(g.Hitter_HitbyPitch, 0)) + SUM(COALESCE(g.Hitter_SacrificeFlies, 0)), 0)\n + 1.0 * (SUM(COALESCE(g.Hitter_Hits, 0)) - SUM(COALESCE(g.Hitter_Doubles, 0)) - SUM(COALESCE(g.Hitter_Triples, 0)) - SUM(COALESCE(g.Hitter_HomeRun, 0))\n + 2 * SUM(COALESCE(g.Hitter_Doubles, 0)) + 3 * SUM(COALESCE(g.Hitter_Triples, 0)) + 4 * SUM(COALESCE(g.Hitter_HomeRun, 0)))\n / NULLIF(SUM(COALESCE(g.Hitter_AtBats, 0)), 0)), 3) AS Season_OPS,\n\n SUM(COALESCE(g.Hitter_AtBats, 0)) AS Season_AtBats,\n SUM(COALESCE(g.Hitter_Runs, 0)) AS Season_Runs,\n SUM(COALESCE(g.Hitter_Hits, 0)) AS Season_Hits,\n SUM(COALESCE(g.Hitter_Doubles, 0)) AS Season_Hitter_Doubles,\n SUM(COALESCE(g.Hitter_Triples, 0)) AS Season_Hitter_Triples,\n SUM(COALESCE(g.Hitter_HomeRun, 0)) AS Season_Hitter_HomeRun,\n SUM(COALESCE(g.Hitter_RunnersBattedIn, 0)) AS Season_Hitter_RunnersBattedIn,\n\n (\n SUM(COALESCE(g.Hitter_Hits, 0))\n - SUM(COALESCE(g.Hitter_Doubles, 0))\n - SUM(COALESCE(g.Hitter_Triples, 0))\n - SUM(COALESCE(g.Hitter_HomeRun, 0))\n + 2 * SUM(COALESCE(g.Hitter_Doubles, 0))\n + 3 * SUM(COALESCE(g.Hitter_Triples, 0))\n + 4 * SUM(COALESCE(g.Hitter_HomeRun, 0))\n ) AS Season_Hitter_TotalBases,\n\n ROUND(1.0 * (SUM(COALESCE(g.Hitter_Hits, 0)) - SUM(COALESCE(g.Hitter_Doubles, 0)) - SUM(COALESCE(g.Hitter_Triples, 0)) - SUM(COALESCE(g.Hitter_HomeRun, 0))\n + 2 * SUM(COALESCE(g.Hitter_Doubles, 0)) + 3 * SUM(COALESCE(g.Hitter_Triples, 0)) + 4 * SUM(COALESCE(g.Hitter_HomeRun, 0)))\n / NULLIF(SUM(COALESCE(g.Hitter_AtBats, 0)), 0), 3) AS Season_SLG,\n \n SUM(COALESCE(g.Hitter_BaseOnBalls, 0)) AS Season_Hitter_Walks,\n SUM(COALESCE(g.Hitter_HitbyPitch, 0)) AS Season_Hitter_HitByPitch,\n SUM(COALESCE(g.Hitter_Strikeouts, 0)) AS Season_Hitter_StrikeOuts,\n\n --Grounded into Double Play\n\n ROUND(1.0 * (SUM(COALESCE(g.Hitter_Hits, 0)) + SUM(COALESCE(g.Hitter_BaseOnBalls, 0)) + SUM(COALESCE(g.Hitter_HitbyPitch, 0)))\n / NULLIF(SUM(COALESCE(g.Hitter_AtBats, 0)) + SUM(COALESCE(g.Hitter_BaseOnBalls, 0)) + SUM(COALESCE(g.Hitter_HitbyPitch, 0)) + SUM(COALESCE(g.Hitter_SacrificeFlies, 0)), 0), 3) AS Season_OBP,\n\n SUM(COALESCE(g.Hitter_SacrificeFlies, 0)) AS Season_Hitter_SacFlies,\n SUM(COALESCE(sb.SacrificeBunts, 0)) AS Season_Hitter_SacBunts,\n\n CONCAT(\n CAST(SUM(COALESCE(g.Hitter_StolenBases, 0)) AS INT),\n '-',\n CAST(\n SUM(COALESCE(g.Hitter_CaughtStealing, 0)) +\n SUM(COALESCE(g.Hitter_StolenBases, 0))\n AS INT\n )\n ) AS Season_Hitter_Sb_Att,\n\n -- Defense\n SUM(COALESCE(g.Field_PutOuts, 0)) AS Season_Field_Putouts,\n\n (\n SUM(COALESCE(g.Field_PutOuts, 0))\n + SUM(COALESCE(g.Field_Assists, 0))\n + SUM(COALESCE(g.Field_Errors, 0))\n ) AS Season_Field_TotalChances,\n\n SUM(COALESCE(g.Field_Assists, 0)) AS Season_Field_Assists,\n SUM(COALESCE(g.Field_Errors, 0)) AS Season_Field_Errors,\n\n\n ROUND(1.0 * (SUM(COALESCE(g.Field_PutOuts, 0)) + SUM(COALESCE(g.Field_Assists, 0)))\n / NULLIF(SUM(COALESCE(g.Field_PutOuts, 0)) + SUM(COALESCE(g.Field_Assists, 0)) + SUM(COALESCE(g.Field_Errors, 0)), 0), 3) AS Season_FPCT,\n\n --Catcher Interference\n\n SUM(COALESCE(g.Field_PassedBall, 0)) AS Season_Field_PassedBall,\n SUM(COALESCE(g.Field_StolenBasesAllowed, 0)) AS Season_Field_StolenBasesAllowed,\n SUM(COALESCE(g.Field_CaughtStealingBase, 0)) AS Season_Field_CaughtStealing,\n\n --Triple Play Hit into\n\n -- Pitching\n --Win/Loss\n\n CONCAT(\n CAST(SUM(CASE\n WHEN NULLIF(TRIM(CAST(g.Pitcher_Win AS VARCHAR)), '') IS NOT NULL THEN 1\n ELSE 0\n END) AS INT),\n '-',\n CAST(SUM(CASE\n WHEN NULLIF(TRIM(CAST(g.Pitcher_Loss AS VARCHAR)), '') IS NOT NULL THEN 1\n ELSE 0\n END) AS INT)\n ) AS Season_Pitcher_Record,\n\n CASE \n WHEN SUM(\n CAST(FLOOR(COALESCE(g.Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(g.Pitcher_InningsPitched, 0) - FLOOR(COALESCE(g.Pitcher_InningsPitched, 0))) * 10) AS INTEGER)\n ) > 0 THEN\n CAST(\n SUM(COALESCE(g.Pitcher_EarnedRuns, 0)) * 7.0 /\n NULLIF(\n SUM(\n CAST(FLOOR(COALESCE(g.Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(g.Pitcher_InningsPitched, 0) - FLOOR(COALESCE(g.Pitcher_InningsPitched, 0))) * 10) AS INTEGER)\n ) / 3.0,\n 0\n )\n AS DECIMAL(10,2)\n )\n ELSE NULL\n END AS Season_Pitcher_ERA,\n\n SUM(\n CASE\n WHEN COALESCE(g.Pitcher_Appearances, 0) >= 1 THEN 1\n ELSE 0\n END\n ) AS Season_Pitcher_Appearances,\n\n SUM(COALESCE(g.Pitcher_CompleteGames, 0)) AS Season_Pitcher_CompleteGame,\n SUM(CASE WHEN g.Pitcher_Save >= 1 THEN 1 ELSE 0 END) AS Season_Pitcher_Save,\n\n FLOOR(\n SUM(\n CAST(FLOOR(COALESCE(g.Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(g.Pitcher_InningsPitched, 0) - FLOOR(COALESCE(g.Pitcher_InningsPitched, 0))) * 10) AS INTEGER)\n ) / 3.0\n ) + (\n MOD(\n SUM(\n CAST(FLOOR(COALESCE(g.Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(g.Pitcher_InningsPitched, 0) - FLOOR(COALESCE(g.Pitcher_InningsPitched, 0))) * 10) AS INTEGER)\n ),\n 3\n ) / 10.0\n ) AS Season_Pitcher_InningsPitched,\n\n SUM(COALESCE(g.Pitcher_Hits, 0)) AS Season_Pitcher_Hits,\n SUM(COALESCE(g.Pitcher_Runs, 0)) AS Season_Pitcher_RunsAllowed,\n SUM(COALESCE(g.Pitcher_EarnedRuns, 0)) AS Season_Pitcher_EarnedRuns,\n SUM(COALESCE(g.Pitcher_HomeRun, 0)) AS Season_Pitcher_HomeRuns,\n SUM(COALESCE(g.Pitcher_SacrificeFliesAllowed, 0)) AS Season_Pitcher_SacFlies,\n SUM(COALESCE(g.Pitcher_BaseOnBalls, 0)) AS Season_Pitcher_Walks,\n SUM(COALESCE(g.Pitcher_StrikeOuts, 0)) AS Season_Pitcher_StrikeOuts,\n SUM(COALESCE(g.Pitcher_WildPitches, 0)) AS Season_Pitcher_WildPitches,\n\n --balks\n\n SUM(COALESCE(g.Pitcher_HitByPitch, 0)) AS Season_Pitcher_HitByPitch,\n SUM(COALESCE(g.Pitcher_BattersFaced, 0)) AS Season_Pitcher_BattersFaced,\n SUM(COALESCE(g.Pitcher_Doubles, 0)) AS Season_Pitcher_Doubles,\n SUM(COALESCE(g.Pitcher_Triples, 0)) AS Season_Pitcher_Triples,\n\n --flyouts\n\n --groundouts\n\n CONCAT(\n CAST(SUM(COALESCE(g.Pitcher_Pitches, 0)) AS INT),\n '-',\n CAST(SUM(COALESCE(g.Pitcher_Strikes, 0)) AS INT)\n ) AS Season_Pitcher_NP_STK,\n\nFROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game g\nLEFT JOIN (\n WITH sacrifice_bunt_plays AS (\n SELECT\n p.*,\n TRIM(regexp_extract(p.Batter, '^([^,]+)', 1)) AS BatterLastName,\n NULLIF(TRIM(regexp_extract(p.Batter, ',[[:space:]]*([A-Za-z])', 1)), '') AS BatterFirstInitial\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_play_by_play AS p\n WHERE p.InningNumber IS NOT NULL\n AND (\n LOWER(COALESCE(p.PlayDescription, '')) LIKE '%sac, bunt%'\n OR LOWER(COALESCE(p.PlayDescription, '')) LIKE '%bunt, sac%'\n )\n AND (\n (UPPER(p.HomeTeamName) = 'CLEMSON' AND p.BatterTeam = p.HomeTeamID)\n OR (UPPER(p.VisitorTeamName) = 'CLEMSON' AND p.BatterTeam = p.VisitingTeamID)\n )\n ),\n matched_sacrifice_bunts AS (\n SELECT *\n FROM (\n SELECT\n COALESCE(ps.PlayerName, p.Batter) AS PlayerName,\n p.GameID,\n p.Season,\n p.SeasonType,\n p.GameDate,\n ROW_NUMBER() OVER (\n PARTITION BY p.ID\n ORDER BY CASE WHEN ps.PlayerName IS NULL THEN 1 ELSE 0 END, ps.PlayerName\n ) AS MatchRank\n FROM sacrifice_bunt_plays AS p\n LEFT JOIN SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game AS ps\n ON ps.IsClemson = 1\n AND ps.GameID = p.GameID\n AND (\n LOWER(ps.LastName) = LOWER(p.BatterLastName)\n OR LOWER(ps.LastName) LIKE LOWER(p.BatterLastName) || '%'\n OR LOWER(p.BatterLastName) LIKE LOWER(ps.LastName) || '%'\n )\n AND (\n p.BatterFirstInitial IS NULL\n OR LOWER(LEFT(ps.FirstName, 1)) = LOWER(p.BatterFirstInitial)\n )\n )\n WHERE MatchRank = 1\n )\n SELECT\n PlayerName,\n GameID,\n MAX(Season) AS Season,\n MAX(SeasonType) AS SeasonType,\n MAX(GameDate) AS GameDate,\n COUNT(*) AS SacrificeBunts\n FROM matched_sacrifice_bunts\n GROUP BY PlayerName, GameID\n) AS sb\n ON g.PlayerName = sb.PlayerName\n AND g.GameID = sb.GameID\nWHERE g.PlayerName = '${params.PlayerName}' AND IsClemson = 1\nGROUP BY g.Season\nORDER BY g.Season DESC","inputQueryString":"-- Aggregates batting, fielding, and pitching stats by season for the selected player profile.\n\nSELECT\n --Season\n g.Season,\n\n SUM(CASE WHEN COALESCE(g.GamesPlayed, 0) = 1 THEN 1 ELSE 0 END) AS Season_GamesPlayed,\n SUM(CASE WHEN COALESCE(g.GamesStarted, 0) = 1 THEN 1 ELSE 0 END) AS Season_GamesStarted,\n\n --Offense\n ROUND(1.0 * SUM(COALESCE(g.Hitter_Hits, 0))\n / NULLIF(SUM(COALESCE(g.Hitter_AtBats, 0)), 0), 3) AS Season_Bat_AVG,\n\n ROUND((1.0 * (SUM(COALESCE(g.Hitter_Hits, 0)) + SUM(COALESCE(g.Hitter_BaseOnBalls, 0)) + SUM(COALESCE(g.Hitter_HitbyPitch, 0)))\n / NULLIF(SUM(COALESCE(g.Hitter_AtBats, 0)) + SUM(COALESCE(g.Hitter_BaseOnBalls, 0)) + SUM(COALESCE(g.Hitter_HitbyPitch, 0)) + SUM(COALESCE(g.Hitter_SacrificeFlies, 0)), 0)\n + 1.0 * (SUM(COALESCE(g.Hitter_Hits, 0)) - SUM(COALESCE(g.Hitter_Doubles, 0)) - SUM(COALESCE(g.Hitter_Triples, 0)) - SUM(COALESCE(g.Hitter_HomeRun, 0))\n + 2 * SUM(COALESCE(g.Hitter_Doubles, 0)) + 3 * SUM(COALESCE(g.Hitter_Triples, 0)) + 4 * SUM(COALESCE(g.Hitter_HomeRun, 0)))\n / NULLIF(SUM(COALESCE(g.Hitter_AtBats, 0)), 0)), 3) AS Season_OPS,\n\n SUM(COALESCE(g.Hitter_AtBats, 0)) AS Season_AtBats,\n SUM(COALESCE(g.Hitter_Runs, 0)) AS Season_Runs,\n SUM(COALESCE(g.Hitter_Hits, 0)) AS Season_Hits,\n SUM(COALESCE(g.Hitter_Doubles, 0)) AS Season_Hitter_Doubles,\n SUM(COALESCE(g.Hitter_Triples, 0)) AS Season_Hitter_Triples,\n SUM(COALESCE(g.Hitter_HomeRun, 0)) AS Season_Hitter_HomeRun,\n SUM(COALESCE(g.Hitter_RunnersBattedIn, 0)) AS Season_Hitter_RunnersBattedIn,\n\n (\n SUM(COALESCE(g.Hitter_Hits, 0))\n - SUM(COALESCE(g.Hitter_Doubles, 0))\n - SUM(COALESCE(g.Hitter_Triples, 0))\n - SUM(COALESCE(g.Hitter_HomeRun, 0))\n + 2 * SUM(COALESCE(g.Hitter_Doubles, 0))\n + 3 * SUM(COALESCE(g.Hitter_Triples, 0))\n + 4 * SUM(COALESCE(g.Hitter_HomeRun, 0))\n ) AS Season_Hitter_TotalBases,\n\n ROUND(1.0 * (SUM(COALESCE(g.Hitter_Hits, 0)) - SUM(COALESCE(g.Hitter_Doubles, 0)) - SUM(COALESCE(g.Hitter_Triples, 0)) - SUM(COALESCE(g.Hitter_HomeRun, 0))\n + 2 * SUM(COALESCE(g.Hitter_Doubles, 0)) + 3 * SUM(COALESCE(g.Hitter_Triples, 0)) + 4 * SUM(COALESCE(g.Hitter_HomeRun, 0)))\n / NULLIF(SUM(COALESCE(g.Hitter_AtBats, 0)), 0), 3) AS Season_SLG,\n \n SUM(COALESCE(g.Hitter_BaseOnBalls, 0)) AS Season_Hitter_Walks,\n SUM(COALESCE(g.Hitter_HitbyPitch, 0)) AS Season_Hitter_HitByPitch,\n SUM(COALESCE(g.Hitter_Strikeouts, 0)) AS Season_Hitter_StrikeOuts,\n\n --Grounded into Double Play\n\n ROUND(1.0 * (SUM(COALESCE(g.Hitter_Hits, 0)) + SUM(COALESCE(g.Hitter_BaseOnBalls, 0)) + SUM(COALESCE(g.Hitter_HitbyPitch, 0)))\n / NULLIF(SUM(COALESCE(g.Hitter_AtBats, 0)) + SUM(COALESCE(g.Hitter_BaseOnBalls, 0)) + SUM(COALESCE(g.Hitter_HitbyPitch, 0)) + SUM(COALESCE(g.Hitter_SacrificeFlies, 0)), 0), 3) AS Season_OBP,\n\n SUM(COALESCE(g.Hitter_SacrificeFlies, 0)) AS Season_Hitter_SacFlies,\n SUM(COALESCE(sb.SacrificeBunts, 0)) AS Season_Hitter_SacBunts,\n\n CONCAT(\n CAST(SUM(COALESCE(g.Hitter_StolenBases, 0)) AS INT),\n '-',\n CAST(\n SUM(COALESCE(g.Hitter_CaughtStealing, 0)) +\n SUM(COALESCE(g.Hitter_StolenBases, 0))\n AS INT\n )\n ) AS Season_Hitter_Sb_Att,\n\n -- Defense\n SUM(COALESCE(g.Field_PutOuts, 0)) AS Season_Field_Putouts,\n\n (\n SUM(COALESCE(g.Field_PutOuts, 0))\n + SUM(COALESCE(g.Field_Assists, 0))\n + SUM(COALESCE(g.Field_Errors, 0))\n ) AS Season_Field_TotalChances,\n\n SUM(COALESCE(g.Field_Assists, 0)) AS Season_Field_Assists,\n SUM(COALESCE(g.Field_Errors, 0)) AS Season_Field_Errors,\n\n\n ROUND(1.0 * (SUM(COALESCE(g.Field_PutOuts, 0)) + SUM(COALESCE(g.Field_Assists, 0)))\n / NULLIF(SUM(COALESCE(g.Field_PutOuts, 0)) + SUM(COALESCE(g.Field_Assists, 0)) + SUM(COALESCE(g.Field_Errors, 0)), 0), 3) AS Season_FPCT,\n\n --Catcher Interference\n\n SUM(COALESCE(g.Field_PassedBall, 0)) AS Season_Field_PassedBall,\n SUM(COALESCE(g.Field_StolenBasesAllowed, 0)) AS Season_Field_StolenBasesAllowed,\n SUM(COALESCE(g.Field_CaughtStealingBase, 0)) AS Season_Field_CaughtStealing,\n\n --Triple Play Hit into\n\n -- Pitching\n --Win/Loss\n\n CONCAT(\n CAST(SUM(CASE\n WHEN NULLIF(TRIM(CAST(g.Pitcher_Win AS VARCHAR)), '') IS NOT NULL THEN 1\n ELSE 0\n END) AS INT),\n '-',\n CAST(SUM(CASE\n WHEN NULLIF(TRIM(CAST(g.Pitcher_Loss AS VARCHAR)), '') IS NOT NULL THEN 1\n ELSE 0\n END) AS INT)\n ) AS Season_Pitcher_Record,\n\n CASE \n WHEN SUM(\n CAST(FLOOR(COALESCE(g.Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(g.Pitcher_InningsPitched, 0) - FLOOR(COALESCE(g.Pitcher_InningsPitched, 0))) * 10) AS INTEGER)\n ) > 0 THEN\n CAST(\n SUM(COALESCE(g.Pitcher_EarnedRuns, 0)) * 7.0 /\n NULLIF(\n SUM(\n CAST(FLOOR(COALESCE(g.Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(g.Pitcher_InningsPitched, 0) - FLOOR(COALESCE(g.Pitcher_InningsPitched, 0))) * 10) AS INTEGER)\n ) / 3.0,\n 0\n )\n AS DECIMAL(10,2)\n )\n ELSE NULL\n END AS Season_Pitcher_ERA,\n\n SUM(\n CASE\n WHEN COALESCE(g.Pitcher_Appearances, 0) >= 1 THEN 1\n ELSE 0\n END\n ) AS Season_Pitcher_Appearances,\n\n SUM(COALESCE(g.Pitcher_CompleteGames, 0)) AS Season_Pitcher_CompleteGame,\n SUM(CASE WHEN g.Pitcher_Save >= 1 THEN 1 ELSE 0 END) AS Season_Pitcher_Save,\n\n FLOOR(\n SUM(\n CAST(FLOOR(COALESCE(g.Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(g.Pitcher_InningsPitched, 0) - FLOOR(COALESCE(g.Pitcher_InningsPitched, 0))) * 10) AS INTEGER)\n ) / 3.0\n ) + (\n MOD(\n SUM(\n CAST(FLOOR(COALESCE(g.Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(g.Pitcher_InningsPitched, 0) - FLOOR(COALESCE(g.Pitcher_InningsPitched, 0))) * 10) AS INTEGER)\n ),\n 3\n ) / 10.0\n ) AS Season_Pitcher_InningsPitched,\n\n SUM(COALESCE(g.Pitcher_Hits, 0)) AS Season_Pitcher_Hits,\n SUM(COALESCE(g.Pitcher_Runs, 0)) AS Season_Pitcher_RunsAllowed,\n SUM(COALESCE(g.Pitcher_EarnedRuns, 0)) AS Season_Pitcher_EarnedRuns,\n SUM(COALESCE(g.Pitcher_HomeRun, 0)) AS Season_Pitcher_HomeRuns,\n SUM(COALESCE(g.Pitcher_SacrificeFliesAllowed, 0)) AS Season_Pitcher_SacFlies,\n SUM(COALESCE(g.Pitcher_BaseOnBalls, 0)) AS Season_Pitcher_Walks,\n SUM(COALESCE(g.Pitcher_StrikeOuts, 0)) AS Season_Pitcher_StrikeOuts,\n SUM(COALESCE(g.Pitcher_WildPitches, 0)) AS Season_Pitcher_WildPitches,\n\n --balks\n\n SUM(COALESCE(g.Pitcher_HitByPitch, 0)) AS Season_Pitcher_HitByPitch,\n SUM(COALESCE(g.Pitcher_BattersFaced, 0)) AS Season_Pitcher_BattersFaced,\n SUM(COALESCE(g.Pitcher_Doubles, 0)) AS Season_Pitcher_Doubles,\n SUM(COALESCE(g.Pitcher_Triples, 0)) AS Season_Pitcher_Triples,\n\n --flyouts\n\n --groundouts\n\n CONCAT(\n CAST(SUM(COALESCE(g.Pitcher_Pitches, 0)) AS INT),\n '-',\n CAST(SUM(COALESCE(g.Pitcher_Strikes, 0)) AS INT)\n ) AS Season_Pitcher_NP_STK,\n\nFROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game g\nLEFT JOIN (\n WITH sacrifice_bunt_plays AS (\n SELECT\n p.*,\n TRIM(regexp_extract(p.Batter, '^([^,]+)', 1)) AS BatterLastName,\n NULLIF(TRIM(regexp_extract(p.Batter, ',[[:space:]]*([A-Za-z])', 1)), '') AS BatterFirstInitial\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_play_by_play AS p\n WHERE p.InningNumber IS NOT NULL\n AND (\n LOWER(COALESCE(p.PlayDescription, '')) LIKE '%sac, bunt%'\n OR LOWER(COALESCE(p.PlayDescription, '')) LIKE '%bunt, sac%'\n )\n AND (\n (UPPER(p.HomeTeamName) = 'CLEMSON' AND p.BatterTeam = p.HomeTeamID)\n OR (UPPER(p.VisitorTeamName) = 'CLEMSON' AND p.BatterTeam = p.VisitingTeamID)\n )\n ),\n matched_sacrifice_bunts AS (\n SELECT *\n FROM (\n SELECT\n COALESCE(ps.PlayerName, p.Batter) AS PlayerName,\n p.GameID,\n p.Season,\n p.SeasonType,\n p.GameDate,\n ROW_NUMBER() OVER (\n PARTITION BY p.ID\n ORDER BY CASE WHEN ps.PlayerName IS NULL THEN 1 ELSE 0 END, ps.PlayerName\n ) AS MatchRank\n FROM sacrifice_bunt_plays AS p\n LEFT JOIN SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game AS ps\n ON ps.IsClemson = 1\n AND ps.GameID = p.GameID\n AND (\n LOWER(ps.LastName) = LOWER(p.BatterLastName)\n OR LOWER(ps.LastName) LIKE LOWER(p.BatterLastName) || '%'\n OR LOWER(p.BatterLastName) LIKE LOWER(ps.LastName) || '%'\n )\n AND (\n p.BatterFirstInitial IS NULL\n OR LOWER(LEFT(ps.FirstName, 1)) = LOWER(p.BatterFirstInitial)\n )\n )\n WHERE MatchRank = 1\n )\n SELECT\n PlayerName,\n GameID,\n MAX(Season) AS Season,\n MAX(SeasonType) AS SeasonType,\n MAX(GameDate) AS GameDate,\n COUNT(*) AS SacrificeBunts\n FROM matched_sacrifice_bunts\n GROUP BY PlayerName, GameID\n) AS sb\n ON g.PlayerName = sb.PlayerName\n AND g.GameID = sb.GameID\nWHERE g.PlayerName = '${params.PlayerName}' AND IsClemson = 1\nGROUP BY g.Season\nORDER BY g.Season DESC","compiled":false,"inline":false},{"id":"player_game_stats","compiledQueryString":"-- Returns per-game batting, fielding, and pitching stats for the selected player profile.\n\nSELECT\n --Game\n g.GameID,\n CASE WHEN g.GameID IS NOT NULL THEN CONCAT('/game-snapshot/', CAST(g.GameID AS VARCHAR)) ELSE NULL END AS link,\n g.Season,\n g.GameDate,\n s.GameLocation,\n s.OpponentName,\n\n --Offense\n ROUND(1.0 * COALESCE(g.Hitter_Hits, 0)\n / NULLIF(COALESCE(g.Hitter_AtBats, 0), 0), 3) AS Bat_AVG,\n\n ROUND((1.0 * (COALESCE(g.Hitter_Hits, 0) + COALESCE(g.Hitter_BaseOnBalls, 0) + COALESCE(g.Hitter_HitbyPitch, 0))\n / NULLIF(COALESCE(g.Hitter_AtBats, 0) + COALESCE(g.Hitter_BaseOnBalls, 0) + COALESCE(g.Hitter_HitbyPitch, 0) + COALESCE(g.Hitter_SacrificeFlies, 0), 0)\n + 1.0 * (COALESCE(g.Hitter_Hits, 0) - COALESCE(g.Hitter_Doubles, 0) - COALESCE(g.Hitter_Triples, 0) - COALESCE(g.Hitter_HomeRun, 0)\n + 2 * COALESCE(g.Hitter_Doubles, 0) + 3 * COALESCE(g.Hitter_Triples, 0) + 4 * COALESCE(g.Hitter_HomeRun, 0))\n / NULLIF(COALESCE(g.Hitter_AtBats, 0), 0)), 3) AS OPS,\n\n ROUND(1.0 * (COALESCE(g.Hitter_Hits, 0) + COALESCE(g.Hitter_BaseOnBalls, 0) + COALESCE(g.Hitter_HitbyPitch, 0))\n / NULLIF(COALESCE(g.Hitter_AtBats, 0) + COALESCE(g.Hitter_BaseOnBalls, 0) + COALESCE(g.Hitter_HitbyPitch, 0) + COALESCE(g.Hitter_SacrificeFlies, 0), 0), 3) AS OBP,\n\n COALESCE(g.Hitter_AtBats, 0) AS AtBats,\n COALESCE(g.Hitter_Runs, 0) AS Runs,\n COALESCE(g.Hitter_Hits, 0) AS Hits,\n COALESCE(g.Hitter_Doubles, 0) AS Hitter_Doubles,\n COALESCE(g.Hitter_Triples, 0) AS Hitter_Triples,\n COALESCE(g.Hitter_HomeRun, 0) AS Hitter_HomeRun,\n COALESCE(g.Hitter_RunnersBattedIn, 0) AS Hitter_RunnersBattedIn,\n\n (\n COALESCE(g.Hitter_Hits, 0)\n - COALESCE(g.Hitter_Doubles, 0)\n - COALESCE(g.Hitter_Triples, 0)\n - COALESCE(g.Hitter_HomeRun, 0)\n + 2 * COALESCE(g.Hitter_Doubles, 0)\n + 3 * COALESCE(g.Hitter_Triples, 0)\n + 4 * COALESCE(g.Hitter_HomeRun, 0)\n ) AS Hitter_TotalBases,\n\n ROUND(1.0 * (COALESCE(g.Hitter_Hits, 0) - COALESCE(g.Hitter_Doubles, 0) - COALESCE(g.Hitter_Triples, 0) - COALESCE(g.Hitter_HomeRun, 0)\n + 2 * COALESCE(g.Hitter_Doubles, 0) + 3 * COALESCE(g.Hitter_Triples, 0) + 4 * COALESCE(g.Hitter_HomeRun, 0))\n / NULLIF(COALESCE(g.Hitter_AtBats, 0), 0), 3) AS SLG,\n \n COALESCE(g.Hitter_BaseOnBalls, 0) AS Hitter_Walks,\n COALESCE(g.Hitter_HitbyPitch, 0) AS Hitter_HitByPitch,\n COALESCE(g.Hitter_Strikeouts, 0) AS Hitter_StrikeOuts,\n\n --Grounded into Double Play\n\n COALESCE(g.Hitter_SacrificeFlies, 0) AS Hitter_SacFlies,\n COALESCE(sb.SacrificeBunts, 0) AS Hitter_SacBunts,\n\n CONCAT(CAST(COALESCE(g.Hitter_StolenBases, 0) AS INT), '-', CAST(COALESCE(g.Hitter_CaughtStealing, 0) + COALESCE(g.Hitter_StolenBases, 0)AS INT)) AS Hitter_Sb_Att,\n\n -- Defense\n COALESCE(g.Field_PutOuts, 0) AS Field_Putouts,\n\n (\n COALESCE(g.Field_PutOuts, 0)\n + COALESCE(g.Field_Assists, 0)\n + COALESCE(g.Field_Errors, 0)\n ) AS Field_TotalChances,\n\n COALESCE(g.Field_Assists, 0) AS Field_Assists,\n COALESCE(g.Field_Errors, 0) AS Field_Errors,\n\n\n ROUND(1.0 * (COALESCE(g.Field_PutOuts, 0) + COALESCE(g.Field_Assists, 0))\n / NULLIF(COALESCE(g.Field_PutOuts, 0) + COALESCE(g.Field_Assists, 0) + COALESCE(g.Field_Errors, 0), 0), 3) AS FPCT,\n\n --Catcher Interference\n\n COALESCE(g.Field_PassedBall, 0) AS Field_PassedBall,\n COALESCE(g.Field_StolenBasesAllowed, 0) AS Field_StolenBasesAllowed,\n COALESCE(g.Field_CaughtStealingBase, 0) AS Field_CaughtStealing,\n\n --Triple Play Hit into\n\n -- Pitching\n --Win/Loss\n\n CONCAT(\n CAST(CASE\n WHEN NULLIF(TRIM(CAST(g.Pitcher_Win AS VARCHAR)), '') IS NOT NULL THEN 1\n ELSE 0\n END AS INT),\n '-',\n CAST(CASE\n WHEN NULLIF(TRIM(CAST(g.Pitcher_Loss AS VARCHAR)), '') IS NOT NULL THEN 1\n ELSE 0\n END AS INT)\n ) AS Pitcher_Record,\n\n CASE \n WHEN (\n CAST(FLOOR(COALESCE(g.Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(g.Pitcher_InningsPitched, 0) - FLOOR(COALESCE(g.Pitcher_InningsPitched, 0))) * 10) AS INTEGER)\n ) > 0 THEN\n CAST(\n COALESCE(g.Pitcher_EarnedRuns, 0) * 7.0 /\n NULLIF(\n (\n CAST(FLOOR(COALESCE(g.Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(g.Pitcher_InningsPitched, 0) - FLOOR(COALESCE(g.Pitcher_InningsPitched, 0))) * 10) AS INTEGER)\n ) / 3.0,\n 0\n )\n AS DECIMAL(10,2)\n )\n ELSE NULL\n END AS ERA,\n \n \n \n CASE\n WHEN COALESCE(g.Pitcher_Appearances, 0) >= 1 THEN 1\n ELSE 0\n END AS Pitcher_Appearances,\n\n\n COALESCE(g.Pitcher_CompleteGames, 0) AS Pitcher_CompleteGame,\n CASE WHEN g.Pitcher_Save >= 1 THEN 1 ELSE 0 END AS Pitcher_Save,\n COALESCE(g.Pitcher_InningsPitched, 0) AS Pitcher_InningsPitched,\n COALESCE(g.Pitcher_Hits, 0) AS Pitcher_Hits,\n COALESCE(g.Pitcher_Runs, 0) AS Pitcher_RunsAllowed,\n COALESCE(g.Pitcher_EarnedRuns, 0) AS Pitcher_EarnedRuns,\n COALESCE(g.Pitcher_HomeRun, 0) AS Pitcher_HomeRuns,\n COALESCE(g.Pitcher_SacrificeFliesAllowed, 0) AS Pitcher_SacFlies,\n COALESCE(g.Pitcher_BaseOnBalls, 0) AS Pitcher_Walks,\n COALESCE(g.Pitcher_StrikeOuts, 0) AS Pitcher_StrikeOuts,\n COALESCE(g.Pitcher_WildPitches, 0) AS Pitcher_WildPitches,\n\n --balks\n\n COALESCE(g.Pitcher_HitByPitch, 0) AS Pitcher_HitByPitch,\n COALESCE(g.Pitcher_BattersFaced, 0) AS Pitcher_BattersFaced,\n COALESCE(g.Pitcher_Doubles, 0) AS Pitcher_Doubles,\n COALESCE(g.Pitcher_Triples, 0) AS Pitcher_Triples,\n\n --flyouts\n\n --groundouts\n\n CONCAT(\n CAST(COALESCE(g.Pitcher_Pitches, 0) AS INT),\n '-',\n CAST(COALESCE(g.Pitcher_Strikes, 0) AS INT)\n ) AS Pitcher_NP_STK,\n\n\nFROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game g\nLEFT JOIN SPORTS_INFO_DW_REPORTING.game_data AS s ON s.GameID = g.GameID AND s.GameDate = g.GameDate\nLEFT JOIN (\n WITH sacrifice_bunt_plays AS (\n SELECT\n p.*,\n TRIM(regexp_extract(p.Batter, '^([^,]+)', 1)) AS BatterLastName,\n NULLIF(TRIM(regexp_extract(p.Batter, ',[[:space:]]*([A-Za-z])', 1)), '') AS BatterFirstInitial\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_play_by_play AS p\n WHERE p.InningNumber IS NOT NULL\n AND (\n LOWER(COALESCE(p.PlayDescription, '')) LIKE '%sac, bunt%'\n OR LOWER(COALESCE(p.PlayDescription, '')) LIKE '%bunt, sac%'\n )\n AND (\n (UPPER(p.HomeTeamName) = 'CLEMSON' AND p.BatterTeam = p.HomeTeamID)\n OR (UPPER(p.VisitorTeamName) = 'CLEMSON' AND p.BatterTeam = p.VisitingTeamID)\n )\n ),\n matched_sacrifice_bunts AS (\n SELECT *\n FROM (\n SELECT\n COALESCE(ps.PlayerName, p.Batter) AS PlayerName,\n p.GameID,\n p.Season,\n p.SeasonType,\n p.GameDate,\n ROW_NUMBER() OVER (\n PARTITION BY p.ID\n ORDER BY CASE WHEN ps.PlayerName IS NULL THEN 1 ELSE 0 END, ps.PlayerName\n ) AS MatchRank\n FROM sacrifice_bunt_plays AS p\n LEFT JOIN SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game AS ps\n ON ps.IsClemson = 1\n AND ps.GameID = p.GameID\n AND (\n LOWER(ps.LastName) = LOWER(p.BatterLastName)\n OR LOWER(ps.LastName) LIKE LOWER(p.BatterLastName) || '%'\n OR LOWER(p.BatterLastName) LIKE LOWER(ps.LastName) || '%'\n )\n AND (\n p.BatterFirstInitial IS NULL\n OR LOWER(LEFT(ps.FirstName, 1)) = LOWER(p.BatterFirstInitial)\n )\n )\n WHERE MatchRank = 1\n )\n SELECT\n PlayerName,\n GameID,\n MAX(Season) AS Season,\n MAX(SeasonType) AS SeasonType,\n MAX(GameDate) AS GameDate,\n COUNT(*) AS SacrificeBunts\n FROM matched_sacrifice_bunts\n GROUP BY PlayerName, GameID\n) AS sb ON g.PlayerName = sb.PlayerName AND g.GameID = sb.GameID\nWHERE g.PlayerName = '${params.PlayerName}'\n AND COALESCE(g.GamesPlayed, 0) = 1 AND IsClemson = 1\nORDER BY g.GameDate DESC, g.GameID DESC","inputQueryString":"-- Returns per-game batting, fielding, and pitching stats for the selected player profile.\n\nSELECT\n --Game\n g.GameID,\n CASE WHEN g.GameID IS NOT NULL THEN CONCAT('/game-snapshot/', CAST(g.GameID AS VARCHAR)) ELSE NULL END AS link,\n g.Season,\n g.GameDate,\n s.GameLocation,\n s.OpponentName,\n\n --Offense\n ROUND(1.0 * COALESCE(g.Hitter_Hits, 0)\n / NULLIF(COALESCE(g.Hitter_AtBats, 0), 0), 3) AS Bat_AVG,\n\n ROUND((1.0 * (COALESCE(g.Hitter_Hits, 0) + COALESCE(g.Hitter_BaseOnBalls, 0) + COALESCE(g.Hitter_HitbyPitch, 0))\n / NULLIF(COALESCE(g.Hitter_AtBats, 0) + COALESCE(g.Hitter_BaseOnBalls, 0) + COALESCE(g.Hitter_HitbyPitch, 0) + COALESCE(g.Hitter_SacrificeFlies, 0), 0)\n + 1.0 * (COALESCE(g.Hitter_Hits, 0) - COALESCE(g.Hitter_Doubles, 0) - COALESCE(g.Hitter_Triples, 0) - COALESCE(g.Hitter_HomeRun, 0)\n + 2 * COALESCE(g.Hitter_Doubles, 0) + 3 * COALESCE(g.Hitter_Triples, 0) + 4 * COALESCE(g.Hitter_HomeRun, 0))\n / NULLIF(COALESCE(g.Hitter_AtBats, 0), 0)), 3) AS OPS,\n\n ROUND(1.0 * (COALESCE(g.Hitter_Hits, 0) + COALESCE(g.Hitter_BaseOnBalls, 0) + COALESCE(g.Hitter_HitbyPitch, 0))\n / NULLIF(COALESCE(g.Hitter_AtBats, 0) + COALESCE(g.Hitter_BaseOnBalls, 0) + COALESCE(g.Hitter_HitbyPitch, 0) + COALESCE(g.Hitter_SacrificeFlies, 0), 0), 3) AS OBP,\n\n COALESCE(g.Hitter_AtBats, 0) AS AtBats,\n COALESCE(g.Hitter_Runs, 0) AS Runs,\n COALESCE(g.Hitter_Hits, 0) AS Hits,\n COALESCE(g.Hitter_Doubles, 0) AS Hitter_Doubles,\n COALESCE(g.Hitter_Triples, 0) AS Hitter_Triples,\n COALESCE(g.Hitter_HomeRun, 0) AS Hitter_HomeRun,\n COALESCE(g.Hitter_RunnersBattedIn, 0) AS Hitter_RunnersBattedIn,\n\n (\n COALESCE(g.Hitter_Hits, 0)\n - COALESCE(g.Hitter_Doubles, 0)\n - COALESCE(g.Hitter_Triples, 0)\n - COALESCE(g.Hitter_HomeRun, 0)\n + 2 * COALESCE(g.Hitter_Doubles, 0)\n + 3 * COALESCE(g.Hitter_Triples, 0)\n + 4 * COALESCE(g.Hitter_HomeRun, 0)\n ) AS Hitter_TotalBases,\n\n ROUND(1.0 * (COALESCE(g.Hitter_Hits, 0) - COALESCE(g.Hitter_Doubles, 0) - COALESCE(g.Hitter_Triples, 0) - COALESCE(g.Hitter_HomeRun, 0)\n + 2 * COALESCE(g.Hitter_Doubles, 0) + 3 * COALESCE(g.Hitter_Triples, 0) + 4 * COALESCE(g.Hitter_HomeRun, 0))\n / NULLIF(COALESCE(g.Hitter_AtBats, 0), 0), 3) AS SLG,\n \n COALESCE(g.Hitter_BaseOnBalls, 0) AS Hitter_Walks,\n COALESCE(g.Hitter_HitbyPitch, 0) AS Hitter_HitByPitch,\n COALESCE(g.Hitter_Strikeouts, 0) AS Hitter_StrikeOuts,\n\n --Grounded into Double Play\n\n COALESCE(g.Hitter_SacrificeFlies, 0) AS Hitter_SacFlies,\n COALESCE(sb.SacrificeBunts, 0) AS Hitter_SacBunts,\n\n CONCAT(CAST(COALESCE(g.Hitter_StolenBases, 0) AS INT), '-', CAST(COALESCE(g.Hitter_CaughtStealing, 0) + COALESCE(g.Hitter_StolenBases, 0)AS INT)) AS Hitter_Sb_Att,\n\n -- Defense\n COALESCE(g.Field_PutOuts, 0) AS Field_Putouts,\n\n (\n COALESCE(g.Field_PutOuts, 0)\n + COALESCE(g.Field_Assists, 0)\n + COALESCE(g.Field_Errors, 0)\n ) AS Field_TotalChances,\n\n COALESCE(g.Field_Assists, 0) AS Field_Assists,\n COALESCE(g.Field_Errors, 0) AS Field_Errors,\n\n\n ROUND(1.0 * (COALESCE(g.Field_PutOuts, 0) + COALESCE(g.Field_Assists, 0))\n / NULLIF(COALESCE(g.Field_PutOuts, 0) + COALESCE(g.Field_Assists, 0) + COALESCE(g.Field_Errors, 0), 0), 3) AS FPCT,\n\n --Catcher Interference\n\n COALESCE(g.Field_PassedBall, 0) AS Field_PassedBall,\n COALESCE(g.Field_StolenBasesAllowed, 0) AS Field_StolenBasesAllowed,\n COALESCE(g.Field_CaughtStealingBase, 0) AS Field_CaughtStealing,\n\n --Triple Play Hit into\n\n -- Pitching\n --Win/Loss\n\n CONCAT(\n CAST(CASE\n WHEN NULLIF(TRIM(CAST(g.Pitcher_Win AS VARCHAR)), '') IS NOT NULL THEN 1\n ELSE 0\n END AS INT),\n '-',\n CAST(CASE\n WHEN NULLIF(TRIM(CAST(g.Pitcher_Loss AS VARCHAR)), '') IS NOT NULL THEN 1\n ELSE 0\n END AS INT)\n ) AS Pitcher_Record,\n\n CASE \n WHEN (\n CAST(FLOOR(COALESCE(g.Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(g.Pitcher_InningsPitched, 0) - FLOOR(COALESCE(g.Pitcher_InningsPitched, 0))) * 10) AS INTEGER)\n ) > 0 THEN\n CAST(\n COALESCE(g.Pitcher_EarnedRuns, 0) * 7.0 /\n NULLIF(\n (\n CAST(FLOOR(COALESCE(g.Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(g.Pitcher_InningsPitched, 0) - FLOOR(COALESCE(g.Pitcher_InningsPitched, 0))) * 10) AS INTEGER)\n ) / 3.0,\n 0\n )\n AS DECIMAL(10,2)\n )\n ELSE NULL\n END AS ERA,\n \n \n \n CASE\n WHEN COALESCE(g.Pitcher_Appearances, 0) >= 1 THEN 1\n ELSE 0\n END AS Pitcher_Appearances,\n\n\n COALESCE(g.Pitcher_CompleteGames, 0) AS Pitcher_CompleteGame,\n CASE WHEN g.Pitcher_Save >= 1 THEN 1 ELSE 0 END AS Pitcher_Save,\n COALESCE(g.Pitcher_InningsPitched, 0) AS Pitcher_InningsPitched,\n COALESCE(g.Pitcher_Hits, 0) AS Pitcher_Hits,\n COALESCE(g.Pitcher_Runs, 0) AS Pitcher_RunsAllowed,\n COALESCE(g.Pitcher_EarnedRuns, 0) AS Pitcher_EarnedRuns,\n COALESCE(g.Pitcher_HomeRun, 0) AS Pitcher_HomeRuns,\n COALESCE(g.Pitcher_SacrificeFliesAllowed, 0) AS Pitcher_SacFlies,\n COALESCE(g.Pitcher_BaseOnBalls, 0) AS Pitcher_Walks,\n COALESCE(g.Pitcher_StrikeOuts, 0) AS Pitcher_StrikeOuts,\n COALESCE(g.Pitcher_WildPitches, 0) AS Pitcher_WildPitches,\n\n --balks\n\n COALESCE(g.Pitcher_HitByPitch, 0) AS Pitcher_HitByPitch,\n COALESCE(g.Pitcher_BattersFaced, 0) AS Pitcher_BattersFaced,\n COALESCE(g.Pitcher_Doubles, 0) AS Pitcher_Doubles,\n COALESCE(g.Pitcher_Triples, 0) AS Pitcher_Triples,\n\n --flyouts\n\n --groundouts\n\n CONCAT(\n CAST(COALESCE(g.Pitcher_Pitches, 0) AS INT),\n '-',\n CAST(COALESCE(g.Pitcher_Strikes, 0) AS INT)\n ) AS Pitcher_NP_STK,\n\n\nFROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game g\nLEFT JOIN SPORTS_INFO_DW_REPORTING.game_data AS s ON s.GameID = g.GameID AND s.GameDate = g.GameDate\nLEFT JOIN (\n WITH sacrifice_bunt_plays AS (\n SELECT\n p.*,\n TRIM(regexp_extract(p.Batter, '^([^,]+)', 1)) AS BatterLastName,\n NULLIF(TRIM(regexp_extract(p.Batter, ',[[:space:]]*([A-Za-z])', 1)), '') AS BatterFirstInitial\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_play_by_play AS p\n WHERE p.InningNumber IS NOT NULL\n AND (\n LOWER(COALESCE(p.PlayDescription, '')) LIKE '%sac, bunt%'\n OR LOWER(COALESCE(p.PlayDescription, '')) LIKE '%bunt, sac%'\n )\n AND (\n (UPPER(p.HomeTeamName) = 'CLEMSON' AND p.BatterTeam = p.HomeTeamID)\n OR (UPPER(p.VisitorTeamName) = 'CLEMSON' AND p.BatterTeam = p.VisitingTeamID)\n )\n ),\n matched_sacrifice_bunts AS (\n SELECT *\n FROM (\n SELECT\n COALESCE(ps.PlayerName, p.Batter) AS PlayerName,\n p.GameID,\n p.Season,\n p.SeasonType,\n p.GameDate,\n ROW_NUMBER() OVER (\n PARTITION BY p.ID\n ORDER BY CASE WHEN ps.PlayerName IS NULL THEN 1 ELSE 0 END, ps.PlayerName\n ) AS MatchRank\n FROM sacrifice_bunt_plays AS p\n LEFT JOIN SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game AS ps\n ON ps.IsClemson = 1\n AND ps.GameID = p.GameID\n AND (\n LOWER(ps.LastName) = LOWER(p.BatterLastName)\n OR LOWER(ps.LastName) LIKE LOWER(p.BatterLastName) || '%'\n OR LOWER(p.BatterLastName) LIKE LOWER(ps.LastName) || '%'\n )\n AND (\n p.BatterFirstInitial IS NULL\n OR LOWER(LEFT(ps.FirstName, 1)) = LOWER(p.BatterFirstInitial)\n )\n )\n WHERE MatchRank = 1\n )\n SELECT\n PlayerName,\n GameID,\n MAX(Season) AS Season,\n MAX(SeasonType) AS SeasonType,\n MAX(GameDate) AS GameDate,\n COUNT(*) AS SacrificeBunts\n FROM matched_sacrifice_bunts\n GROUP BY PlayerName, GameID\n) AS sb ON g.PlayerName = sb.PlayerName AND g.GameID = sb.GameID\nWHERE g.PlayerName = '${params.PlayerName}'\n AND COALESCE(g.GamesPlayed, 0) = 1 AND IsClemson = 1\nORDER BY g.GameDate DESC, g.GameID DESC","compiled":false,"inline":false},{"id":"player_top_10_records","compiledQueryString":"-- Finds the selected player's appearances in Clemson top-10 record lists and links each record to the relevant page.\n\nWITH sacrifice_bunts_by_game AS (\n SELECT\n PlayerName AS BuntPlayerName,\n GameID AS BuntGameID,\n Season AS BuntSeason,\n SUM(SacrificeBunts) AS SacrificeBunts\n FROM (\n WITH sacrifice_bunt_plays AS (\n SELECT\n p.*,\n TRIM(regexp_extract(p.Batter, '^([^,]+)', 1)) AS BatterLastName,\n NULLIF(TRIM(regexp_extract(p.Batter, ',[[:space:]]*([A-Za-z])', 1)), '') AS BatterFirstInitial\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_play_by_play AS p\n WHERE p.InningNumber IS NOT NULL\n AND (\n LOWER(COALESCE(p.PlayDescription, '')) LIKE '%sac, bunt%'\n OR LOWER(COALESCE(p.PlayDescription, '')) LIKE '%bunt, sac%'\n )\n AND (\n (UPPER(p.HomeTeamName) = 'CLEMSON' AND p.BatterTeam = p.HomeTeamID)\n OR (UPPER(p.VisitorTeamName) = 'CLEMSON' AND p.BatterTeam = p.VisitingTeamID)\n )\n ),\n matched_sacrifice_bunts AS (\n SELECT *\n FROM (\n SELECT\n COALESCE(ps.PlayerName, p.Batter) AS PlayerName,\n p.GameID,\n p.Season,\n p.SeasonType,\n p.GameDate,\n ROW_NUMBER() OVER (\n PARTITION BY p.ID\n ORDER BY CASE WHEN ps.PlayerName IS NULL THEN 1 ELSE 0 END, ps.PlayerName\n ) AS MatchRank\n FROM sacrifice_bunt_plays AS p\n LEFT JOIN SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game AS ps\n ON ps.IsClemson = 1\n AND ps.GameID = p.GameID\n AND (\n LOWER(ps.LastName) = LOWER(p.BatterLastName)\n OR LOWER(ps.LastName) LIKE LOWER(p.BatterLastName) || '%'\n OR LOWER(p.BatterLastName) LIKE LOWER(ps.LastName) || '%'\n )\n AND (\n p.BatterFirstInitial IS NULL\n OR LOWER(LEFT(ps.FirstName, 1)) = LOWER(p.BatterFirstInitial)\n )\n )\n WHERE MatchRank = 1\n )\n SELECT\n PlayerName,\n GameID,\n MAX(Season) AS Season,\n MAX(SeasonType) AS SeasonType,\n MAX(GameDate) AS GameDate,\n COUNT(*) AS SacrificeBunts\n FROM matched_sacrifice_bunts\n GROUP BY PlayerName, GameID\n)\n GROUP BY PlayerName, GameID, Season\n),\nsacrifice_bunts_by_season AS (\n SELECT\n BuntPlayerName,\n BuntSeason,\n SUM(SacrificeBunts) AS SacrificeBunts\n FROM sacrifice_bunts_by_game\n GROUP BY BuntPlayerName, BuntSeason\n),\npitching_achievement_games AS (\n WITH team_context AS (\n SELECT\n GameID,\n MAX(Pitching_Hits) AS TeamHitsAllowed,\n MAX(TeamErrors) AS TeamErrors\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_team_stats_by_game\n WHERE IsClemson = 1\n GROUP BY GameID\n ),\n pitcher_counts AS (\n SELECT\n GameID,\n COUNT(DISTINCT PlayerName) AS PitcherCount\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1\n AND Pitcher_Appearances > 0\n GROUP BY GameID\n ),\n pitcher_games AS (\n SELECT\n p.PlayerName,\n p.Season,\n p.GameID,\n COALESCE(t.TeamHitsAllowed, 999999) AS TeamHitsAllowed,\n COALESCE(t.TeamErrors, 0) AS TeamErrors,\n COALESCE(pc.PitcherCount, 1) AS PitcherCount,\n COALESCE(p.Pitcher_CompleteGames, 0) AS CompleteGames,\n COALESCE(p.Pitcher_Hits, 0) AS HitsAllowed,\n COALESCE(p.Pitcher_Runs, 0) AS RunsAllowed,\n COALESCE(p.Pitcher_BaseOnBalls, 0) AS WalksAllowed,\n COALESCE(p.Pitcher_HitByPitch, 0) AS HitByPitchAllowed,\n COALESCE(p.Pitcher_BattersFaced, 0) AS BattersFaced,\n CAST(FLOOR(COALESCE(p.Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(p.Pitcher_InningsPitched, 0) - FLOOR(COALESCE(p.Pitcher_InningsPitched, 0))) * 10) AS INTEGER) AS TotalOuts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game AS p\n LEFT JOIN team_context AS t\n ON p.GameID = t.GameID\n LEFT JOIN pitcher_counts AS pc\n ON p.GameID = pc.GameID\n WHERE p.IsClemson = 1\n AND p.Pitcher_Appearances > 0\n AND p.SeasonType IN ('REG', 'ACC', 'NCAA')\n )\n SELECT\n PlayerName,\n Season,\n GameID,\n CASE\n WHEN CompleteGames >= 1\n AND HitsAllowed = 0\n AND TeamHitsAllowed = 0\n THEN 1 ELSE 0\n END AS NoHitter,\n CASE\n WHEN (CompleteGames >= 1\n AND HitsAllowed = 0\n AND TeamHitsAllowed = 0)\n OR (PitcherCount > 1\n AND TeamHitsAllowed = 0)\n THEN 1 ELSE 0\n END AS CombinedNoHitter,\n CASE\n WHEN PitcherCount = 1\n AND CompleteGames >= 1\n AND TeamHitsAllowed = 0\n AND HitsAllowed = 0\n AND RunsAllowed = 0\n AND WalksAllowed = 0\n AND HitByPitchAllowed = 0\n AND TeamErrors = 0\n AND BattersFaced = TotalOuts\n THEN 1 ELSE 0\n END AS PerfectGame\n FROM pitcher_games\n),\npitching_achievements_by_season AS (\n SELECT\n PlayerName AS AchievementPlayerName,\n Season AS AchievementSeason,\n SUM(NoHitter) AS NoHitters,\n SUM(CombinedNoHitter) AS CombinedNoHitters,\n SUM(PerfectGame) AS PerfectGames\n FROM pitching_achievement_games\n GROUP BY PlayerName, Season\n),\nseason_stats AS (\n SELECT\n PlayerName,\n 'Season' AS RecordType,\n CAST(Season AS VARCHAR) AS RecordContext,\n CAST(NULL AS VARCHAR) AS RecordUrl,\n SUM(COALESCE(Hitter_AtBats, 0)) AS HitterAtBats,\n SUM(COALESCE(Hitter_HomeRun, 0)) AS HomeRuns,\n SUM(COALESCE(Hitter_Hits, 0)) AS Hits,\n SUM(COALESCE(Hitter_RunnersBattedIn, 0)) AS RBIs,\n SUM(COALESCE(Hitter_Runs, 0)) AS Runs,\n SUM(COALESCE(Hitter_BaseOnBalls, 0)) AS Walks,\n SUM(COALESCE(Hitter_HitbyPitch, 0)) AS HBP,\n SUM(COALESCE(Hitter_StolenBases, 0)) AS StolenBases,\n SUM(COALESCE(Hitter_Doubles, 0)) AS Doubles,\n SUM(COALESCE(Hitter_Triples, 0)) AS Triples,\n SUM(COALESCE(Hitter_SacrificeFlies, 0)) AS SacrificeFlies,\n SUM(COALESCE(Hitter_SacrificeHits, 0)) AS SacrificeHits,\n COALESCE(MAX(sb.SacrificeBunts), 0) AS SacrificeBunts,\n SUM(\n COALESCE(Hitter_Hits, 0)\n - COALESCE(Hitter_Doubles, 0)\n - COALESCE(Hitter_Triples, 0)\n - COALESCE(Hitter_HomeRun, 0)\n + 2 * COALESCE(Hitter_Doubles, 0)\n + 3 * COALESCE(Hitter_Triples, 0)\n + 4 * COALESCE(Hitter_HomeRun, 0)\n ) AS TotalBases,\n SUM(CASE WHEN COALESCE(Pitcher_GameStarted, 0) = 1 THEN 1 ELSE 0 END) AS PitcherGamesStarted,\n SUM(CASE WHEN COALESCE(Pitcher_Appearances, 0) >= 1 THEN 1 ELSE 0 END) AS PitcherAppearances,\n SUM(COALESCE(Pitcher_EarnedRuns, 0)) AS PitcherEarnedRuns,\n SUM(COALESCE(Pitcher_CompleteGames, 0)) AS CompleteGames,\n SUM(CASE WHEN COALESCE(Pitcher_Save, 0) >= 1 THEN 1 ELSE 0 END) AS Saves,\n SUM(COALESCE(Pitcher_Shutout, 0)) AS SoloShutouts,\n SUM(\n CASE\n WHEN COALESCE(Pitcher_Shutout, 0) >= 1 OR COALESCE(Pitcher_CombinedShutout, 0) >= 1 THEN 1\n ELSE 0\n END\n ) AS CombinedShutouts,\n COALESCE(MAX(pa.NoHitters), 0) AS NoHitters,\n COALESCE(MAX(pa.CombinedNoHitters), 0) AS CombinedNoHitters,\n COALESCE(MAX(pa.PerfectGames), 0) AS PerfectGames,\n SUM(COALESCE(Pitcher_BattersFaced, 0)) AS BattersFaced,\n SUM(COALESCE(Pitcher_AtBats, 0)) AS PitchingAtBats,\n SUM(COALESCE(Pitcher_StrikeOuts, 0)) AS Strikeouts,\n SUM(COALESCE(Pitcher_Pitches, 0)) AS Pitches,\n SUM(COALESCE(Pitcher_Strikes, 0)) AS Strikes,\n SUM(\n CAST(FLOOR(COALESCE(Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(Pitcher_InningsPitched, 0) - FLOOR(COALESCE(Pitcher_InningsPitched, 0))) * 10) AS INTEGER)\n ) AS TotalOuts,\n SUM(COALESCE(GamesPlayed, 0)) AS GamesPlayed,\n SUM(COALESCE(GamesStarted, 0)) AS GamesStarted,\n SUM(COALESCE(Field_PutOuts, 0)) AS PutOuts,\n SUM(COALESCE(Field_Assists, 0)) AS Assists,\n SUM(COALESCE(Field_Errors, 0)) AS Errors,\n SUM(COALESCE(Field_DoublePlays, 0)) AS DoublePlays\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n LEFT JOIN sacrifice_bunts_by_season AS sb\n ON PlayerName = sb.BuntPlayerName\n AND Season = sb.BuntSeason\n LEFT JOIN pitching_achievements_by_season AS pa\n ON PlayerName = pa.AchievementPlayerName\n AND Season = pa.AchievementSeason\n WHERE IsClemson = 1\n AND SeasonType IN ('REG', 'ACC', 'NCAA')\n GROUP BY PlayerName, Season\n),\ngame_context AS (\n SELECT\n GameID,\n MAX(GameDate) AS GameDate,\n MAX(Season) AS Season,\n MAX(OpponentName) AS Opponent,\n CONCAT(\n CASE WHEN MAX(IsClemsonWin) = 1 THEN 'W' ELSE 'L' END,\n ' ',\n CAST(MAX(Clemson_Final_Runs) AS INT),\n '-',\n CAST(MAX(Opponent_Final_Runs) AS INT)\n ) AS Score\n FROM SPORTS_INFO_DW_REPORTING.game_data\n GROUP BY GameID\n),\nsingle_game_stats AS (\n SELECT\n p.PlayerName,\n 'Single Game' AS RecordType,\n CONCAT(\n CAST(MAX(COALESCE(g.GameDate, p.GameDate)) AS VARCHAR),\n ' vs ',\n COALESCE(MAX(g.Opponent), 'Unknown'),\n ' (',\n COALESCE(MAX(g.Score), 'Score N/A'),\n ')'\n ) AS RecordContext,\n CAST(NULL AS VARCHAR) AS RecordUrl,\n SUM(COALESCE(p.Hitter_AtBats, 0)) AS HitterAtBats,\n SUM(COALESCE(p.Hitter_HomeRun, 0)) AS HomeRuns,\n SUM(COALESCE(p.Hitter_Hits, 0)) AS Hits,\n SUM(COALESCE(p.Hitter_RunnersBattedIn, 0)) AS RBIs,\n SUM(COALESCE(p.Hitter_Runs, 0)) AS Runs,\n SUM(COALESCE(p.Hitter_BaseOnBalls, 0)) AS Walks,\n SUM(COALESCE(p.Hitter_HitbyPitch, 0)) AS HBP,\n SUM(COALESCE(p.Hitter_StolenBases, 0)) AS StolenBases,\n SUM(COALESCE(p.Hitter_Doubles, 0)) AS Doubles,\n SUM(COALESCE(p.Hitter_Triples, 0)) AS Triples,\n SUM(COALESCE(p.Hitter_SacrificeFlies, 0)) AS SacrificeFlies,\n SUM(COALESCE(p.Hitter_SacrificeHits, 0)) AS SacrificeHits,\n COALESCE(MAX(sb.SacrificeBunts), 0) AS SacrificeBunts,\n SUM(\n COALESCE(p.Hitter_Hits, 0)\n - COALESCE(p.Hitter_Doubles, 0)\n - COALESCE(p.Hitter_Triples, 0)\n - COALESCE(p.Hitter_HomeRun, 0)\n + 2 * COALESCE(p.Hitter_Doubles, 0)\n + 3 * COALESCE(p.Hitter_Triples, 0)\n + 4 * COALESCE(p.Hitter_HomeRun, 0)\n ) AS TotalBases,\n SUM(CASE WHEN COALESCE(p.Pitcher_GameStarted, 0) = 1 THEN 1 ELSE 0 END) AS PitcherGamesStarted,\n SUM(CASE WHEN COALESCE(p.Pitcher_Appearances, 0) >= 1 THEN 1 ELSE 0 END) AS PitcherAppearances,\n SUM(COALESCE(p.Pitcher_EarnedRuns, 0)) AS PitcherEarnedRuns,\n SUM(COALESCE(p.Pitcher_CompleteGames, 0)) AS CompleteGames,\n SUM(CASE WHEN COALESCE(p.Pitcher_Save, 0) >= 1 THEN 1 ELSE 0 END) AS Saves,\n SUM(COALESCE(p.Pitcher_Shutout, 0)) AS SoloShutouts,\n SUM(\n CASE\n WHEN COALESCE(p.Pitcher_Shutout, 0) >= 1 OR COALESCE(p.Pitcher_CombinedShutout, 0) >= 1 THEN 1\n ELSE 0\n END\n ) AS CombinedShutouts,\n 0 AS NoHitters,\n 0 AS CombinedNoHitters,\n 0 AS PerfectGames,\n SUM(COALESCE(p.Pitcher_BattersFaced, 0)) AS BattersFaced,\n SUM(COALESCE(p.Pitcher_AtBats, 0)) AS PitchingAtBats,\n SUM(COALESCE(p.Pitcher_StrikeOuts, 0)) AS Strikeouts,\n SUM(COALESCE(p.Pitcher_Pitches, 0)) AS Pitches,\n SUM(COALESCE(p.Pitcher_Strikes, 0)) AS Strikes,\n SUM(\n CAST(FLOOR(COALESCE(p.Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(p.Pitcher_InningsPitched, 0) - FLOOR(COALESCE(p.Pitcher_InningsPitched, 0))) * 10) AS INTEGER)\n ) AS TotalOuts,\n SUM(COALESCE(p.GamesPlayed, 0)) AS GamesPlayed,\n SUM(COALESCE(p.GamesStarted, 0)) AS GamesStarted,\n SUM(COALESCE(p.Field_PutOuts, 0)) AS PutOuts,\n SUM(COALESCE(p.Field_Assists, 0)) AS Assists,\n SUM(COALESCE(p.Field_Errors, 0)) AS Errors,\n SUM(COALESCE(p.Field_DoublePlays, 0)) AS DoublePlays\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game AS p\n LEFT JOIN game_context AS g\n ON p.GameID = g.GameID\n LEFT JOIN sacrifice_bunts_by_game AS sb\n ON p.PlayerName = sb.BuntPlayerName\n AND p.GameID = sb.BuntGameID\n WHERE p.IsClemson = 1\n AND p.SeasonType IN ('REG', 'ACC', 'NCAA')\n GROUP BY p.PlayerName, p.GameID\n),\ncareer_stats AS (\n SELECT\n PlayerName,\n 'Career' AS RecordType,\n 'Career' AS RecordContext,\n CAST(NULL AS VARCHAR) AS RecordUrl,\n SUM(HitterAtBats) AS HitterAtBats,\n SUM(HomeRuns) AS HomeRuns,\n SUM(Hits) AS Hits,\n SUM(RBIs) AS RBIs,\n SUM(Runs) AS Runs,\n SUM(Walks) AS Walks,\n SUM(HBP) AS HBP,\n SUM(StolenBases) AS StolenBases,\n SUM(Doubles) AS Doubles,\n SUM(Triples) AS Triples,\n SUM(SacrificeFlies) AS SacrificeFlies,\n SUM(SacrificeHits) AS SacrificeHits,\n SUM(SacrificeBunts) AS SacrificeBunts,\n SUM(TotalBases) AS TotalBases,\n SUM(PitcherGamesStarted) AS PitcherGamesStarted,\n SUM(PitcherAppearances) AS PitcherAppearances,\n SUM(PitcherEarnedRuns) AS PitcherEarnedRuns,\n SUM(CompleteGames) AS CompleteGames,\n SUM(Saves) AS Saves,\n SUM(SoloShutouts) AS SoloShutouts,\n SUM(CombinedShutouts) AS CombinedShutouts,\n SUM(NoHitters) AS NoHitters,\n SUM(CombinedNoHitters) AS CombinedNoHitters,\n SUM(PerfectGames) AS PerfectGames,\n SUM(BattersFaced) AS BattersFaced,\n SUM(PitchingAtBats) AS PitchingAtBats,\n SUM(Strikeouts) AS Strikeouts,\n SUM(Pitches) AS Pitches,\n SUM(Strikes) AS Strikes,\n SUM(TotalOuts) AS TotalOuts,\n SUM(GamesPlayed) AS GamesPlayed,\n SUM(GamesStarted) AS GamesStarted,\n SUM(PutOuts) AS PutOuts,\n SUM(Assists) AS Assists,\n SUM(Errors) AS Errors,\n SUM(DoublePlays) AS DoublePlays\n FROM season_stats\n GROUP BY PlayerName\n),\nbase AS (\n SELECT * FROM season_stats\n UNION ALL\n SELECT * FROM career_stats\n UNION ALL\n SELECT * FROM single_game_stats\n),\nrecord_values AS (\n SELECT\n b.PlayerName,\n b.RecordType,\n b.RecordContext,\n s.Category,\n s.RecordName,\n s.StatKey,\n s.Url AS Url,\n HitterAtBats,\n PitcherAppearances,\n GamesPlayed,\n GamesStarted,\n PutOuts,\n Assists,\n Errors,\n TotalOuts,\n TotalBases,\n CASE s.StatKey\n WHEN 'HomeRuns' THEN CAST(HomeRuns AS DOUBLE)\n WHEN 'Hits' THEN CAST(Hits AS DOUBLE)\n WHEN 'RBIs' THEN CAST(RBIs AS DOUBLE)\n WHEN 'Runs' THEN CAST(Runs AS DOUBLE)\n WHEN 'Walks' THEN CAST(Walks AS DOUBLE)\n WHEN 'HBP' THEN CAST(HBP AS DOUBLE)\n WHEN 'StolenBases' THEN CAST(StolenBases AS DOUBLE)\n WHEN 'AtBats' THEN CAST(HitterAtBats AS DOUBLE)\n WHEN 'Doubles' THEN CAST(Doubles AS DOUBLE)\n WHEN 'Triples' THEN CAST(Triples AS DOUBLE)\n WHEN 'TotalBases' THEN CAST(TotalBases AS DOUBLE)\n WHEN 'GamesPlayed' THEN CAST(GamesPlayed AS DOUBLE)\n WHEN 'GamesStarted' THEN CAST(GamesStarted AS DOUBLE)\n WHEN 'BA' THEN ROUND(1.0 * Hits / NULLIF(HitterAtBats, 0), 3)\n WHEN 'SLG' THEN ROUND(1.0 * (Hits - Doubles - Triples - HomeRuns + 2 * Doubles + 3 * Triples + 4 * HomeRuns) / NULLIF(HitterAtBats, 0), 3)\n WHEN 'OBP' THEN ROUND(1.0 * (Hits + Walks + HBP) / NULLIF(HitterAtBats + Walks + HBP + SacrificeFlies, 0), 3)\n WHEN 'SacrificeFlies' THEN CAST(SacrificeFlies AS DOUBLE)\n WHEN 'SacrificeHits' THEN CAST(SacrificeHits AS DOUBLE)\n WHEN 'SacrificeBunts' THEN CAST(SacrificeBunts AS DOUBLE)\n WHEN 'InningsPitched' THEN FLOOR(TotalOuts / 3.0) + (MOD(TotalOuts, 3) / 10.0)\n WHEN 'PitcherGamesStarted' THEN CAST(PitcherGamesStarted AS DOUBLE)\n WHEN 'PitcherAppearances' THEN CAST(PitcherAppearances AS DOUBLE)\n WHEN 'PitcherERA' THEN CAST(CAST(PitcherEarnedRuns * 7.0 / NULLIF(TotalOuts / 3.0, 0) AS DECIMAL(10,2)) AS DOUBLE)\n WHEN 'CompleteGames' THEN CAST(CompleteGames AS DOUBLE)\n WHEN 'Saves' THEN CAST(Saves AS DOUBLE)\n WHEN 'SoloShutouts' THEN CAST(SoloShutouts AS DOUBLE)\n WHEN 'CombinedShutouts' THEN CAST(CombinedShutouts AS DOUBLE)\n WHEN 'NoHitters' THEN CAST(NoHitters AS DOUBLE)\n WHEN 'CombinedNoHitters' THEN CAST(CombinedNoHitters AS DOUBLE)\n WHEN 'PerfectGames' THEN CAST(PerfectGames AS DOUBLE)\n WHEN 'BattersFaced' THEN CAST(BattersFaced AS DOUBLE)\n WHEN 'PitchingAtBats' THEN CAST(PitchingAtBats AS DOUBLE)\n WHEN 'Strikeouts' THEN CAST(Strikeouts AS DOUBLE)\n WHEN 'Pitches' THEN CAST(Pitches AS DOUBLE)\n WHEN 'Strikes' THEN CAST(Strikes AS DOUBLE)\n WHEN 'FieldingPercentage' THEN ROUND((PutOuts + Assists) * 1.0 / NULLIF(PutOuts + Assists + Errors, 0), 3)\n WHEN 'PutOuts' THEN CAST(PutOuts AS DOUBLE)\n WHEN 'Assists' THEN CAST(Assists AS DOUBLE)\n WHEN 'DoublePlays' THEN CAST(DoublePlays AS DOUBLE)\n END AS StatValue,\n CASE\n WHEN s.StatKey = 'InningsPitched' THEN CAST(TotalOuts AS DOUBLE)\n WHEN s.StatKey = 'FieldingPercentage' THEN ROUND((PutOuts + Assists) * 1.0 / NULLIF(PutOuts + Assists + Errors, 0), 3)\n ELSE CASE s.StatKey\n WHEN 'HomeRuns' THEN CAST(HomeRuns AS DOUBLE)\n WHEN 'Hits' THEN CAST(Hits AS DOUBLE)\n WHEN 'RBIs' THEN CAST(RBIs AS DOUBLE)\n WHEN 'Runs' THEN CAST(Runs AS DOUBLE)\n WHEN 'Walks' THEN CAST(Walks AS DOUBLE)\n WHEN 'HBP' THEN CAST(HBP AS DOUBLE)\n WHEN 'StolenBases' THEN CAST(StolenBases AS DOUBLE)\n WHEN 'AtBats' THEN CAST(HitterAtBats AS DOUBLE)\n WHEN 'Doubles' THEN CAST(Doubles AS DOUBLE)\n WHEN 'Triples' THEN CAST(Triples AS DOUBLE)\n WHEN 'TotalBases' THEN CAST(TotalBases AS DOUBLE)\n WHEN 'GamesPlayed' THEN CAST(GamesPlayed AS DOUBLE)\n WHEN 'GamesStarted' THEN CAST(GamesStarted AS DOUBLE)\n WHEN 'BA' THEN ROUND(1.0 * Hits / NULLIF(HitterAtBats, 0), 3)\n WHEN 'SLG' THEN ROUND(1.0 * (Hits - Doubles - Triples - HomeRuns + 2 * Doubles + 3 * Triples + 4 * HomeRuns) / NULLIF(HitterAtBats, 0), 3)\n WHEN 'OBP' THEN ROUND(1.0 * (Hits + Walks + HBP) / NULLIF(HitterAtBats + Walks + HBP + SacrificeFlies, 0), 3)\n WHEN 'SacrificeFlies' THEN CAST(SacrificeFlies AS DOUBLE)\n WHEN 'SacrificeHits' THEN CAST(SacrificeHits AS DOUBLE)\n WHEN 'SacrificeBunts' THEN CAST(SacrificeBunts AS DOUBLE)\n WHEN 'PitcherGamesStarted' THEN CAST(PitcherGamesStarted AS DOUBLE)\n WHEN 'PitcherAppearances' THEN CAST(PitcherAppearances AS DOUBLE)\n WHEN 'PitcherERA' THEN -CAST(CAST(PitcherEarnedRuns * 7.0 / NULLIF(TotalOuts / 3.0, 0) AS DECIMAL(10,2)) AS DOUBLE)\n WHEN 'CompleteGames' THEN CAST(CompleteGames AS DOUBLE)\n WHEN 'Saves' THEN CAST(Saves AS DOUBLE)\n WHEN 'SoloShutouts' THEN CAST(SoloShutouts AS DOUBLE)\n WHEN 'CombinedShutouts' THEN CAST(CombinedShutouts AS DOUBLE)\n WHEN 'NoHitters' THEN CAST(NoHitters AS DOUBLE)\n WHEN 'CombinedNoHitters' THEN CAST(CombinedNoHitters AS DOUBLE)\n WHEN 'PerfectGames' THEN CAST(PerfectGames AS DOUBLE)\n WHEN 'BattersFaced' THEN CAST(BattersFaced AS DOUBLE)\n WHEN 'PitchingAtBats' THEN CAST(PitchingAtBats AS DOUBLE)\n WHEN 'Strikeouts' THEN CAST(Strikeouts AS DOUBLE)\n WHEN 'Pitches' THEN CAST(Pitches AS DOUBLE)\n WHEN 'Strikes' THEN CAST(Strikes AS DOUBLE)\n WHEN 'PutOuts' THEN CAST(PutOuts AS DOUBLE)\n WHEN 'Assists' THEN CAST(Assists AS DOUBLE)\n WHEN 'DoublePlays' THEN CAST(DoublePlays AS DOUBLE)\n END\n END AS RankSortValue\n FROM base AS b\n CROSS JOIN (\n VALUES\n ('Hitting', 'Home Runs', 'HomeRuns', '/individual-records/hitting'),\n ('Hitting', 'Hits', 'Hits', '/individual-records/hitting'),\n ('Hitting', 'RBIs', 'RBIs', '/individual-records/hitting'),\n ('Hitting', 'Runs', 'Runs', '/individual-records/hitting'),\n ('Hitting', 'Walks', 'Walks', '/individual-records/hitting'),\n ('Hitting', 'HBP', 'HBP', '/individual-records/hitting'),\n ('Hitting', 'Total Bases', 'TotalBases', '/individual-records/hitting'),\n ('Hitting', 'Stolen Bases', 'StolenBases', '/individual-records/hitting'),\n ('Hitting', 'At Bats', 'AtBats', '/individual-records/hitting'),\n ('Hitting', 'Doubles', 'Doubles', '/individual-records/hitting'),\n ('Hitting', 'Triples', 'Triples', '/individual-records/hitting'),\n ('Hitting', 'Games Played', 'GamesPlayed', '/individual-records/hitting'),\n ('Hitting', 'Games Started', 'GamesStarted', '/individual-records/hitting'),\n ('Hitting', 'BA', 'BA', '/individual-records/hitting'),\n ('Hitting', 'SLG', 'SLG', '/individual-records/hitting'),\n ('Hitting', 'OBP', 'OBP', '/individual-records/hitting'),\n ('Hitting', 'Sacrifice Flies', 'SacrificeFlies', '/individual-records/hitting'),\n ('Hitting', 'Sacrifice Hits', 'SacrificeHits', '/individual-records/hitting'),\n ('Hitting', 'Sacrifice Bunts', 'SacrificeBunts', '/individual-records/hitting'),\n ('Pitching', 'Innings Pitched', 'InningsPitched', '/individual-records/pitching'),\n ('Pitching', 'Games Started', 'PitcherGamesStarted', '/individual-records/pitching'),\n ('Pitching', 'Appearances', 'PitcherAppearances', '/individual-records/pitching'),\n ('Pitching', 'ERA', 'PitcherERA', '/individual-records/pitching'),\n ('Pitching', 'Complete Games', 'CompleteGames', '/individual-records/pitching'),\n ('Pitching', 'Saves', 'Saves', '/individual-records/pitching'),\n ('Pitching', 'Solo Shutouts', 'SoloShutouts', '/individual-records/pitching'),\n ('Pitching', 'Combined Shutouts', 'CombinedShutouts', '/individual-records/pitching'),\n ('Pitching', 'No Hitters', 'CombinedNoHitters', '/individual-records/pitching'),\n ('Pitching', 'Perfect Games', 'PerfectGames', '/individual-records/pitching'),\n ('Pitching', 'Batters Faced', 'BattersFaced', '/individual-records/pitching'),\n ('Pitching', 'At Bats', 'PitchingAtBats', '/individual-records/pitching'),\n ('Pitching', 'Strikeouts', 'Strikeouts', '/individual-records/pitching'),\n ('Pitching', 'Pitches', 'Pitches', '/individual-records/pitching'),\n ('Pitching', 'Strikes', 'Strikes', '/individual-records/pitching'),\n ('Fielding', 'FPCT', 'FieldingPercentage', '/individual-records/fielding'),\n ('Fielding', 'Putouts', 'PutOuts', '/individual-records/fielding'),\n ('Fielding', 'Assists', 'Assists', '/individual-records/fielding'),\n ('Fielding', 'Double Plays', 'DoublePlays', '/individual-records/fielding')\n ) AS s(Category, RecordName, StatKey, Url)\n),\neligible_records AS (\n SELECT\n *,\n CASE\n WHEN StatKey = 'InningsPitched'\n THEN CONCAT(CAST(CAST(FLOOR(TotalOuts / 3.0) AS INTEGER) AS VARCHAR), '.', CAST(CAST(MOD(TotalOuts, 3) AS INTEGER) AS VARCHAR))\n WHEN StatKey = 'PitcherERA'\n THEN printf('%.2f', StatValue)\n WHEN StatKey IN ('BA', 'SLG', 'OBP', 'FieldingPercentage')\n THEN printf('%.3f', StatValue)\n ELSE CAST(CAST(StatValue AS INTEGER) AS VARCHAR)\n END AS DisplayValue\n FROM record_values\n WHERE RankSortValue IS NOT NULL\n AND (\n (RecordType = 'Single Game' AND (\n (Category = 'Hitting' AND StatKey IN (\n 'AtBats',\n 'Hits',\n 'Doubles',\n 'Triples',\n 'HomeRuns',\n 'RBIs',\n 'Runs',\n 'StolenBases',\n 'Walks',\n 'HBP',\n 'TotalBases',\n 'SacrificeFlies',\n 'SacrificeHits',\n 'SacrificeBunts'\n ) AND StatValue > 0)\n OR (Category = 'Fielding' AND StatKey IN ('PutOuts', 'Assists') AND StatValue > 0)\n OR (Category = 'Pitching' AND StatKey IN ('InningsPitched', 'Strikeouts') AND RankSortValue > 0)\n ))\n OR (RecordType <> 'Single Game' AND (\n (Category = 'Hitting' AND (\n StatKey IN ('StolenBases', 'GamesPlayed')\n OR (StatKey IN ('GamesStarted', 'SacrificeFlies', 'SacrificeHits', 'SacrificeBunts') AND StatValue > 0)\n OR HitterAtBats > 0\n ))\n OR (Category = 'Pitching' AND PitcherAppearances > 0 AND (\n StatKey NOT IN ('CompleteGames', 'Saves', 'SoloShutouts', 'CombinedShutouts', 'NoHitters', 'CombinedNoHitters', 'PerfectGames')\n OR StatValue > 0\n ))\n OR (StatKey = 'FieldingPercentage' AND RecordType = 'Season' AND GamesPlayed > 40 AND PutOuts + Assists + Errors > 0)\n OR (StatKey IN ('FieldingPercentage', 'PutOuts') AND RecordType = 'Career' AND GamesPlayed > 80 AND PutOuts > 40)\n OR (Category = 'Fielding' AND StatKey NOT IN ('FieldingPercentage', 'PutOuts'))\n OR (Category = 'Fielding' AND StatKey = 'PutOuts' AND RecordType = 'Season')\n ))\n )\n),\nranked AS (\n SELECT\n *,\n RANK() OVER (\n PARTITION BY RecordType, Category, RecordName\n ORDER BY RankSortValue DESC NULLS LAST\n ) AS Rank\n FROM eligible_records\n)\nSELECT\n Rank,\n Category,\n RecordType,\n CONCAT(RecordType, ' ', RecordName) AS RecordLabel,\n RecordName,\n RecordContext,\n DisplayValue,\n Url,\n CASE WHEN RecordName IN ('No Hitters', 'Perfect Games') THEN 0 ELSE 1 END AS SortPriority,\n CASE\n WHEN RecordName IN ('No Hitters', 'Perfect Games') THEN 'PA'\n ELSE CONCAT('#', CAST(Rank AS VARCHAR))\n END AS RankDisplay\nFROM ranked\nWHERE Rank <= 10\n AND PlayerName = '${params.PlayerName}'\nORDER BY SortPriority, Rank, RecordType DESC, Category, RecordName, RecordContext DESC","inputQueryString":"-- Finds the selected player's appearances in Clemson top-10 record lists and links each record to the relevant page.\n\nWITH sacrifice_bunts_by_game AS (\n SELECT\n PlayerName AS BuntPlayerName,\n GameID AS BuntGameID,\n Season AS BuntSeason,\n SUM(SacrificeBunts) AS SacrificeBunts\n FROM (\n WITH sacrifice_bunt_plays AS (\n SELECT\n p.*,\n TRIM(regexp_extract(p.Batter, '^([^,]+)', 1)) AS BatterLastName,\n NULLIF(TRIM(regexp_extract(p.Batter, ',[[:space:]]*([A-Za-z])', 1)), '') AS BatterFirstInitial\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_play_by_play AS p\n WHERE p.InningNumber IS NOT NULL\n AND (\n LOWER(COALESCE(p.PlayDescription, '')) LIKE '%sac, bunt%'\n OR LOWER(COALESCE(p.PlayDescription, '')) LIKE '%bunt, sac%'\n )\n AND (\n (UPPER(p.HomeTeamName) = 'CLEMSON' AND p.BatterTeam = p.HomeTeamID)\n OR (UPPER(p.VisitorTeamName) = 'CLEMSON' AND p.BatterTeam = p.VisitingTeamID)\n )\n ),\n matched_sacrifice_bunts AS (\n SELECT *\n FROM (\n SELECT\n COALESCE(ps.PlayerName, p.Batter) AS PlayerName,\n p.GameID,\n p.Season,\n p.SeasonType,\n p.GameDate,\n ROW_NUMBER() OVER (\n PARTITION BY p.ID\n ORDER BY CASE WHEN ps.PlayerName IS NULL THEN 1 ELSE 0 END, ps.PlayerName\n ) AS MatchRank\n FROM sacrifice_bunt_plays AS p\n LEFT JOIN SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game AS ps\n ON ps.IsClemson = 1\n AND ps.GameID = p.GameID\n AND (\n LOWER(ps.LastName) = LOWER(p.BatterLastName)\n OR LOWER(ps.LastName) LIKE LOWER(p.BatterLastName) || '%'\n OR LOWER(p.BatterLastName) LIKE LOWER(ps.LastName) || '%'\n )\n AND (\n p.BatterFirstInitial IS NULL\n OR LOWER(LEFT(ps.FirstName, 1)) = LOWER(p.BatterFirstInitial)\n )\n )\n WHERE MatchRank = 1\n )\n SELECT\n PlayerName,\n GameID,\n MAX(Season) AS Season,\n MAX(SeasonType) AS SeasonType,\n MAX(GameDate) AS GameDate,\n COUNT(*) AS SacrificeBunts\n FROM matched_sacrifice_bunts\n GROUP BY PlayerName, GameID\n)\n GROUP BY PlayerName, GameID, Season\n),\nsacrifice_bunts_by_season AS (\n SELECT\n BuntPlayerName,\n BuntSeason,\n SUM(SacrificeBunts) AS SacrificeBunts\n FROM sacrifice_bunts_by_game\n GROUP BY BuntPlayerName, BuntSeason\n),\npitching_achievement_games AS (\n WITH team_context AS (\n SELECT\n GameID,\n MAX(Pitching_Hits) AS TeamHitsAllowed,\n MAX(TeamErrors) AS TeamErrors\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_team_stats_by_game\n WHERE IsClemson = 1\n GROUP BY GameID\n ),\n pitcher_counts AS (\n SELECT\n GameID,\n COUNT(DISTINCT PlayerName) AS PitcherCount\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n WHERE IsClemson = 1\n AND Pitcher_Appearances > 0\n GROUP BY GameID\n ),\n pitcher_games AS (\n SELECT\n p.PlayerName,\n p.Season,\n p.GameID,\n COALESCE(t.TeamHitsAllowed, 999999) AS TeamHitsAllowed,\n COALESCE(t.TeamErrors, 0) AS TeamErrors,\n COALESCE(pc.PitcherCount, 1) AS PitcherCount,\n COALESCE(p.Pitcher_CompleteGames, 0) AS CompleteGames,\n COALESCE(p.Pitcher_Hits, 0) AS HitsAllowed,\n COALESCE(p.Pitcher_Runs, 0) AS RunsAllowed,\n COALESCE(p.Pitcher_BaseOnBalls, 0) AS WalksAllowed,\n COALESCE(p.Pitcher_HitByPitch, 0) AS HitByPitchAllowed,\n COALESCE(p.Pitcher_BattersFaced, 0) AS BattersFaced,\n CAST(FLOOR(COALESCE(p.Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(p.Pitcher_InningsPitched, 0) - FLOOR(COALESCE(p.Pitcher_InningsPitched, 0))) * 10) AS INTEGER) AS TotalOuts\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game AS p\n LEFT JOIN team_context AS t\n ON p.GameID = t.GameID\n LEFT JOIN pitcher_counts AS pc\n ON p.GameID = pc.GameID\n WHERE p.IsClemson = 1\n AND p.Pitcher_Appearances > 0\n AND p.SeasonType IN ('REG', 'ACC', 'NCAA')\n )\n SELECT\n PlayerName,\n Season,\n GameID,\n CASE\n WHEN CompleteGames >= 1\n AND HitsAllowed = 0\n AND TeamHitsAllowed = 0\n THEN 1 ELSE 0\n END AS NoHitter,\n CASE\n WHEN (CompleteGames >= 1\n AND HitsAllowed = 0\n AND TeamHitsAllowed = 0)\n OR (PitcherCount > 1\n AND TeamHitsAllowed = 0)\n THEN 1 ELSE 0\n END AS CombinedNoHitter,\n CASE\n WHEN PitcherCount = 1\n AND CompleteGames >= 1\n AND TeamHitsAllowed = 0\n AND HitsAllowed = 0\n AND RunsAllowed = 0\n AND WalksAllowed = 0\n AND HitByPitchAllowed = 0\n AND TeamErrors = 0\n AND BattersFaced = TotalOuts\n THEN 1 ELSE 0\n END AS PerfectGame\n FROM pitcher_games\n),\npitching_achievements_by_season AS (\n SELECT\n PlayerName AS AchievementPlayerName,\n Season AS AchievementSeason,\n SUM(NoHitter) AS NoHitters,\n SUM(CombinedNoHitter) AS CombinedNoHitters,\n SUM(PerfectGame) AS PerfectGames\n FROM pitching_achievement_games\n GROUP BY PlayerName, Season\n),\nseason_stats AS (\n SELECT\n PlayerName,\n 'Season' AS RecordType,\n CAST(Season AS VARCHAR) AS RecordContext,\n CAST(NULL AS VARCHAR) AS RecordUrl,\n SUM(COALESCE(Hitter_AtBats, 0)) AS HitterAtBats,\n SUM(COALESCE(Hitter_HomeRun, 0)) AS HomeRuns,\n SUM(COALESCE(Hitter_Hits, 0)) AS Hits,\n SUM(COALESCE(Hitter_RunnersBattedIn, 0)) AS RBIs,\n SUM(COALESCE(Hitter_Runs, 0)) AS Runs,\n SUM(COALESCE(Hitter_BaseOnBalls, 0)) AS Walks,\n SUM(COALESCE(Hitter_HitbyPitch, 0)) AS HBP,\n SUM(COALESCE(Hitter_StolenBases, 0)) AS StolenBases,\n SUM(COALESCE(Hitter_Doubles, 0)) AS Doubles,\n SUM(COALESCE(Hitter_Triples, 0)) AS Triples,\n SUM(COALESCE(Hitter_SacrificeFlies, 0)) AS SacrificeFlies,\n SUM(COALESCE(Hitter_SacrificeHits, 0)) AS SacrificeHits,\n COALESCE(MAX(sb.SacrificeBunts), 0) AS SacrificeBunts,\n SUM(\n COALESCE(Hitter_Hits, 0)\n - COALESCE(Hitter_Doubles, 0)\n - COALESCE(Hitter_Triples, 0)\n - COALESCE(Hitter_HomeRun, 0)\n + 2 * COALESCE(Hitter_Doubles, 0)\n + 3 * COALESCE(Hitter_Triples, 0)\n + 4 * COALESCE(Hitter_HomeRun, 0)\n ) AS TotalBases,\n SUM(CASE WHEN COALESCE(Pitcher_GameStarted, 0) = 1 THEN 1 ELSE 0 END) AS PitcherGamesStarted,\n SUM(CASE WHEN COALESCE(Pitcher_Appearances, 0) >= 1 THEN 1 ELSE 0 END) AS PitcherAppearances,\n SUM(COALESCE(Pitcher_EarnedRuns, 0)) AS PitcherEarnedRuns,\n SUM(COALESCE(Pitcher_CompleteGames, 0)) AS CompleteGames,\n SUM(CASE WHEN COALESCE(Pitcher_Save, 0) >= 1 THEN 1 ELSE 0 END) AS Saves,\n SUM(COALESCE(Pitcher_Shutout, 0)) AS SoloShutouts,\n SUM(\n CASE\n WHEN COALESCE(Pitcher_Shutout, 0) >= 1 OR COALESCE(Pitcher_CombinedShutout, 0) >= 1 THEN 1\n ELSE 0\n END\n ) AS CombinedShutouts,\n COALESCE(MAX(pa.NoHitters), 0) AS NoHitters,\n COALESCE(MAX(pa.CombinedNoHitters), 0) AS CombinedNoHitters,\n COALESCE(MAX(pa.PerfectGames), 0) AS PerfectGames,\n SUM(COALESCE(Pitcher_BattersFaced, 0)) AS BattersFaced,\n SUM(COALESCE(Pitcher_AtBats, 0)) AS PitchingAtBats,\n SUM(COALESCE(Pitcher_StrikeOuts, 0)) AS Strikeouts,\n SUM(COALESCE(Pitcher_Pitches, 0)) AS Pitches,\n SUM(COALESCE(Pitcher_Strikes, 0)) AS Strikes,\n SUM(\n CAST(FLOOR(COALESCE(Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(Pitcher_InningsPitched, 0) - FLOOR(COALESCE(Pitcher_InningsPitched, 0))) * 10) AS INTEGER)\n ) AS TotalOuts,\n SUM(COALESCE(GamesPlayed, 0)) AS GamesPlayed,\n SUM(COALESCE(GamesStarted, 0)) AS GamesStarted,\n SUM(COALESCE(Field_PutOuts, 0)) AS PutOuts,\n SUM(COALESCE(Field_Assists, 0)) AS Assists,\n SUM(COALESCE(Field_Errors, 0)) AS Errors,\n SUM(COALESCE(Field_DoublePlays, 0)) AS DoublePlays\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game\n LEFT JOIN sacrifice_bunts_by_season AS sb\n ON PlayerName = sb.BuntPlayerName\n AND Season = sb.BuntSeason\n LEFT JOIN pitching_achievements_by_season AS pa\n ON PlayerName = pa.AchievementPlayerName\n AND Season = pa.AchievementSeason\n WHERE IsClemson = 1\n AND SeasonType IN ('REG', 'ACC', 'NCAA')\n GROUP BY PlayerName, Season\n),\ngame_context AS (\n SELECT\n GameID,\n MAX(GameDate) AS GameDate,\n MAX(Season) AS Season,\n MAX(OpponentName) AS Opponent,\n CONCAT(\n CASE WHEN MAX(IsClemsonWin) = 1 THEN 'W' ELSE 'L' END,\n ' ',\n CAST(MAX(Clemson_Final_Runs) AS INT),\n '-',\n CAST(MAX(Opponent_Final_Runs) AS INT)\n ) AS Score\n FROM SPORTS_INFO_DW_REPORTING.game_data\n GROUP BY GameID\n),\nsingle_game_stats AS (\n SELECT\n p.PlayerName,\n 'Single Game' AS RecordType,\n CONCAT(\n CAST(MAX(COALESCE(g.GameDate, p.GameDate)) AS VARCHAR),\n ' vs ',\n COALESCE(MAX(g.Opponent), 'Unknown'),\n ' (',\n COALESCE(MAX(g.Score), 'Score N/A'),\n ')'\n ) AS RecordContext,\n CAST(NULL AS VARCHAR) AS RecordUrl,\n SUM(COALESCE(p.Hitter_AtBats, 0)) AS HitterAtBats,\n SUM(COALESCE(p.Hitter_HomeRun, 0)) AS HomeRuns,\n SUM(COALESCE(p.Hitter_Hits, 0)) AS Hits,\n SUM(COALESCE(p.Hitter_RunnersBattedIn, 0)) AS RBIs,\n SUM(COALESCE(p.Hitter_Runs, 0)) AS Runs,\n SUM(COALESCE(p.Hitter_BaseOnBalls, 0)) AS Walks,\n SUM(COALESCE(p.Hitter_HitbyPitch, 0)) AS HBP,\n SUM(COALESCE(p.Hitter_StolenBases, 0)) AS StolenBases,\n SUM(COALESCE(p.Hitter_Doubles, 0)) AS Doubles,\n SUM(COALESCE(p.Hitter_Triples, 0)) AS Triples,\n SUM(COALESCE(p.Hitter_SacrificeFlies, 0)) AS SacrificeFlies,\n SUM(COALESCE(p.Hitter_SacrificeHits, 0)) AS SacrificeHits,\n COALESCE(MAX(sb.SacrificeBunts), 0) AS SacrificeBunts,\n SUM(\n COALESCE(p.Hitter_Hits, 0)\n - COALESCE(p.Hitter_Doubles, 0)\n - COALESCE(p.Hitter_Triples, 0)\n - COALESCE(p.Hitter_HomeRun, 0)\n + 2 * COALESCE(p.Hitter_Doubles, 0)\n + 3 * COALESCE(p.Hitter_Triples, 0)\n + 4 * COALESCE(p.Hitter_HomeRun, 0)\n ) AS TotalBases,\n SUM(CASE WHEN COALESCE(p.Pitcher_GameStarted, 0) = 1 THEN 1 ELSE 0 END) AS PitcherGamesStarted,\n SUM(CASE WHEN COALESCE(p.Pitcher_Appearances, 0) >= 1 THEN 1 ELSE 0 END) AS PitcherAppearances,\n SUM(COALESCE(p.Pitcher_EarnedRuns, 0)) AS PitcherEarnedRuns,\n SUM(COALESCE(p.Pitcher_CompleteGames, 0)) AS CompleteGames,\n SUM(CASE WHEN COALESCE(p.Pitcher_Save, 0) >= 1 THEN 1 ELSE 0 END) AS Saves,\n SUM(COALESCE(p.Pitcher_Shutout, 0)) AS SoloShutouts,\n SUM(\n CASE\n WHEN COALESCE(p.Pitcher_Shutout, 0) >= 1 OR COALESCE(p.Pitcher_CombinedShutout, 0) >= 1 THEN 1\n ELSE 0\n END\n ) AS CombinedShutouts,\n 0 AS NoHitters,\n 0 AS CombinedNoHitters,\n 0 AS PerfectGames,\n SUM(COALESCE(p.Pitcher_BattersFaced, 0)) AS BattersFaced,\n SUM(COALESCE(p.Pitcher_AtBats, 0)) AS PitchingAtBats,\n SUM(COALESCE(p.Pitcher_StrikeOuts, 0)) AS Strikeouts,\n SUM(COALESCE(p.Pitcher_Pitches, 0)) AS Pitches,\n SUM(COALESCE(p.Pitcher_Strikes, 0)) AS Strikes,\n SUM(\n CAST(FLOOR(COALESCE(p.Pitcher_InningsPitched, 0)) AS INTEGER) * 3\n + CAST(ROUND((COALESCE(p.Pitcher_InningsPitched, 0) - FLOOR(COALESCE(p.Pitcher_InningsPitched, 0))) * 10) AS INTEGER)\n ) AS TotalOuts,\n SUM(COALESCE(p.GamesPlayed, 0)) AS GamesPlayed,\n SUM(COALESCE(p.GamesStarted, 0)) AS GamesStarted,\n SUM(COALESCE(p.Field_PutOuts, 0)) AS PutOuts,\n SUM(COALESCE(p.Field_Assists, 0)) AS Assists,\n SUM(COALESCE(p.Field_Errors, 0)) AS Errors,\n SUM(COALESCE(p.Field_DoublePlays, 0)) AS DoublePlays\n FROM SPORTS_INFO_DW_REPORTING.vw_SFTB_player_stats_by_game AS p\n LEFT JOIN game_context AS g\n ON p.GameID = g.GameID\n LEFT JOIN sacrifice_bunts_by_game AS sb\n ON p.PlayerName = sb.BuntPlayerName\n AND p.GameID = sb.BuntGameID\n WHERE p.IsClemson = 1\n AND p.SeasonType IN ('REG', 'ACC', 'NCAA')\n GROUP BY p.PlayerName, p.GameID\n),\ncareer_stats AS (\n SELECT\n PlayerName,\n 'Career' AS RecordType,\n 'Career' AS RecordContext,\n CAST(NULL AS VARCHAR) AS RecordUrl,\n SUM(HitterAtBats) AS HitterAtBats,\n SUM(HomeRuns) AS HomeRuns,\n SUM(Hits) AS Hits,\n SUM(RBIs) AS RBIs,\n SUM(Runs) AS Runs,\n SUM(Walks) AS Walks,\n SUM(HBP) AS HBP,\n SUM(StolenBases) AS StolenBases,\n SUM(Doubles) AS Doubles,\n SUM(Triples) AS Triples,\n SUM(SacrificeFlies) AS SacrificeFlies,\n SUM(SacrificeHits) AS SacrificeHits,\n SUM(SacrificeBunts) AS SacrificeBunts,\n SUM(TotalBases) AS TotalBases,\n SUM(PitcherGamesStarted) AS PitcherGamesStarted,\n SUM(PitcherAppearances) AS PitcherAppearances,\n SUM(PitcherEarnedRuns) AS PitcherEarnedRuns,\n SUM(CompleteGames) AS CompleteGames,\n SUM(Saves) AS Saves,\n SUM(SoloShutouts) AS SoloShutouts,\n SUM(CombinedShutouts) AS CombinedShutouts,\n SUM(NoHitters) AS NoHitters,\n SUM(CombinedNoHitters) AS CombinedNoHitters,\n SUM(PerfectGames) AS PerfectGames,\n SUM(BattersFaced) AS BattersFaced,\n SUM(PitchingAtBats) AS PitchingAtBats,\n SUM(Strikeouts) AS Strikeouts,\n SUM(Pitches) AS Pitches,\n SUM(Strikes) AS Strikes,\n SUM(TotalOuts) AS TotalOuts,\n SUM(GamesPlayed) AS GamesPlayed,\n SUM(GamesStarted) AS GamesStarted,\n SUM(PutOuts) AS PutOuts,\n SUM(Assists) AS Assists,\n SUM(Errors) AS Errors,\n SUM(DoublePlays) AS DoublePlays\n FROM season_stats\n GROUP BY PlayerName\n),\nbase AS (\n SELECT * FROM season_stats\n UNION ALL\n SELECT * FROM career_stats\n UNION ALL\n SELECT * FROM single_game_stats\n),\nrecord_values AS (\n SELECT\n b.PlayerName,\n b.RecordType,\n b.RecordContext,\n s.Category,\n s.RecordName,\n s.StatKey,\n s.Url AS Url,\n HitterAtBats,\n PitcherAppearances,\n GamesPlayed,\n GamesStarted,\n PutOuts,\n Assists,\n Errors,\n TotalOuts,\n TotalBases,\n CASE s.StatKey\n WHEN 'HomeRuns' THEN CAST(HomeRuns AS DOUBLE)\n WHEN 'Hits' THEN CAST(Hits AS DOUBLE)\n WHEN 'RBIs' THEN CAST(RBIs AS DOUBLE)\n WHEN 'Runs' THEN CAST(Runs AS DOUBLE)\n WHEN 'Walks' THEN CAST(Walks AS DOUBLE)\n WHEN 'HBP' THEN CAST(HBP AS DOUBLE)\n WHEN 'StolenBases' THEN CAST(StolenBases AS DOUBLE)\n WHEN 'AtBats' THEN CAST(HitterAtBats AS DOUBLE)\n WHEN 'Doubles' THEN CAST(Doubles AS DOUBLE)\n WHEN 'Triples' THEN CAST(Triples AS DOUBLE)\n WHEN 'TotalBases' THEN CAST(TotalBases AS DOUBLE)\n WHEN 'GamesPlayed' THEN CAST(GamesPlayed AS DOUBLE)\n WHEN 'GamesStarted' THEN CAST(GamesStarted AS DOUBLE)\n WHEN 'BA' THEN ROUND(1.0 * Hits / NULLIF(HitterAtBats, 0), 3)\n WHEN 'SLG' THEN ROUND(1.0 * (Hits - Doubles - Triples - HomeRuns + 2 * Doubles + 3 * Triples + 4 * HomeRuns) / NULLIF(HitterAtBats, 0), 3)\n WHEN 'OBP' THEN ROUND(1.0 * (Hits + Walks + HBP) / NULLIF(HitterAtBats + Walks + HBP + SacrificeFlies, 0), 3)\n WHEN 'SacrificeFlies' THEN CAST(SacrificeFlies AS DOUBLE)\n WHEN 'SacrificeHits' THEN CAST(SacrificeHits AS DOUBLE)\n WHEN 'SacrificeBunts' THEN CAST(SacrificeBunts AS DOUBLE)\n WHEN 'InningsPitched' THEN FLOOR(TotalOuts / 3.0) + (MOD(TotalOuts, 3) / 10.0)\n WHEN 'PitcherGamesStarted' THEN CAST(PitcherGamesStarted AS DOUBLE)\n WHEN 'PitcherAppearances' THEN CAST(PitcherAppearances AS DOUBLE)\n WHEN 'PitcherERA' THEN CAST(CAST(PitcherEarnedRuns * 7.0 / NULLIF(TotalOuts / 3.0, 0) AS DECIMAL(10,2)) AS DOUBLE)\n WHEN 'CompleteGames' THEN CAST(CompleteGames AS DOUBLE)\n WHEN 'Saves' THEN CAST(Saves AS DOUBLE)\n WHEN 'SoloShutouts' THEN CAST(SoloShutouts AS DOUBLE)\n WHEN 'CombinedShutouts' THEN CAST(CombinedShutouts AS DOUBLE)\n WHEN 'NoHitters' THEN CAST(NoHitters AS DOUBLE)\n WHEN 'CombinedNoHitters' THEN CAST(CombinedNoHitters AS DOUBLE)\n WHEN 'PerfectGames' THEN CAST(PerfectGames AS DOUBLE)\n WHEN 'BattersFaced' THEN CAST(BattersFaced AS DOUBLE)\n WHEN 'PitchingAtBats' THEN CAST(PitchingAtBats AS DOUBLE)\n WHEN 'Strikeouts' THEN CAST(Strikeouts AS DOUBLE)\n WHEN 'Pitches' THEN CAST(Pitches AS DOUBLE)\n WHEN 'Strikes' THEN CAST(Strikes AS DOUBLE)\n WHEN 'FieldingPercentage' THEN ROUND((PutOuts + Assists) * 1.0 / NULLIF(PutOuts + Assists + Errors, 0), 3)\n WHEN 'PutOuts' THEN CAST(PutOuts AS DOUBLE)\n WHEN 'Assists' THEN CAST(Assists AS DOUBLE)\n WHEN 'DoublePlays' THEN CAST(DoublePlays AS DOUBLE)\n END AS StatValue,\n CASE\n WHEN s.StatKey = 'InningsPitched' THEN CAST(TotalOuts AS DOUBLE)\n WHEN s.StatKey = 'FieldingPercentage' THEN ROUND((PutOuts + Assists) * 1.0 / NULLIF(PutOuts + Assists + Errors, 0), 3)\n ELSE CASE s.StatKey\n WHEN 'HomeRuns' THEN CAST(HomeRuns AS DOUBLE)\n WHEN 'Hits' THEN CAST(Hits AS DOUBLE)\n WHEN 'RBIs' THEN CAST(RBIs AS DOUBLE)\n WHEN 'Runs' THEN CAST(Runs AS DOUBLE)\n WHEN 'Walks' THEN CAST(Walks AS DOUBLE)\n WHEN 'HBP' THEN CAST(HBP AS DOUBLE)\n WHEN 'StolenBases' THEN CAST(StolenBases AS DOUBLE)\n WHEN 'AtBats' THEN CAST(HitterAtBats AS DOUBLE)\n WHEN 'Doubles' THEN CAST(Doubles AS DOUBLE)\n WHEN 'Triples' THEN CAST(Triples AS DOUBLE)\n WHEN 'TotalBases' THEN CAST(TotalBases AS DOUBLE)\n WHEN 'GamesPlayed' THEN CAST(GamesPlayed AS DOUBLE)\n WHEN 'GamesStarted' THEN CAST(GamesStarted AS DOUBLE)\n WHEN 'BA' THEN ROUND(1.0 * Hits / NULLIF(HitterAtBats, 0), 3)\n WHEN 'SLG' THEN ROUND(1.0 * (Hits - Doubles - Triples - HomeRuns + 2 * Doubles + 3 * Triples + 4 * HomeRuns) / NULLIF(HitterAtBats, 0), 3)\n WHEN 'OBP' THEN ROUND(1.0 * (Hits + Walks + HBP) / NULLIF(HitterAtBats + Walks + HBP + SacrificeFlies, 0), 3)\n WHEN 'SacrificeFlies' THEN CAST(SacrificeFlies AS DOUBLE)\n WHEN 'SacrificeHits' THEN CAST(SacrificeHits AS DOUBLE)\n WHEN 'SacrificeBunts' THEN CAST(SacrificeBunts AS DOUBLE)\n WHEN 'PitcherGamesStarted' THEN CAST(PitcherGamesStarted AS DOUBLE)\n WHEN 'PitcherAppearances' THEN CAST(PitcherAppearances AS DOUBLE)\n WHEN 'PitcherERA' THEN -CAST(CAST(PitcherEarnedRuns * 7.0 / NULLIF(TotalOuts / 3.0, 0) AS DECIMAL(10,2)) AS DOUBLE)\n WHEN 'CompleteGames' THEN CAST(CompleteGames AS DOUBLE)\n WHEN 'Saves' THEN CAST(Saves AS DOUBLE)\n WHEN 'SoloShutouts' THEN CAST(SoloShutouts AS DOUBLE)\n WHEN 'CombinedShutouts' THEN CAST(CombinedShutouts AS DOUBLE)\n WHEN 'NoHitters' THEN CAST(NoHitters AS DOUBLE)\n WHEN 'CombinedNoHitters' THEN CAST(CombinedNoHitters AS DOUBLE)\n WHEN 'PerfectGames' THEN CAST(PerfectGames AS DOUBLE)\n WHEN 'BattersFaced' THEN CAST(BattersFaced AS DOUBLE)\n WHEN 'PitchingAtBats' THEN CAST(PitchingAtBats AS DOUBLE)\n WHEN 'Strikeouts' THEN CAST(Strikeouts AS DOUBLE)\n WHEN 'Pitches' THEN CAST(Pitches AS DOUBLE)\n WHEN 'Strikes' THEN CAST(Strikes AS DOUBLE)\n WHEN 'PutOuts' THEN CAST(PutOuts AS DOUBLE)\n WHEN 'Assists' THEN CAST(Assists AS DOUBLE)\n WHEN 'DoublePlays' THEN CAST(DoublePlays AS DOUBLE)\n END\n END AS RankSortValue\n FROM base AS b\n CROSS JOIN (\n VALUES\n ('Hitting', 'Home Runs', 'HomeRuns', '/individual-records/hitting'),\n ('Hitting', 'Hits', 'Hits', '/individual-records/hitting'),\n ('Hitting', 'RBIs', 'RBIs', '/individual-records/hitting'),\n ('Hitting', 'Runs', 'Runs', '/individual-records/hitting'),\n ('Hitting', 'Walks', 'Walks', '/individual-records/hitting'),\n ('Hitting', 'HBP', 'HBP', '/individual-records/hitting'),\n ('Hitting', 'Total Bases', 'TotalBases', '/individual-records/hitting'),\n ('Hitting', 'Stolen Bases', 'StolenBases', '/individual-records/hitting'),\n ('Hitting', 'At Bats', 'AtBats', '/individual-records/hitting'),\n ('Hitting', 'Doubles', 'Doubles', '/individual-records/hitting'),\n ('Hitting', 'Triples', 'Triples', '/individual-records/hitting'),\n ('Hitting', 'Games Played', 'GamesPlayed', '/individual-records/hitting'),\n ('Hitting', 'Games Started', 'GamesStarted', '/individual-records/hitting'),\n ('Hitting', 'BA', 'BA', '/individual-records/hitting'),\n ('Hitting', 'SLG', 'SLG', '/individual-records/hitting'),\n ('Hitting', 'OBP', 'OBP', '/individual-records/hitting'),\n ('Hitting', 'Sacrifice Flies', 'SacrificeFlies', '/individual-records/hitting'),\n ('Hitting', 'Sacrifice Hits', 'SacrificeHits', '/individual-records/hitting'),\n ('Hitting', 'Sacrifice Bunts', 'SacrificeBunts', '/individual-records/hitting'),\n ('Pitching', 'Innings Pitched', 'InningsPitched', '/individual-records/pitching'),\n ('Pitching', 'Games Started', 'PitcherGamesStarted', '/individual-records/pitching'),\n ('Pitching', 'Appearances', 'PitcherAppearances', '/individual-records/pitching'),\n ('Pitching', 'ERA', 'PitcherERA', '/individual-records/pitching'),\n ('Pitching', 'Complete Games', 'CompleteGames', '/individual-records/pitching'),\n ('Pitching', 'Saves', 'Saves', '/individual-records/pitching'),\n ('Pitching', 'Solo Shutouts', 'SoloShutouts', '/individual-records/pitching'),\n ('Pitching', 'Combined Shutouts', 'CombinedShutouts', '/individual-records/pitching'),\n ('Pitching', 'No Hitters', 'CombinedNoHitters', '/individual-records/pitching'),\n ('Pitching', 'Perfect Games', 'PerfectGames', '/individual-records/pitching'),\n ('Pitching', 'Batters Faced', 'BattersFaced', '/individual-records/pitching'),\n ('Pitching', 'At Bats', 'PitchingAtBats', '/individual-records/pitching'),\n ('Pitching', 'Strikeouts', 'Strikeouts', '/individual-records/pitching'),\n ('Pitching', 'Pitches', 'Pitches', '/individual-records/pitching'),\n ('Pitching', 'Strikes', 'Strikes', '/individual-records/pitching'),\n ('Fielding', 'FPCT', 'FieldingPercentage', '/individual-records/fielding'),\n ('Fielding', 'Putouts', 'PutOuts', '/individual-records/fielding'),\n ('Fielding', 'Assists', 'Assists', '/individual-records/fielding'),\n ('Fielding', 'Double Plays', 'DoublePlays', '/individual-records/fielding')\n ) AS s(Category, RecordName, StatKey, Url)\n),\neligible_records AS (\n SELECT\n *,\n CASE\n WHEN StatKey = 'InningsPitched'\n THEN CONCAT(CAST(CAST(FLOOR(TotalOuts / 3.0) AS INTEGER) AS VARCHAR), '.', CAST(CAST(MOD(TotalOuts, 3) AS INTEGER) AS VARCHAR))\n WHEN StatKey = 'PitcherERA'\n THEN printf('%.2f', StatValue)\n WHEN StatKey IN ('BA', 'SLG', 'OBP', 'FieldingPercentage')\n THEN printf('%.3f', StatValue)\n ELSE CAST(CAST(StatValue AS INTEGER) AS VARCHAR)\n END AS DisplayValue\n FROM record_values\n WHERE RankSortValue IS NOT NULL\n AND (\n (RecordType = 'Single Game' AND (\n (Category = 'Hitting' AND StatKey IN (\n 'AtBats',\n 'Hits',\n 'Doubles',\n 'Triples',\n 'HomeRuns',\n 'RBIs',\n 'Runs',\n 'StolenBases',\n 'Walks',\n 'HBP',\n 'TotalBases',\n 'SacrificeFlies',\n 'SacrificeHits',\n 'SacrificeBunts'\n ) AND StatValue > 0)\n OR (Category = 'Fielding' AND StatKey IN ('PutOuts', 'Assists') AND StatValue > 0)\n OR (Category = 'Pitching' AND StatKey IN ('InningsPitched', 'Strikeouts') AND RankSortValue > 0)\n ))\n OR (RecordType <> 'Single Game' AND (\n (Category = 'Hitting' AND (\n StatKey IN ('StolenBases', 'GamesPlayed')\n OR (StatKey IN ('GamesStarted', 'SacrificeFlies', 'SacrificeHits', 'SacrificeBunts') AND StatValue > 0)\n OR HitterAtBats > 0\n ))\n OR (Category = 'Pitching' AND PitcherAppearances > 0 AND (\n StatKey NOT IN ('CompleteGames', 'Saves', 'SoloShutouts', 'CombinedShutouts', 'NoHitters', 'CombinedNoHitters', 'PerfectGames')\n OR StatValue > 0\n ))\n OR (StatKey = 'FieldingPercentage' AND RecordType = 'Season' AND GamesPlayed > 40 AND PutOuts + Assists + Errors > 0)\n OR (StatKey IN ('FieldingPercentage', 'PutOuts') AND RecordType = 'Career' AND GamesPlayed > 80 AND PutOuts > 40)\n OR (Category = 'Fielding' AND StatKey NOT IN ('FieldingPercentage', 'PutOuts'))\n OR (Category = 'Fielding' AND StatKey = 'PutOuts' AND RecordType = 'Season')\n ))\n )\n),\nranked AS (\n SELECT\n *,\n RANK() OVER (\n PARTITION BY RecordType, Category, RecordName\n ORDER BY RankSortValue DESC NULLS LAST\n ) AS Rank\n FROM eligible_records\n)\nSELECT\n Rank,\n Category,\n RecordType,\n CONCAT(RecordType, ' ', RecordName) AS RecordLabel,\n RecordName,\n RecordContext,\n DisplayValue,\n Url,\n CASE WHEN RecordName IN ('No Hitters', 'Perfect Games') THEN 0 ELSE 1 END AS SortPriority,\n CASE\n WHEN RecordName IN ('No Hitters', 'Perfect Games') THEN 'PA'\n ELSE CONCAT('#', CAST(Rank AS VARCHAR))\n END AS RankDisplay\nFROM ranked\nWHERE Rank <= 10\n AND PlayerName = '${params.PlayerName}'\nORDER BY SortPriority, Rank, RecordType DESC, Category, RecordName, RecordContext DESC","compiled":false,"inline":false},{"id":"player_awards","compiledQueryString":"-- Returns normalized awards and display badges for the selected player profile.\n\nWITH normalized_awards AS (\n SELECT\n RowID,\n PlayerID,\n SportCode,\n Player,\n District,\n Region,\n Conference,\n National,\n AwardType,\n CASE\n WHEN NULLIF(TRIM(Team), '') IS NULL THEN NULL\n WHEN TRIM(Team) = 'F' THEN 'Freshman'\n WHEN TRIM(Team) = '1' THEN 'First'\n WHEN TRIM(Team) = '2' THEN 'Second'\n WHEN TRIM(Team) = '3' THEN 'Third'\n ELSE TRIM(Team)\n END AS Team,\n Season,\n CASE\n WHEN AwardDate = DATE '1970-01-01' THEN NULL\n ELSE STRFTIME(AwardDate, '%Y-%m-%d')\n END AS AwardDate\n FROM SPORTS_INFO_DW_REPORTING.vw_cuad_awards\n)\nSELECT\n RowID,\n PlayerID,\n SportCode,\n Player,\n AwardType,\n Team,\n Season,\n AwardDate,\n '/individual-records' AS Url,\n CASE\n WHEN National = 'Y' THEN 'National'\n WHEN Conference = 'Y' THEN 'Conference'\n WHEN Region = 'Y' THEN 'Regional'\n WHEN District = 'Y' THEN 'District'\n ELSE 'Award'\n END AS AwardScope,\n CONCAT(\n CAST(Season AS VARCHAR),\n CASE\n WHEN AwardDate IS NULL THEN ''\n ELSE CONCAT(' - ', AwardDate)\n END\n ) AS AwardMeta,\n CASE\n WHEN Team = 'First' THEN 'First'\n WHEN Team = 'Second' THEN 'Second'\n WHEN Team = 'Third' THEN 'Third'\n WHEN Team = 'Freshman' THEN 'Freshman'\n ELSE '-'\n END AS TeamBadge\nFROM normalized_awards\nWHERE Player = '${params.PlayerName}'\nORDER BY\n CASE\n WHEN National = 'Y' THEN 1\n WHEN Conference = 'Y' THEN 2\n WHEN Region = 'Y' THEN 3\n WHEN District = 'Y' THEN 4\n ELSE 5\n END,\n Season DESC NULLS LAST,\n AwardDate DESC NULLS LAST,\n AwardType","inputQueryString":"-- Returns normalized awards and display badges for the selected player profile.\n\nWITH normalized_awards AS (\n SELECT\n RowID,\n PlayerID,\n SportCode,\n Player,\n District,\n Region,\n Conference,\n National,\n AwardType,\n CASE\n WHEN NULLIF(TRIM(Team), '') IS NULL THEN NULL\n WHEN TRIM(Team) = 'F' THEN 'Freshman'\n WHEN TRIM(Team) = '1' THEN 'First'\n WHEN TRIM(Team) = '2' THEN 'Second'\n WHEN TRIM(Team) = '3' THEN 'Third'\n ELSE TRIM(Team)\n END AS Team,\n Season,\n CASE\n WHEN AwardDate = DATE '1970-01-01' THEN NULL\n ELSE STRFTIME(AwardDate, '%Y-%m-%d')\n END AS AwardDate\n FROM SPORTS_INFO_DW_REPORTING.vw_cuad_awards\n)\nSELECT\n RowID,\n PlayerID,\n SportCode,\n Player,\n AwardType,\n Team,\n Season,\n AwardDate,\n '/individual-records' AS Url,\n CASE\n WHEN National = 'Y' THEN 'National'\n WHEN Conference = 'Y' THEN 'Conference'\n WHEN Region = 'Y' THEN 'Regional'\n WHEN District = 'Y' THEN 'District'\n ELSE 'Award'\n END AS AwardScope,\n CONCAT(\n CAST(Season AS VARCHAR),\n CASE\n WHEN AwardDate IS NULL THEN ''\n ELSE CONCAT(' - ', AwardDate)\n END\n ) AS AwardMeta,\n CASE\n WHEN Team = 'First' THEN 'First'\n WHEN Team = 'Second' THEN 'Second'\n WHEN Team = 'Third' THEN 'Third'\n WHEN Team = 'Freshman' THEN 'Freshman'\n ELSE '-'\n END AS TeamBadge\nFROM normalized_awards\nWHERE Player = '${params.PlayerName}'\nORDER BY\n CASE\n WHEN National = 'Y' THEN 1\n WHEN Conference = 'Y' THEN 2\n WHEN Region = 'Y' THEN 3\n WHEN District = 'Y' THEN 4\n ELSE 5\n END,\n Season DESC NULLS LAST,\n AwardDate DESC NULLS LAST,\n AwardType","compiled":false,"inline":false}]}

Sarah Rocheleau's Game-by-Game Stats

No Results