Query 8. Award totals by player and club

Award totals by player and club.

capture the result grid in phpMyAdmin after running the query.

SELECT
    CONCAT(p.first_name, ' ', p.last_name) AS player_name,
    t.team_name,
    COUNT(a.award_id) AS awards_won,
    MIN(s.season_label) AS first_award_season,
    MAX(s.season_label) AS latest_award_season
FROM awards a
INNER JOIN people p ON p.person_id = a.person_id
INNER JOIN seasons s ON s.season_id = a.season_id
LEFT JOIN roster_assignments ra ON ra.person_id = a.person_id AND ra.season_id = a.season_id
LEFT JOIN teams t ON t.team_id = ra.team_id
GROUP BY p.person_id, p.first_name, p.last_name, t.team_name
HAVING COUNT(a.award_id) >= 2
ORDER BY awards_won DESC, player_name ASC;