SQL queryselect
case when player_name ilike '%vuskovic%' then 'Spurs CB (on loan)'
when player_name ilike '%lewis dunk%' then 'Brighton reference'
else 'Spurs CB option' end as grp,
case when player_name ilike '%van hecke%' then 'van Hecke'
when player_name ilike '%van de ven%' then 'van de Ven'
when player_name ilike '%senesi%' then 'Senesi'
when player_name ilike '%vuskovic%' then 'Vušković'
else 'Dunk (ref)' end as label,
round(progressive_passes_per90::numeric,2) as prog_passes_per90,
round(pass_accuracy_pct::numeric,1) as pass_accuracy_pct
from reporting.player_season_profile
where position='DC' and season='2026' and minutes_played>=900
and (player_name ilike '%van hecke%' or player_name ilike '%van de ven%'
or player_name ilike '%senesi%' or player_name ilike '%lewis dunk%'
or player_name ilike '%vuskovic%');