title: Comparing two tables that are the same and listing out the max date
body: <p>I was wondering if it's possible to compare dates within the <strong>same</strong> table with same ID, but the catch is that there is an additional column that display the status. For instance, here's a table A:</p>
  
  <p><img src="https://i.stack.imgur.com/34tqU.png" alt="Original Table"></p>
  
  <hr>
  
  <p>The results I would like to see is this:</p>
  
  <p><img src="https://i.stack.imgur.com/pR57M.png" alt="Results"></p>
  
  <p>I know I could use a group by and max aggregate with ID to find the max date; however, I would like the status (Running/Stopped) column associated to be there. It would help me a lot.</p>