title: Multiple COUNT SELECTS from the same table in one query
body: <p>For some people it might look very simple, but I just simply can't get it.<br />
  I have multiple MS-SQL SELECT queries from the same table over and over:<br /></p>
  
  <pre><code>SELECT count(Page) as tAEC
  FROM someTable
  WHERE Page LIKE '%AEC%'
  </code></pre>
  
  <p>next one</p>
  
  <pre><code>SELECT count(Page) as tTOL
  FROM someTable
  WHERE Page LIKE '%TOL%'
  </code></pre>
  
  <p>and so on...<br /></p>
  
  <p>What would be more efficient way to write this query. I Googled bunch of similar questions but I couldnt make any of them to work. So any help is greatly appreciated.</p>