Query 10. Players above the season scoring average using a subquery

Players above the season scoring average using a subquery.

capture the result grid in phpMyAdmin after running the query.

SELECT
    player_lines.season_label,
    player_lines.player_name,
    player_lines.team_name,
    player_lines.ppg,
    season_avg.avg_ppg AS season_average
FROM (
    SELECT
        s.season_id,
        s.season_label,
        p.person_id,
        CONCAT(p.first_name, ' ', p.last_name) AS player_name,
        t.team_name,
        ROUND(AVG(pgs.points), 1) AS ppg
    FROM player_game_stats pgs
    INNER JOIN games g ON g.game_id = pgs.game_id
    INNER JOIN seasons s ON s.season_id = g.season_id
    INNER JOIN people p ON p.person_id = pgs.person_id
    INNER JOIN roster_assignments ra ON ra.person_id = pgs.person_id AND ra.season_id = s.season_id
    INNER JOIN teams t ON t.team_id = ra.team_id
    GROUP BY s.season_id, s.season_label, p.person_id, p.first_name, p.last_name, t.team_name
) AS player_lines
INNER JOIN (
    SELECT
        season_id,
        ROUND(AVG(ppg), 1) AS avg_ppg
    FROM (
        SELECT g.season_id, pgs.person_id, AVG(pgs.points) AS ppg
        FROM player_game_stats pgs
        INNER JOIN games g ON g.game_id = pgs.game_id
        GROUP BY g.season_id, pgs.person_id
    ) AS per_player
    GROUP BY season_id
) AS season_avg
    ON season_avg.season_id = player_lines.season_id
WHERE player_lines.ppg > season_avg.avg_ppg
ORDER BY player_lines.season_id DESC, player_lines.ppg DESC;