#databases

? Why does my SQL query treat NULL = NULL as neither true nor false?

Beginner question from a data analyst. Last week a report of mine undercounted customers by about four per cent. The bug was a filter like WHERE region 'KL', which I assumed would return everyone outside Kuala Lumpur. It also silently dropped every…