title: In SQL Server, how to get number of players dropping vs. those renewing their monthly sport from start and end date
body: <ul>
  <li>Start date ='2020-05-01'</li>
  <li>End date ='2020-10-01'</li>
  </ul>
  
  <p>The data in SQL Server</p>
  
  <p>[![enter image description here][1]][1]</p>
  
  <pre><code>+----------+------------------+-----------------------+
  | PlayerID | AdmissionMonthID | MonthsBetweenTwoDates |
  +----------+------------------+-----------------------+
  |        3 |                5 |                     5 |
  |        3 |                6 |                     6 |
  |        3 |                7 |                     7 |
  |        6 |                5 |                     5 |
  |        6 |                6 |                     6 |
  |       10 |                5 |                     5 |
  |       10 |                6 |                     6 |
  |       10 |               10 |                    10 |
  |       11 |                5 |                     5 |
  |       11 |                6 |                     6 |
  |       11 |                7 |                     7 |
  |       11 |                8 |                     8 |
  |       11 |                9 |                     9 |
  |       11 |               10 |                    10 |
  +----------+------------------+-----------------------+
  </code></pre>
  
  <p>The expected result</p>
  
  <pre><code>dropping 
  --------
   2
   3
   6
  10
  
  renewing monthly
  ----------------
  11
  </code></pre>