1WITH cristiano_ronaldo_match_player_stats as 
2(SELECT p.name as player, t.name as team, s.season_label as season, c.name as competition, m.date as match_date, home_teams.name as home_team, away_teams.name as away_team, mps.*
3FROM @blt.ultimate_soccer_dataset.match_player_stats mps
4     INNER JOIN @blt.ultimate_soccer_dataset.matches m on (mps.match_id = m.match_id)
5     INNER JOIN @blt.ultimate_soccer_dataset.players p on (mps.player_id = p.player_id)
6     INNER JOIN @blt.ultimate_soccer_dataset.teams t on (mps.team_id = t.team_id)
7     INNER JOIN @blt.ultimate_soccer_dataset.seasons s on (m.season_id = s.season_id)
8     INNER JOIN @blt.ultimate_soccer_dataset.competitions c on (s.competition_id = c.competition_id)
9     INNER JOIN @blt.ultimate_soccer_dataset.teams home_teams ON (m.home_team_id = home_teams.team_id)
10     INNER JOIN @blt.ultimate_soccer_dataset.teams away_teams ON (m.away_team_id = away_teams.team_id)
11WHERE p.player_id = '5b578ccf-496a-5afb-bea2-c7ece1b2c05b' -- Cristiano Ronaldo 
12      --and year(m.date) >= 2003
13)
14SELECT
15  EXTRACT(YEAR FROM match_date) - 1985 AS age,
16  COUNT(*) AS matches,
17  COUNT(*) FILTER (WHERE goals_scored > 0) AS goals,
18  ROUND(AVG(minutes_played), 1) AS avg_minutes_per_game,
19  MIN(minutes_played) AS min_minutes,
20  MAX(minutes_played) AS max_minutes,
21  SUM(minutes_played) as minutes_played,
22  ROUND(matches/goals,2) AS games_to_score,
23  ROUND(100*ROUND(COUNT(*) FILTER (WHERE goals_scored > 0)::DECIMAL / COUNT(*)::DECIMAL, 3),0) AS scoring_rate
24FROM cristiano_ronaldo_match_player_stats
25WHERE minutes_played > 0
26GROUP BY age
27ORDER BY age