SQL queryWITH pool AS (
SELECT player_name,
progressive_passes_per90 AS progression,
passes_into_final_third_per90 AS final_third,
long_balls_per90 AS long_passing,
aerial_win_pct AS aerial_duels,
tackles_per90 AS tackling,
interceptions_per90 AS interceptions
FROM reporting.player_season_profile
WHERE season='2026' AND minutes_played>=900 AND position='DC'
),
ranked AS (
SELECT player_name,
ROUND(100*percent_rank() OVER (ORDER BY progression))::int AS progression,
ROUND(100*percent_rank() OVER (ORDER BY final_third))::int AS final_third,
ROUND(100*percent_rank() OVER (ORDER BY long_passing))::int AS long_passing,
ROUND(100*percent_rank() OVER (ORDER BY aerial_duels))::int AS aerial_duels,
ROUND(100*percent_rank() OVER (ORDER BY tackling))::int AS tackling,
ROUND(100*percent_rank() OVER (ORDER BY interceptions))::int AS interceptions
FROM pool
)
SELECT * FROM ranked
WHERE player_name IN ('Jan Paul van Hecke','Cristian Romero','Micky van de Ven')
ORDER BY player_name;