SQL querySELECT
CASE WHEN player_name ILIKE '%valverde%' THEN 'Valverde (23/24 CM)' ELSE player_name END AS "Player",
round(progressive_passes_per90,1) AS "Progressive Passes",
round(passes_into_final_third_per90,1) AS "Passes Final Third",
round(key_passes_per90,1) AS "Key Passes",
round(take_ons_successful_per90,1) AS "Take-ons",
round(tackles_per90,1) AS "Tackles",
round(defensive_actions_per90,1) AS "Defensive Actions",
round(xa_per90,2) AS "xA"
FROM reporting.player_season_profile
WHERE (season='2026'
AND ( (player_name ILIKE '%mateus fernandes%'
AND team_name='West Ham')
OR (player_name ILIKE '%enzo fern%'
AND team_name='Chelsea')
OR (team_name='Real Madrid'
AND player_name IN ('Aurelien Tchouameni','Eduardo Camavinga')) ))
OR (season='2024'
AND team_name='Real Madrid'
AND player_name ILIKE '%valverde%')
ORDER BY CASE WHEN player_name ILIKE '%mateus fernandes%' THEN 0 WHEN player_name ILIKE '%enzo fern%' THEN 1 ELSE 2 END, "Player"