title: Need SQL query for following:
body: <pre><code>bug_id     ops_status   partition_date
  32307107    ARCHIVED    2017-04-14
  32307107    ARCHIVED    2017-04-13
  32307107    ARCHIVED    2017-04-12
  32307107    ARCHIVED    2017-04-11
  32307107    ARCHIVED    2017-04-10
  32307107    ARCHIVED    2017-04-09
  32307107    ARCHIVED    2017-04-08
  32307107    ARCHIVED    2017-04-07
  32307107    ARCHIVED    2017-04-06
  32307107    PREPUBLISH  2017-04-05
  32307107    PREPUBLISH  2017-04-04
  32307107    PREPUBLISH  2017-04-03
  32307107    PREPUBLISH  2017-04-02
  32307107    PREPUBLISH  2017-04-01
  32307107    ARCHIVED    2017-03-31
  32307107    ARCHIVED    2017-03-30
  32307107    ARCHIVED    2017-03-29
  32307107    ARCHIVED    2017-03-28
  32307107    ARCHIVED    2017-03-27
  32307107    ARCHIVED    2017-03-26
  </code></pre>
  
  <p>I need last ops_status i.e ARCHIVED and when it is updated i.e "2017-04-06"  - so the <code>"32307107    ARCHIVED    2017-04-06"</code> row from the above data. Can some one please help me. </p>