ORDER BY SUB_TENP DESC, CHNG_DATE DESC, CASE WHEN DEL_DATE IS NULL THEN DEL_DATE ASC ELSE DEL_DATE DESC END, TENP_KN DESC ...