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 ...

This repository demonstrates a common SQL query error related to handling NULL values and ambiguous column names. The bug.sql file contains a query that produces ...