BDD5

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

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

SELECT *
FROM wizard
LEFT JOIN player ON player.wizard_id = wizard.id
WHERE wizard_id IS NULL;