title: SQL Order of Conditions
body: <p>I have the following SQL statement:</p>
  
  <pre><code>SELECT * FROM PRODUCTS WHERE price= 6000 AND price &lt; 8000 OR price = 10000;
  </code></pre>
  
  <p>I have tested it out at it returns all the products which have the price of 6000 or 10000. However, I have tried doing some research on which order the statements are read in this case and could not find anything. I am struggling to understand it and cannot clearly set it up straight in my head. </p>
  
  <p>What if the two conditions were reversed or what if we have multiple AND/OR conditions that are not separated by parentheses? How will the system interpret more than two conditions which are not delimited?</p>