SQL query (AND & OR) mix up
<p>help me understand why i am getting different COUNTS</p>

<p>Query 1</p>

<pre><code>SELECT Count(*) 
FROM   `foo` 
WHERE  `status_id` = 2 
       AND `updated_at` &lt; Date(Now() - INTERVAL 1 day) 
       AND `number` LIKE 'A390%' 
        OR `number` LIKE 'A391%' 
        OR `number` LIKE 'A392%' 
</code></pre>

<blockquote>
  <p>results = 20000</p>
</blockquote>

<p>Query 2</p>

<pre><code>SELECT Count(*) 
FROM   `foo` 
WHERE  `status_id` = 2 
       AND `updated_at` &lt; Date(Now() - INTERVAL 1 day) 
       AND ( `number` LIKE 'A390%' 
              OR `number` LIKE 'A391%' 
              OR `number` LIKE 'A392%' ) 
</code></pre>

<blockquote>
  <p>results = 14967</p>
</blockquote>

<hr>

<pre><code>SELECT Count(*) 
FROM   `foo` 
WHERE  `status_id` = 2 
       AND `updated_at` &lt; Date(Now() - INTERVAL 1 day) 
       AND `number` LIKE X 
</code></pre>

<p>running the above query for each (A390, A391 ,A392) separately gives me:</p>

<blockquote>
<pre><code>'A390%' = 0; 
'A391%' = 1496; 
'A392%' = 10000;
</code></pre>
</blockquote>

<p>EDIT:
Adding Screenshots to make it more clear. i had to do some photoshop to change the table name</p>

<p><a href="https://i.stack.imgur.com/r8YM8.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/r8YM8.jpg" alt="Query 1"></a></p>

<p><a href="https://i.stack.imgur.com/lMzMP.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lMzMP.jpg" alt="Query 2"></a></p>

<p><a href="https://i.stack.imgur.com/1kucP.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1kucP.jpg" alt="Query 3"></a></p>

<p><a href="https://i.stack.imgur.com/ClDAC.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ClDAC.jpg" alt="Query 4"></a></p>

<p><a href="https://i.stack.imgur.com/Uvrka.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Uvrka.jpg" alt="Query 5"></a></p>