title: How to use "and" and "or" in a "Where" clause
body: <p>I have a query that is gathering information based on a set of conditions.  Basically I want to know if a location has paid out more than $50 for the day OR the comment section has the word "filter" in it...</p>
  
  <p>My query is:</p>
  
  <pre><code>SELECT        Store_Id, Paid_Out_Amount, Paid_Out_Comment, Paid_Out_Datetime, Update_UserName, Till_Number
  FROM            Paid_Out_Tb
  WHERE        (Store_Id = 1929) AND (Paid_Out_Datetime &gt;= DATEADD(day, DATEDIFF(day, 0, GETDATE()) - 1, 0)) AND (Paid_Out_Datetime &lt; DATEADD(day, DATEDIFF(day, 0, 
                           GETDATE()), 0)) AND (Paid_Out_Amount &gt; 50) OR
                           (Paid_Out_Comment LIKE N'%' + 'Filter' + '%')
  </code></pre>
  
  <p>The problem is It returns 460 results and should only return 2.</p>