title: Validating a summary count column with the actual records
body: <p>I have a column in the User table 'total_approved_sales' that contains the count of all sales with status'approved'.</p>
  
  <p>My total_approved_sales column might be off for some users, so I want to list all users who's total_approved_sales doesn't equal the sum from the sales table </p>
  
  <pre><code>i.e.  select count(*) from sales where userId=@userId and status='approved'
  </code></pre>
  
  <p>Table layout looks like:</p>
  
  <pre><code>USER
  - total_approved_sales
  
  sales
  - userId
  - STATUS
  </code></pre>
  
  <p>How can I query for those users who's counts are off?</p>