Query 3. Players averaging at least 15 points with minimum game volume

Players averaging at least 15 points with minimum game volume.

capture the result grid in phpMyAdmin after running the query.

SELECT
    s.season_label,
    p.first_name,
    p.last_name,
    t.team_name,
    ROUND(AVG(pgs.points), 1) AS ppg,
    COUNT(*) AS games_played
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 = g.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
HAVING COUNT(*) >= 20 AND AVG(pgs.points) >= 15
ORDER BY s.season_id DESC, ppg DESC, p.last_name ASC;