Task: SQL ORDER BY Multiple Values in Specific Custom Order

Task: SQL ORDER BY Multiple Values in Specific Custom Order: a task in Terminal-Lego-15k (Harbor dataset). Create a PostgreSQL solution that orders query results by a non-indexed field using a custom-specified order (not alphabetical, not numerical — a user-defined priority order).