Can I use ORDER BY to arrange in my prefer order in SQLite?

Is it possible to use ORDER BY on a TEXT format column and arrange in my preferred order and not necessarily A-Z (ASC) or Z-A (DESC)? Or how can it be done?
For example if I want to arrange a rating in this particular order:

Extraordinary
Excellent
Good
Average
Fair
Bad

The easiest way to accomplish that, would be to assign numbers to those ratings:
1 = Extraordinary
2 = Excellent
3 = Good
4 = Average
5 = Fair
6 = Bad
Store the number instead of the text.

Then order by this number.
Saving the text in another table and then joining on select, or using a case statement to replace the numbers with the text.

2 Likes