How do you write IF ELSE statement in a MySQL query?

SELECT id, name, email, salary, IF(salary > 20000, 'Good', 'Average') AS type FROM `customers`;