CODE EXAMPLE FOR SQL

mysql select default if null

IFNULL(MAX(EMAIL), "example@google.com") as email