title: Need a twin group by value
body: <p>I have a query something like this,</p>
  
  <pre><code>SELECT SOME_ID, COUNT(ANOTHER_ID) AS WITHOUT_FILTER 
  from SOME_TABLE GROUP BY SOME_ID
  </code></pre>
  
  <p>this returns me</p>
  
  <pre><code>+------------+------------------+
  | SOME_ID    | WITHOUT_FILTER   |
  +------------+------------------+
  |  1         | 40               |
  |  2         | 30               |
  +------------+------------------+
  </code></pre>
  
  <p>I have the same query with a condition which gives me filtered values.</p>
  
  <pre><code>SELECT SOME_ID, COUNT(ANOTHER_ID) AS WITH_FILTER 
  from SOME_TABLE WHERE SOME_COL &gt; 10 GROUP BY SOME_ID
  </code></pre>
  
  <p>which returns obviously lesser values in the grouped_by section</p>
  
  <pre><code>+------------+----------------+
  | SOME_ID    | WITH_FILTER    |
  +------------+----------------+
  |  1         | 20             |
  |  2         | 15             |
  +------------+----------------+
  </code></pre>
  
  <p>Now, I need a query to give me both the count values ie with condition and without condition in one single query. The result should be like this</p>
  
  <pre><code>+----------+----------------+---------------+
  | SOME_ID  | WITHOUT_FILTER | WITH_FILTER   |
  +----------+----------------+---------------+
  |  1       | 40             | 20            |
  |  2       | 30             | 15            |
  +------------+--------------+---------------+
  </code></pre>
  
  <p>Please help me.</p>