Dealing with NULL Values in SQL | SQL Bits | Kovolff
NULL = No Value
NULL values filtering:
WHERE field_name IS NULL
or
WHERE field_name IS NOT NULL
The COALESCE function replaces NULL values with values of your choice
COALESCE(field_name, null_replacement)
Data from: https://world.openfoodfacts.org/
#sql #null #coalesce #replace