This query might seem simple, but it can lead to unexpected results if the `salary` column contains NULL values. The condition `salary > 100000` will evaluate to `UNKNOWN` for NULL salaries, and ...