title: SQL: Update a column after a specific number of days
body: <p>I have a table that lists the bugs along with the info regarding to who it was assigned and who resolved it.</p>
  
  <pre><code>Bugs | Assigned to | Resolved by
  --------------------------------
    1       Dev1 
    2       Dev2
    3       Dev3
  </code></pre>
  
  <p>If after a specific number of days (for e.g., 14 days), if the field 'Resolved by' is still blank, I want it to be updated with the value from the column 'Assigned to'.</p>
  
  <p>I was trying to create a view with a time stamp but I'm not sure how to specify the exact number of days and then update the value from another column.    </p>