sql change uppercase to proper case code example

Example: how to write uppercase in sql

SELECT UPPER(FIRST_NAME) , LOWER(LAST_NAME)
FROM CUSTOMERS ;