Filter Data based on condition

[its_rajvir]

Hi Experts,

I am Trying to filter data based on the conditions mentioned in the attached snapshot but unable to get the results. If possible anyone please guide me with the way to get the exact result.

Thanks