title: How do I display the count of one field in line with another query in SQL?
body: <p>I've tried inner joins, cross joins and selecting on right inner joins and I can't seem to achieve what I want to show.</p>
  
  <p>I have a table like so</p>
  
  <pre><code>Content
  ------------
  |ID        |
  |PalletID  |
  |ProductID |
  |DateIn    |
  ------------
  </code></pre>
  
  <p>I've attached an image with a sample data set and the results I'm trying to achieve. Any help is welcome as I've been stuck on this for a few hours now.</p>
  
  <p><img src="https://i.stack.imgur.com/zBu3d.jpg" alt="enter image description here"></p>
  
  <p>Thanks</p>