if sub select null default value mysql code example

Example: mysql select default if null

IFNULL(MAX(EMAIL), "[email protected]") as email