Different Results from Similar Queries

Some queries can look very similar but return very different results. The following figure shows this.