SQL Quest #2

wizard.sql

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

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

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