Query 13. Three-point specialists with minimum attempts

Three-point specialists with minimum attempts.

capture the result grid in phpMyAdmin after running the query.

SELECT
    s.season_label,
    CONCAT(p.first_name, ' ', p.last_name) AS player_name,
    t.team_name,
    ROUND((SUM(pgs.three_points_made) / NULLIF(SUM(pgs.three_points_attempted), 0)) * 100, 1) AS three_pct,
    SUM(pgs.three_points_attempted) AS total_attempts
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
HAVING SUM(pgs.three_points_attempted) >= 80
ORDER BY three_pct DESC, total_attempts DESC;