http://www.essentialsql.com/get-ready-to-learn-sql-4-query-results-using-boolean-logic
Use the Where Clause to filter your search results. In this video we cover Boolean logic, specifically what order AND and OR are evaluated and how you can use parenthesis to assist.