title: How to grab the last value in a column per user for the last date
body: <p>I have a table that contains three columns: ACCOUNT_ID, STATUS, CREATE_DATE.</p>
  <p>I want to grab only the LAST status for each account_id based on the latest create_date.</p>
  <p><a href="https://i.stack.imgur.com/HAKTy.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/HAKTy.png" alt="enter image description here" /></a></p>
  <p>In the example above, I should only see three records and the last STATUS per that account_2.</p>
  <p>Do you know a way to do this?</p>
  <pre><code>create table TBL 1 (
  account_id int,
  status string,
  create_date date)
  </code></pre>