joinquest.sql

SELECT wizard.firstname, wizard.lastname, player.role, team.name FROM player
INNER JOIN team ON team.id = player.team_id
INNER JOIN wizard ON wizard.id = player.wizard_id
ORDER BY team.name, player.role, wizard.lastname, wizard.firstname;

SELECT wizard.firstname, wizard.lastname FROM player
INNER JOIN wizard ON wizard.id = player.wizard_id
WHERE player.role = 'seeker'
ORDER BY wizard.lastname, wizard.firstname;

SELECT wizard.firstname, wizard.lastname FROM player
RIGHT JOIN wizard ON wizard.id = player.wizard_id
WHERE player.role IS NULL;