COALESCE Step by Step

A compact COALESCE-expression book for readers who need exact finite NULL-default behavior: base rows, first non-NULL arguments, column fallback, literal default fallback, all-NULL results, source-order output, the contrast with WHERE filtering, and guarded expected facts.