SQL querywith mids as (
select player_name, team_name,
percent_rank() over (order by progressive_passes_per90) as prog,
percent_rank() over (order by passes_into_final_third_per90) as f3,
percent_rank() over (order by key_passes_per90) as kp,
percent_rank() over (order by xa_per90) as xa,
percent_rank() over (order by pass_accuracy_pct) as acc,
percent_rank() over (order by take_ons_successful_per90) as tos,
percent_rank() over (order by tackles_per90) as tk,
percent_rank() over (order by interceptions_per90) as intc
from reporting.player_season_profile
where season='2026' and position in ('MC','DMC','AMC') and minutes_played>=1000
)
select player_name as "Player",
round(prog*100) "Progressive Passes",
round(f3*100) "Passes Final Third",
round(kp*100) "Key Passes",
round(xa*100) "xA",
round(acc*100) "Pass Accuracy",
round(tos*100) "Take-ons",
round(tk*100) "Tackles",
round(intc*100) "Interceptions"
from mids
where (player_name ilike '%vitinha%' and team_name ilike '%paris%')
or (player_name ilike '%neves%' and team_name ilike '%paris%')
or (player_name ilike '%bruno fernand%' and team_name ilike '%manchester united%')
order by player_name;