Database Sql select statement : [provided the database below how do i solve this question?][1]


[my sql statement is: select ename from employee e inner join certified c on e.eid = c.eid inner join aircraft a on c.aid = a.aid where cruisingrange> 1000 && a.aname not like'%b'][2]
My answer is Jacob and Emily which is wrong. Jacob should not be retrieved. How should i modify or add to the sql statement? 

  [1]: http://i.stack.imgur.com/Ohghh.jpg
  [2]: http://i.stack.imgur.com/Go4f6.jpg