title: SQL - Trying to count rows based on a date range, some rows have the same date; when rows have the same date I need them summed together
body: <p>I'm trying to figure out this query.. here is what my data set looks like:</p>
  <p><a href="https://i.stack.imgur.com/9khei.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9khei.png" alt="enter image description here" /></a></p>
  <p>I need to count how many times an employee created more than 7,000 widgets on a given day for the month of January, regardless of color. So when the completion date is the same it will SUM the Total_widgets_created then have the SUM considered for the count result.</p>
  <p>Expected result:</p>
  <p><a href="https://i.stack.imgur.com/T0yu7.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/T0yu7.png" alt="enter image description here" /></a></p>
  <p>Willy wonka's total output on 01/22 is 10,200 thus exceeding the threshold of 7,000 so I want that to be counted once. If Willy Wonka had another line with the date of 01/16/2022 for 8,500 then it would be a count of 2.</p>