SQL querySELECT
player_name,
team_name,
position,
minutes_played,
ROUND((take_ons_successful / (minutes_played / 90.0))::numeric, 2) AS successful_take_ons_per90,
ROUND((defensive_actions / (minutes_played / 90.0))::numeric, 2) AS defensive_actions_per90,
ROUND((tackles / (minutes_played / 90.0))::numeric, 2) AS tackles_per90,
ROUND((interceptions / (minutes_played / 90.0))::numeric, 2) AS interceptions_per90,
ROUND((progressive_passes / (minutes_played / 90.0))::numeric, 2) AS progressive_passes_per90,
ROUND((key_passes / (minutes_played / 90.0))::numeric, 2) AS key_passes_per90,
ROUND((xg / (minutes_played / 90.0))::numeric, 3) AS xg_per90,
ROUND((xa / (minutes_played / 90.0))::numeric, 3) AS xa_per90
FROM reporting.player_season_profile
WHERE season = '2026'
AND ( player_name ILIKE '%Bouaddi%'
OR ( team_name ILIKE '%Arsenal%'
AND position IN ('DMC', 'MC', 'DM')
AND minutes_played >= 900 ) )
AND minutes_played > 0
ORDER BY successful_take_ons_per90 DESC
LIMIT 50