SQL querywith pool as (
select player_name,
percent_rank() over (order by progressive_passes_per90)*100 as prog,
percent_rank() over (order by pass_accuracy_pct)*100 as acc,
percent_rank() over (order by aerials_won_per90)*100 as aerials,
percent_rank() over (order by aerial_win_pct)*100 as aerial_pct,
percent_rank() over (order by (tackles_per90+interceptions_per90))*100 as tklint,
percent_rank() over (order by goals/(minutes_played/90.0))*100 as goals
from reporting.player_season_profile
where position='DC' and season='2026' and minutes_played>=1500
)
select player_name as player,
round(prog::numeric,0) as "Progressive passing",
round(acc::numeric,0) as "Pass accuracy",
round(aerials::numeric,0) as "Aerials won",
round(aerial_pct::numeric,0) as "Aerial win %",
round(tklint::numeric,0) as "Tackles + Int",
round(goals::numeric,0) as "Goal threat"
from pool
where player_name ilike '%vuskovic%' or player_name ilike '%van hecke%'
or player_name ilike '%van de ven%' or player_name ilike '%senesi%';