title: Select Customers who purchased one specific Product
body: <p>We have two tables:</p>
  
  <ol>
  <li>Customers:</li>
  </ol>
  
  <p><a href="https://i.stack.imgur.com/ZwTH0.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ZwTH0.png" alt="enter image description here"></a></p>
  
  <ol start="2">
  <li>Products:</li>
  </ol>
  
  <p><a href="https://i.stack.imgur.com/OPI6m.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/OPI6m.png" alt="enter image description here"></a></p>
  
  <p>The goal is to select [Id] and [CustomerName] of Customers who purchased Milk <strong>AND</strong> did not purchase Bread. In the case the correct query should return a customer with Id 2 (Ann).</p>
  
  <p>The query which I thought of (and which is obviously incorrect) is:</p>
  
  <pre><code>select CustomerName from dbo.Customers
  where Id in 
  (
    select CustomerId from dbo.Products
    where ProductName = 'Milk' and ProductName != 'Bread'
  )
  </code></pre>
  
  <p>It returns two customers: 1 (John) and 2 (Ann).
  How to rewrite the query so it would return only customer with Id 2?</p>