SELECT 
    CODE, 
    CASE 
        WHEN ENG_NAME IS NULL THEN 'NULL'
        ELSE UPPER(ENG_NAME)
    END AS ENG_NAME_UPPER
FROM 
    (SELECT EMP_CODE AS CODE, EMP_ENG_NAME AS ENG_NAME FROM EMP ORDER BY CODE DESC) AS subquery;