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,
tackles_per90 AS tackling,
interceptions_per90 AS interceptions
FROM reporting.player_season_profile
WHERE season='2026'
AND minutes_played>=900
AND position IN ('MC','DMC','DM') ), 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 tackling))::int AS tackling, ROUND(100*percent_rank() OVER (
ORDER BY interceptions))::int AS interceptions
FROM pool )
SELECT *
FROM ranked
WHERE player_name IN ('Sandro Tonali','João Palhinha','Rodrigo Bentancur','Archie Gray','Conor Gallagher')
ORDER BY player_name