Pipeline Advanced Query multiple conditions

The Quickbase Junkie has training videos, and many are free.

Also, do you use any of the third-party add-ons from juice technologies? They have an awesome new tool they are about to release called query builder which completely dumbs down the process of building complex query strings.  

Look in the second tab https://www.juicedtech.com/new-products-coming-soon