title: SQL dividing 2 values from 2 queries
body: <p>I have 2 queries that are as follows:</p>
  
  <pre><code>  SELECT COUNT(cvu.[ID]), 'Exp' AS [Exp]
      FROM [dbo].[tblClientVehicleUnit] cvu
      WHERE ExpirationDate &lt; GetDate()
      AND cvu.Id = '4C1'
  </code></pre>
  
  <p>And the second one:</p>
  
  <pre><code>SELECT COUNT(cvu.[ID]), 'NonExp' AS [Exp]
      FROM [dbo].[tblClientVehicleUnit] cvu
      WHERE ExpirationDate &gt; GetDate()
      AND cvu.Id = '4C1'
  </code></pre>
  
  <p>How would I divide the counts between these two? It will always only return 2 values and one will be called Exp and one will be called NonExp.</p>
  
  <p>Thanks</p>