How to handle NULL (empty fields) and common pitfalls

For those new to data analysis, I will explain how to handle NULL (empty fields), where mistakes are most common in SQL, ...