为什么我的查询返回不正确的结果？

I recently asked a similar question to this about two weeks ago, but I have had no look in getting my problem working the way I need it to.I recently asked a similar question to this abo