This website uses cookies to ensure you get the best experience.
Learn more.
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
- COUNT(discount)
- NULLIF(discount, 0)
- discount = NULL
- COALESCE(discount, 0)
Comments — 0
Sign in to comment