Quest5_database_mysql

wild_db_quest.sql

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


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


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