SQL queryWITH pool AS (
SELECT
player_name,
progressive_passes_per90 AS progression,
key_passes_per90 AS creation,
xg_per90 AS goal_threat,
take_ons_successful_per90 AS carrying,
goals/nineties AS finishing
FROM reporting.player_season_profile
WHERE season='2026'
AND minutes_played>=900
AND (position='AMC'
OR player_name IN ('Martin Odegaard','Eberechi Eze','Morgan Rogers')) ), ranked AS (
SELECT
player_name,
ROUND(100*percent_rank() OVER (
ORDER BY progression))::int AS progression, ROUND(100*percent_rank() OVER (
ORDER BY creation))::int AS creation, ROUND(100*percent_rank() OVER (
ORDER BY goal_threat))::int AS goal_threat, ROUND(100*percent_rank() OVER (
ORDER BY carrying))::int AS carrying, ROUND(100*percent_rank() OVER (
ORDER BY finishing))::int AS finishing
FROM pool )
SELECT *
FROM ranked
WHERE player_name IN ('Martin Odegaard','Eberechi Eze','Morgan Rogers')
ORDER BY player_name