title: Update record for the last week
body: <p>I'm building a report that needs to show how many users were upgraded from account status 1 to account status 2 each hour for the last week (and delete hours where the upgrades = 0). My table has an updated date, however it isn't certain that the account status is the item being updated (it could be contact information etc).</p>
  
  <p>The basic table config that I'm working with is below. There are other columns but they aren't needed for my query. </p>
  
  <p>account_id, account_status, updated_date.</p>
  
  <p>My initial idea was to first filter and look at the data for the current week, then find if they were at account_status = 1 and later account_status = 2. </p>
  
  <p>What's the best way to tackle this?</p>