Deviopath › PostgreSQL

Fill In Missing Emails

Easy · NULLs

COALESCE(a, b) returns the first value that is not NULL. It is the usual way to show a default instead of an empty value.

For every customer, return name and email, but show the text 'no email' when the email is missing. Keep the column name email.

Next: Price Labels