D&D 3.5 sorcerer/wizard spells by level
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE VIEW spell_names AS | |
SELECT name, min(level) as lvl | |
FROM dnd_spell | |
INNER JOIN dnd_spellclasslevel | |
ON dnd_spell.id = spell_id | |
WHERE dnd_spellclasslevel.character_class_id in (SELECT id FROM dnd_characterclass WHERE name ="Wizard" OR name = "Sorcerer") | |
GROUP BY name; | |
SELECT lvl, count(name) | |
FROM spell_names | |
GROUP BY lvl | |
ORDER BY lvl DESC; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment