ID        FirstName        LastName        Sex
---------------------------------------------------------
1         John             Reyna           M
2         Jake             Wild            M
3         Cathy            Armstrong       F
4         Jake             Earl            M 

SELECT ID, Sex 
FROM PEOPLE 
WHERE (FirstName='John' AND FirstName='Jake')
OR LastName='Wild'