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

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

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