title: Oracle/SQL - Grouping items by action by day over time
body: <p>Hi all I have a 'widget' table that has the following columns: widget, action, timestamp_. What we want to do is pull all the widgets that were rejected more than once a day between certain dates. So here's an example table</p>
  
  <pre><code>widget      action      timestamp_
  -------------------------------------------
  type1       reject      2011-05-10 08:00:00
  type1       reject      2011-05-10 09:00:00
  type1       reject      2011-05-10 09:30:00
  type2       reject      2011-05-11 09:30:00
  type3       reject      2011-05-11 09:30:00
  type1       reject      2011-05-11 09:30:00
  type1       reject      2011-05-11 09:30:00
  type2       reject      2011-05-12 10:30:00
  type2       reject      2011-05-12 12:30:00
  type3       reject      2011-05-12 12:30:00
  </code></pre>
  
  <p>So I anticipate wanting to see results in one of these two manners....</p>
  
  <p>Between date x and y there were two widgets that were rejected multiple times in single days</p>
  
  <p>This would see that type1 was rejected more than once in a day as was type2 thus the count is: 2</p>
  
  <p>OR</p>
  
  <p>Display each widget along with the date that it was rejected more than once and how many times.  Example..</p>
  
  <pre><code>widget      date            count
  ---------------------------------
  type1       2011-05-10      3
  type1       2011-05-11      2
  type2       2011-05-12      2
  </code></pre>
  
  <p>This would probably be the preferred output... but how?</p>
  
  <p>Thanks in advance!</p>