Assignment Query Desk
satisfies the RIGHT JOIN requirement while listing every season and its MVP winner when available.
Query brief
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;
Live result
| Season Label | Mvp Winner | Team Name |
|---|---|---|
| 2025-26 | Nicolas Laprovittola | FC Barcelona |
| 2024-25 | Nigel Williams-Goss | Olympiacos Piraeus |
| 2023-24 | Nigel Williams-Goss | Olympiacos Piraeus |
| 2022-23 | Nigel Williams-Goss | Olympiacos Piraeus |
| 2021-22 | Nicolas Laprovittola | FC Barcelona |
| 2020-21 | Scottie Wilbekin | Fenerbahce Beko Istanbul |
| 2019-20 | Nigel Williams-Goss | Olympiacos Piraeus |
| 2018-19 | Nicolas Laprovittola | FC Barcelona |
| 2017-18 | Scottie Wilbekin | Fenerbahce Beko Istanbul |
| 2016-17 | Nigel Williams-Goss | Olympiacos Piraeus |