What are some tips about nulls in SQL you can share? As GIS professionals, not SQL developers, it's easy to make mistakes when dealing with nulls in SQL.
For example:
Are there any other gotchas or tips about nulls you can share? Or any improvements or corrections to the points above?
Related:
Don't use them
The solution to <null> in tables - Esri Community
query out the defaults before using the remainder
Somewhat tongue-in-cheek, but setting a value to replace a null, which as you point out, enables you to get at valid data.
The downside is that it requires an extra step to get there.
There are some good comments in this sister post: