title: How to tailor my result to rank rows on a yearly basis
body: <p><img src="https://i.stack.imgur.com/DhO7c.png" alt="Expected :"></p>
  
  <p><img src="https://i.stack.imgur.com/3ZjdK.png" alt="Actual"></p>
  
  <p>How to tailor my result to rank rows on a yearly basis
  Here, I need to retrieve rows for every year ordering from most recent to past and rank them based on batting Average. 
  eg: fOR YEAR 2017 - RANKS 1, 2, 3, 
  FOLLOWED BY  YEAR 2016 - RANKS 1, 2, 3, </p>