📊 Report 4: Player Stats Summary

SELECT CONCAT(p.first_name, ' ', p.last_name) AS player_name, p.position, p.jersey_number, t.team_name, COUNT(ps.stat_id) AS games_played, SUM(ps.minutes_played) AS total_minutes, ROUND(AVG(ps.minutes_played), 1) AS avg_minutes, SUM(ps.points) AS total_points, ROUND(AVG(ps.points), 1) AS avg_points, SUM(ps.assists) AS total_assists, ROUND(AVG(ps.assists), 1) AS avg_assists, SUM(ps.rebounds) AS total_rebounds, ROUND(AVG(ps.rebounds), 1) AS avg_rebounds, SUM(ps.steals) AS total_steals, SUM(ps.blocks) AS total_blocks, SUM(ps.points) + SUM(ps.assists) + SUM(ps.rebounds) AS total_contribution FROM player_stat ps JOIN player p ON p.player_id = ps.player_id LEFT JOIN team t ON t.team_id = p.team_id GROUP BY p.player_id ORDER BY total_contribution DESC;