I have a question for one of our resident SQL experts.
Say I have a table where every record has a Name, a Type, and a Value. Let's say I've recorded D&D's Armor table: the name, the armor type (non-armor, light, medium, heavy, shield, perhaps other categories) and its purchase price.
I want to write a query that extracts the following: 1. Every Light armor, sorted by value, then 2. Every Medium armor, sorted by value, then 3. Every other armor, sorted by value regardless of its type.
How do you do that, exactly? I can't just sort by type then by value, because that sorts the whole list by type, and I want that remainder of the list ordered regardless of type.
What I imagine right now is I run two separate SQL queries: one to grab Light and Medium armors, sorted by type then value; one to grab all non-Light non-Medium armors sorted by value.