title: Query based on some data multiple compare
body: <p>Table:</p>
  
  <p><a href="https://i.stack.imgur.com/O7LiL.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/O7LiL.png" alt="enter image description here"></a></p>
  
  <p>How do i bring the period when customers have max cc_limit? 
  If the cc_limits same for customer for more than one month, take the period with highest year-month data</p>