CREATE TABLE contact (id INTEGER, name TEXT, phone TEXT);
INSERT INTO contact VALUES (1, 'Ivy', '555-0101'), (2, 'Zoe', NULL);
-- COALESCE substitutes a fallback when the value is NULL
SELECT name, COALESCE(phone, 'no phone') AS phone
FROM contact;

COALESCE returns first non-null value