Coalesce for zero instead of null

You can combine NULLIF with COALESCE:

SELECT company, COALESCE(NULLIF(turnover, 0), revenue) AS revenue FROM company_profile;

NULLIF returns NULL if it's arguments are equal, and the first argument otherwise.