title: Why parenthesis around a SELECT change the results?
body: <p>So, I have this Query:</p>
  
  <pre><code>SELECT id, name FROM artist WHERE artist.name LIKE '%feat.%'
  </code></pre>
  
  <p>From which, the results are these:</p>
  
  <p><a href="https://i.stack.imgur.com/DoKv5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/DoKv5.png" alt="enter image description here"></a></p>
  
  <p>If I place parenthesis around the Query like this:</p>
  
  <pre><code>(SELECT id, name FROM artist WHERE artist.name LIKE '%feat.%')
  </code></pre>
  
  <p>From which, the results are these:</p>
  
  <p><a href="https://i.stack.imgur.com/1c3mI.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1c3mI.png" alt="enter image description here"></a></p>
  
  <p><strong>The results change!</strong> Why?
  It's not like there is some kind of Order of Operations. It's one <strong>SELECT</strong> alone sitting there.</p>
  
  <hr>
  
  <p>Would you like to reproduce it? Here's the link to the database's data and schema.</p>
  
  <p><a href="https://www.dropbox.com/s/0xr2wgf7k3e7ver/db_stackoverflow.sql?dl=0" rel="nofollow noreferrer">DB Schema and Data</a></p>