title: Merging two (or more) "group by" like query result table
body: <p>I have a table like this:  </p>
  
  <pre class="lang-none prettyprint-override"><code>name area timestamp  
  aa   10   timestamp  
  aa   12   timestamp  
  aa   22   timestamp  
  bb   11   timestamp  
  bb   11   timestamp  
  cc   11   timestamp  
  </code></pre>
  
  <p>I can do the followings:  </p>
  
  <pre><code>select name, sum(area) as sum1 from mytable where "condition1 based on timestamp" group by name;  
  select name, sum(area) as sum2 from mytable where "condition2 based on timestamp" group by name;
  </code></pre>
  
  <p>But what I really need should look like this: </p>
  
  <pre class="lang-none prettyprint-override"><code>name sum1 sum2  
  aa   444  555  
  bb   666  777  
  cc   111  222  
  </code></pre>
  
  <p>Any ideas what can it be done?</p>