title: Rank and date change case expression
body: <p>I am trying to show the second part below. If a person goes from high to low it is good but if they go from low to high it is bad. Any ideas on how I'd accomplish this? I have the SQL to return the top part but not sure how to get the second part.</p>
  
  <p><a href="https://i.stack.imgur.com/YI8Qg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/YI8Qg.png" alt="enter image description here"></a></p>