Query 4. Seasons and MVP winners using RIGHT JOIN

Seasons and MVP winners using RIGHT JOIN.

capture the result grid in phpMyAdmin after running the query.

SELECT
    s.season_label,
    COALESCE(CONCAT(p.first_name, ' ', p.last_name), 'No MVP assigned') AS mvp_winner,
    t.team_name
FROM awards a
RIGHT JOIN seasons s ON s.season_id = a.season_id AND a.award_name = 'MVP'
LEFT JOIN people p ON p.person_id = a.person_id
LEFT JOIN roster_assignments ra ON ra.person_id = a.person_id AND ra.season_id = s.season_id
LEFT JOIN teams t ON t.team_id = ra.team_id
ORDER BY s.season_id DESC;