SQL case with order ascending and descending column type - Stack Overflow

SQL case with order ascending and descending column type - Stack Overflow