OR + AND combination in FETCH

The above code will search for the below condition
Last name should be “Joe”
First name can be “Geoffrey” (or)
First name can be “Lavanya”