A sales table stores missing discount values as NULL. The agreed business rule is to treat missing discounts as zero in a calculation without altering stored rows. Which expression fits?

Published
  1. COUNT(discount)
  2. NULLIF(discount, 0)
  3. discount = NULL
  4. COALESCE(discount, 0)

Comments — 0