As you can see, IS NULL is useful when combined with WHERE to figure out what data you're missing. Sometimes, you'll want to filter out missing values so you only get results which are not NULL. To do ...