Dealing with NULL Values in SQL | SQL Bits | Kovolff
Channel: prelearn
Date: 01/02/2021

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