Query only returns results for CAD

The query that I was helped with the other day, does run, however only returns results on some customers. Not all customers. and only customers that purchase in CAD.

How can i find out why it is doing this? I don't have any 'selections' area in the "advanced" tab

Can someone please give me some guidance?

Thank you!!