Complex Where Filter (using and, or, not)

Thanks a lot for your answer! Where can I find an example,it would be wonderful!