Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
-- Question 1 :
SELECT `last_name`, `first_name`, `role`, `team_id`
FROM `wizard` JOIN `player`
ON wizard.id = player.id
ORDER BY `team_id`, `role`, `last_name`, `first_name`;
-- Question 2 :
SELECT `first_name`, `last_name`
FROM `wizard` JOIN `player`
ON wizard.id = player.id
WHERE `role` = 'seeker'
ORDER BY `last_name`, `first_name`;
-- Question 3 :
SELECT *
FROM `wizard` LEFT JOIN `player`
ON wizard_id = wizard.id
WHERE `wizard_id` IS NULL;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment