SyntaxFix
Write A Post
Hire A Developer
Questions
For someone who is new to ORDER BY with CASE this may be useful
ORDER BY CASE WHEN GRADE = 'A' THEN 0 WHEN GRADE = 'B' THEN 1 ELSE 2 END