title: SQL Subselect calculated in one row
body: <p>I have a trouble getting an SQL select to work.</p>
  <p>I have one table - below is the example:</p>
  <pre><code>|id|name  |hits|
  |1 |peter | 6  |
  |2 |john  | 13 |
  |3 |max   | 12 |
  |4 |foo   | 8  |
  |5 |bar   | 4  |
  </code></pre>
  <p>I want to calculate the sum of every entry under 10 hits and every entry over 10 hits in one output.</p>
  <p>Like below:</p>
  <pre><code>|sum-over-10|sum-under-10|
  | 25        | 18         |
  </code></pre>
  <p>I tried inner join and outer join but I think that's the wrong approach. If I do a subselect it always filters by the main select.</p>
  <p>Don't know how to start here :-)
  Will be glad and thankful for any advice!</p>