title: Brackets use in where clause
body: <p>Case1:</p>
  
  <pre><code>SELECT *
  FROM Products
  WHERE Price NOT BETWEEN 10 AND 20
  </code></pre>
  
  <p>Case2:</p>
  
  <pre><code>SELECT *
  FROM Products
  WHERE (Price BETWEEN 10 AND 20)
  AND NOT CategoryID IN (1,2,3)
  </code></pre>
  
  <p>Why is case 2 brackets are used after <code>Where</code>, what is the reason behind this and it's logic?</p>