I have an SQLite table used by Core Data with the following elements:

Name: John
LastName: Foobar
Age: 23

Name: Bob
LastName: Baz
Age: 37

Name: Peter
LastName: Fooqux
Age: 32

Name: John
LastName: Bar
Age: 29

Those are all in a to-many relationship from another object "Company". I need to query the database and retrieve all Company objects with employees called "John" but whose last name does NOT contain "Foo".

I did go as far as to make the following predicate:

[NSPredicate predicateWithFormat:@"ANY employee.name = 'John'"];

How do I get to filter only by companies whose Johns don't have "Foo" in their last names?