SQL queryWITH pool AS (
SELECT
player_name,
take_ons_successful_per90 AS dribbling,
xg_per90 AS goal_threat,
key_passes_per90 AS creation,
crosses_per90 AS crossing,
goals/nineties AS finishing
FROM reporting.player_season_profile
WHERE season='2026'
AND minutes_played>=900
AND (position IN ('FWR','FWL','AMR','AML')
OR player_name IN ('Morgan Rogers','Bukayo Saka','Leandro Trossard','Gabriel Martinelli','Noni Madueke')) ), ranked AS (
SELECT
player_name,
ROUND(100*percent_rank() OVER (
ORDER BY dribbling))::int AS dribbling, ROUND(100*percent_rank() OVER (
ORDER BY goal_threat))::int AS goal_threat, ROUND(100*percent_rank() OVER (
ORDER BY creation))::int AS creation, ROUND(100*percent_rank() OVER (
ORDER BY crossing))::int AS crossing, ROUND(100*percent_rank() OVER (
ORDER BY finishing))::int AS finishing
FROM pool )
SELECT *
FROM ranked
WHERE player_name IN ('Morgan Rogers','Bukayo Saka','Leandro Trossard','Gabriel Martinelli','Noni Madueke')
ORDER BY player_name