title: SQL Query for finding longest streak of wins
body: <p>I have data like below - </p>
  
  <pre><code>Year,winning_country
  2001,IND
  2002,IND
  2003,IND
  2004,AUS
  2005,AUS
  2006,SA
  2007,SA
  2008,SA
  2009,IND
  2010,IND
  2011,IND
  2012,IND
  2013,AUS
  2014,AUS
  2015,SA
  2016,NZ
  2017,SL
  2018,IND
  </code></pre>
  
  <p>The question here is to find out the longest streak of wins for each country and desired output will be like below -</p>
  
  <pre><code>Country,no_of_wins
  IND,4
  AUS,2
  SA,3
  SL,1
  NZ,1
  </code></pre>
  
  <p>Can someone help here.</p>