How do you handle NULL values and conditional mapping in SQL, e.g. mapping values like A to Apple, B to Banana?

Question

Tests whether you reach for CASE WHEN (or COALESCE for defaults) to express conditional mapping declaratively, and know that NULL never equals NULL so comparisons need IS NULL rather than = NULL.

How do you handle NULL values and conditional mapping in SQL, e.g. mapping values like A to Apple, B to Banana?

Next Step