SELECT UPPER(FIRST_NAME) , LOWER(LAST_NAME) , SUBSTR(FIRST_NAME , 1,1) || SUBSTR(LAST_NAME , 1,1) AS INITIALS FROM EMPLOYEES ;